=OPEN("Records",,,,"password")

[Bill Robison]

With relatively new versions of Excel on relatively new
Macintosh and PC computers, the subject macro command
(written years ago in Excel 2.2 macro language)will
perform properly when run on the Macintosh but produces
the following error message when run on the PC.

'Records' could not be found. Check the spelling of the
file name, and verify that the file location is correct.

The second command in the macro is,
=ACTIVATE("Records")
If I open 'Records' before running the macro, then
ACTIVATE will perform properly when I step through the
macro.

MORE INFO: The file 'Records' and the macro sheet are
located together in a folder. The macro has been used
for years on Macintosh computers with various versions of
Excel. I'm now trying to get the macro to run on a PC.
I have tried using 'Records.xls' as the file name and
changing the macro coding of OPEN( ) based on the new
name but it didn't help.

I submitted this problem slightly differently yesterday
(March 8th at 6:29 PM) but got no reply. Thanks for any
help, bill

 

[Tom Ogilvy]

Possibly
=Open("C:\Myfolder\Records.xls",,,,"password")

giving it the path to the file.

 

[Bill Robison]

I tried your suggestion but still get the message that it
can't find it. Note that the file is in the same folder
as the macro and that folder is on the desktop. Very
puzzling. I've tried retyping the file name and the call
in the command but nothing helps. Any more ideas? Bill