Problem
macro error D118 in MacNail construction scheduling
software
Diagnosis
caused by XL5 change in get.document
Solution
To make a quick fix for MacNail construction
scheduling software:
1. bring the Manager to the front (choose it from Window menu)
2. have them click on just one cell
3. choose Replace from the Formula menu (XL5 Edit--Find, click Replace)
4. type GET.DOCUMENT(1) into the 'Find What' box
5. type GET.DOCUMENT(88) into the 'Replace With' box
6. Click Replace All
7. Save the Manager
8. If they were having problems with main files, they'll have to reset the main files-- open each one with Open
File, then do Make this a Main File.
Comments
In XL4 and earlier, GET.DOCUMENT(1) returns the file name.
In XL5, GET.DOCUMENT(1) returns the file name and workbook, e.g. Checkbook Ledger:Sheet 1. MS added GET.DOCUMENT(88) to return
just the file name. Entered 3/5/97 by Dennis.
|
