Problem
XL5 incompatibilities in MacNail
construction management
software -- fixing file naming
problems ('main files' not working, showing long weird
file names. Not saving files correctly)
Diagnosis
they have XL5 with a manager that has a 'last revised' date of before summer 94.
If they have a newer manager, install that. Can also get replacement disks from us for $5.
Solution
To make a quick fix:
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.
Why they didn't do it the other way around (a much more logical approach) is a big mystery. Then again, this is Microsoft,
so I guess we're stuck with this kind of stuff.
Entered 1/5/95 by Dennis. Updated 11/25/2010.
|
