Article View: comp.sys.ibm.pc.misc
Article #1995LOTUS 123R3 question
From: Werner P. Keilholz
Date: Mon, 23 Jul 1990 18:54
Date: Mon, 23 Jul 1990 18:54
21 lines
1629 bytes
1629 bytes
Does anybody out there know a straightforward way to find out whether or not a file exists on the harddisk while a LOTUS macro is running ? The only thing I could come up with was the "/File Admin Table Worksheet" command, which creates a list of filenames in a given cell range. One could then search this table for the desired filename. Just attempting to load the file and then using the ONERROR function to trap errors failed, since this seems to clear the subroutine (or rather "sub-macro") stack. I can't believe that there isn't a more simple solution to this ! Any ideas ? ______________________________________________________________________ Werner Keilholz | Lawrence Berkeley Laboratory | Tel.: 001-415-486-6878 Building 90, Room 3074 | E-Mail: envwpk@epb2.lbl.gov 1 Cyclotron Road | (pn=envwpk, ou=epb2, on=lbl, pd=gov, Berkeley, CA 94720 | from rrze-CYBER: [ad=dbp, c=de] ) USA |
Technical Details
Message-ID:
<6257@helios.ee.lbl.gov>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!mcgill-vision!snorkelwacker!apple!usc!ucsd!helios.ee.lbl.gov!epb2.lbl.gov!envwpkShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!mcgill-vision!snorkelwacker!apple!usc!ucsd!helios.ee.lbl.gov!epb2.lbl.gov!envwpk From: envwpk@epb2.lbl.gov (Werner P. Keilholz) Newsgroups: comp.sys.ibm.pc.misc Subject: LOTUS 123R3 question Summary: How to find out whether file exists ? Keywords: LOTUS 123 Message-ID: <6257@helios.ee.lbl.gov> Date: 23 Jul 90 18:54:58 GMT Sender: usenet@helios.ee.lbl.gov Reply-To: envwpk@epb2.lbl.gov (Werner P. Keilholz) Followup-To: envwpk@epb2.lbl.gov Organization: Lawrence Berkeley Laboratory, Berkeley Lines: 21 X-Local-Date: 23 Jul 90 11:54:58 PDT