Recent content by OneDayOver

  1. O

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

    The multiple CSV files I'm linking to will be updated weekly and in setting up I was having to change the .CSV manually was starting to become very time consuming (well over 100 files to link to). The files are now all linked and I'm hoping will refresh in the database automatically each week.
  2. O

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

    I implemented your code and was able to get it working perfectly. Thank you, your help is much appreciated.
  3. 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)...
See more
Top Bottom