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.Is there a way, using VBA, to read in data ...

The file I'm attempting to open is an XLSX file. According to everything I've read this is the correct connection string for an XLSX file.

The FILENAME statement and FILENAME function associate a SAS fileref (file reference name) with the operating environment's name for an external file. This is equivalent to allocating a physical file ...