Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
I have about 50 excel spreadsheets all saved in separate files but they all have the exact same format. I need to basically consolidate all of the data.<BR><BR>Is there a way, using VBA, to read in ...