Question: OPEN return status

  • Thread starter Frederik Romanov
  • Start date
F

Frederik Romanov

Excel-97 (SR-2)

My Excel version 4 manual describes the obsolete form of Fopen, with
this syntax I hoped to perform

[G15:FileNonExistent] = <within a macro> isNA( Fopen(
"C:\datafile.pdf", 2))


However the syntax in Excel-97 now means I have to use

[G15:FileNonExistent] = <within a macro> open "C:\datafile.pdf" for
input as #123

Trouble is this does not return a status, but generates an error if
the file does not exist. How can the macro trap this error and convert
it to a return status?


When I actually tried this with a non-existent file, the cell invoking
the macro just displays #Value!, only if I step into the macro do I
get an error reported.

TIA (thanks in advance),
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top