Error importing data from csv file

Hello everyone!

I have recorded a simple macro that imports text from a csv file, divides it in columns using the "," separator and pastes it in the A1 cell of my workbook. Simple. Then I have added some lines to prompt the user to select the file that will be imported.

Please Login or Register  to view this content.

The problem is that I get an error on the last line of the With: ".Refresh BackgroundQuery:=True" and I don't know why. It says "Run-time error '1004': Excel cannot find the text file to refresh this external data range. Check to make sure the text file has not been moved or renamed, then try the refresh again."

I have done some research on Google and I find people with similar problems but not exactly the same thing.

I am specially annoyed because this code worked on Friday before leaving the office but will not work now...

Thanks in advance for any tips you might give me.

Hi!

I just figured it out, there was a problem with the way the name of the file was sent to the connection. Noob mistake. I typed:

Please Login or Register  to view this content.

And it should be:

Please Login or Register  to view this content.

Thanks!

Thanks!

Your answer solved the same problem I had.