Running a Saved Import is trying to use the wrong file name to import from

[Lori F]

I download a file from Paypal that is usually called Download [61].csv. Although the 61 increments every month. I open that file, then save it as PaypalTest.xlsx in the same file directory every month. I then created an Import in Access that I want to run each month. The first month, it ran fine when I created it. I told it to save the Import specifications. Now that I'm running it the 2nd month from the Saved import, I get an error that Download [61] is not a valid name. This month it was Download [62], but either way, the saved specs show that it is using PaypalTest.xlsx from the appropriate directory. So I don't understand why it would be trying to use the originally downloaded file name from last month instead of the file name that I saved it as. I had to delete the saved import, then create a new import to get it to import the data as expected (again, using PaypalTest.xlsx) as the saved file name. So then I did another test with a new saved file and having the same problem all over again. For some reason, the saved import procedure is not using the correct file name even though it shows correctly when I look at my saved imports. If I was trying to use the name shown in the error, I would understand what the problem is, but the saved import makes no reference to the file name it is trying to use.

[pbaldy]

Shot in the dark, but could it be that "Download [61]" is also the tab name, and something in your code looks for that?

[Lori F]

After doing a few tests, you are absolutely correct. It appears that when I save the csv file to the xlsx, it named the tab with the original file name instead of 'Sheet1' or the name of the file that I saved it as. I had no idea that the saved import saved the tab name since that isn't even a parameter that is asked for. Thanks so much for your help! Now I know how to resolve the issue. After I save the file, I'll name the tab Sheet1, then save again. I recreated the Import, saved it, then tested by changing the tab name and it no longer worked. Then I changed the tab name back to Sheet1 and it worked again. Easy fix, but it sure had me stumped. Have a blessed day!

[pbaldy]

Happy to help! It might help to see your code, but you may be able to refer to the sheet by position instead of name.