I cant figure out why this is not working. The macro worked fine yesterday and today i am getting an error message.
Workbooks.Open(strfileName)
gives me RunTime Error 1004 "file name" could not be found.
Any reason why i am getting this error today?
I checked and the file is in the directory and the name is correct.
Workbooks.Open(strfileName)
gives me RunTime Error 1004 "file name" could not be found.
Any reason why i am getting this error today?
I checked and the file is in the directory and the name is correct.