BidMagic Export not Working

Problem

BidMagic- export to MacNail estimate not working
" can't find any bids " when importing an estimate from BidMagic to MacNail construction estimating software

Diagnosis

If they have XL5 or newer, the transfer manager has file problems due to the change in Get.Document(1)

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. This fixes all instances of this problem.
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

Entered 2/2/00 by Casey. Updated 11/17/2010.