Microsoft KB Archive/119141

= "Macro Error..." with Lotus File Combine Macro =

Article ID: 119141

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 95a
 * Microsoft Excel 4.0 Standard Edition
 * Microsoft Excel 4.0a
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q119141





SYMPTOMS
When you run a Lotus 1-2-3 macro that contains a File Combine command in Microsoft Excel, you may receive the following error message

Macro error at cell:

followed by

Cannot find ' '

-OR-



where is the cell containing the File Combine Command and is the name of the file being combined.



WORKAROUND
You can use the Macro Interpreter in Microsoft Excel to run a Lotus 1-2-3 macro that performs the File Combine function as long as the following conditions are true:


 * The Lotus file being combined is saved in the .WK1 format (note that the .WK3 format will not run correctly).

-and-
 * The file being combined is located in the working directory.



MORE INFORMATION
The File Combine feature of Lotus 1-2-3 will extract cells from one file and place them at the active cell location in the current document. This feature was developed with early text-based versions of Lotus 1-2-3.

Microsoft Excel does not have a direct equivalent of the File Combine feature, but you can simulate it manually.

To simulate the Lotus 1-2-3 File Combine feature in Microsoft Excel

 * 1) Open the source file.
 * 2) Open the target file.
 * 3) In the source file, select the range that you want to combine with the target file.
 * 4) On the Edit menu, click Copy.
 * 5) In the target file, activate the starting cell location.
 * 6) On the Edit menu, click Paste.

Lotus 1-2-3 is manufactured by Lotus Development Corporation., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

