Hi,
I'm new in this forum, so I'm not sure if this has been already asked before.
I have a macro that takes all the data from the csv that exist in the same folder where the xlsm is. If you move the xlsm to another folder, it does the same with the csv that are in the new folder, because I used "ActiveWorkbook.Path". The problem is that it works in every folder except dropbox folder. My objective is to be able to run that xlsm from other computers.
The message that appears says:
"Run-time error '1004'. report.csv could not be found. Check the spelling of the file name, and verify that the file location is correct..."
The highlighted sentence is: Workbooks.Open archi
Report.csv really exists in that folder. How can I solve it? This is the code:
Thanks!
Bookmarks