Automated Import of .csv File into Excel Using Variable as Connection Path?

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:

Please Login or Register  to view this content.

What I would like to do is something like this:

Please Login or Register  to view this content.

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!

Is there a problem with importing the file directly into Access?

Yes. There are several columns in which number and text values exist in different rows and import errors always occur unless the .csv file is imported into Excel first using the "Import External Data" function then formatting the column types during the process.

But...I was able to figure this one out and it works just as I need without using the variable:

Please Login or Register  to view this content.