Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,comp.apps.spreadsheets,microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Not Detecting Open Workbook Status - Odd?? | Excel Discussion (Misc queries) | |||
List "OPEN" orders based on a status column | Excel Worksheet Functions | |||
Calc status of open excel workbook should not overwrite another | Setting up and Configuration of Excel | |||
I want to return a value based on the status of a check box. If . | Excel Worksheet Functions |