Search results

  1. O

    Linking to multiple CSV files and renaming tables without ".CSV"

    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)...
Top Bottom