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 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 ...

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.