Hello all,
I'm trying to call a macro that will open other file and do operations with other file, both files are in an external drive (MY PASSPORT), and it appears the message:
“Run-time error ‘1004’ Sorry, we couldn’t find MY PASSPORT/PnT/Home/Expenses Control.xlsm. Is it possible it was moved, renamed or deleted?"
Also I can open the file if it is in the iMac using /Users/martabritto/Documents/PnT/Home/Expenses Control.xlsm but if I try access from an external drive, I don't know how to use it.
Also if I want alternatively select both files I can't. Before in the Excel 2011 I used the command: Windows("expenses control.xlsm").Activate
Now it returns an error "Run-time error '9' Subscript out of range
Thank you for helping.
BR,
Pedro
Bookmarks