Hello. I'm working with an Excel sheet that has buttons on it to do the following:
1. Import a .csv file not created with Excel
2. Format the .csv file for use with an Access database
3. Save the formatted file as .xls
4. Close the formatted file
My problem is that when I create a macro to do all this for me the connection string to the .csv file is set in the code and doesn't work when I try to use a variable. I would like fo rth connection string to change depending on the user that runs the macro. The original code after macro creation is:
What I would like to do is something like this:
Any ideas how to do this? I've tried just opening the .csv file and formatting using Excel but the "Import External Data" function works best for me. Thanks in advance for any inputs!