Problem
XL5 only.
Doing Quick Summary, Condensed
Estimate, Extract Special,
stops in the middle. OR, getting macro error
C56 when doing pie/bar chart from MacNail construction
estimating software for home builders and building contractors
Diagnosis
Is an XL5 incompatibility problem, due to a change in the routine that gets file names.
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
Comments
Entered 4/14/94 by Vinay. Updated 11/16/2010.
|
