Hi All
I have been using the following macro to link to multiple CSV files in a folder.
Would anyone know how to change it so that the linked tables don't include the ".CSV" part of the file name?
Many thanks :)
Sub Link_To_Excel_Test()
'Macro Loops through the specified directory (strPath)...