Hello -
Does anyone know of a reason why the below would work in an excel macro vs. in a access macro that calls the excel macro?
mFile = Dir(mpath & "*.xls")
Do Until mFile = ""
Workbooks.Open (mFile)
Basically, the excel macro opens a file and does something. I wanted to set it up in access to call the excel macro but am
getting an error 'File Not found'. Works fine in Excel directly but in Access getting 'File Not Found' error.
Thank you