XL5: Not All Commands Recorded Using Get External Data

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel 5.0, when you turn on the macro recorder, and you use the Get External Data command to return data to a worksheet, not all of the actions that you record appear in the recorded macro.

CAUSE

This behavior occurs when you record the macro using the Visual Basic language, and you use the Get External Data command multiple times. If you use the Get External Data command to return data to a worksheet, activate another worksheet and then use the Get External Data command again to return data to the selected worksheet, only the first QueryGetData function is actually recorded. The second Get External Data command is not recorded.

This problem does not occur if you insert a new worksheet before you choose the Get External Data command a second time while the macro recorder is running.

Note that this is not a problem if you record the macro using the Microsoft Excel 4.0 Macro language, or if you record a macro in a later version of Microsoft Excel.

WORKAROUND

To record all of your actions when you choose the Get External Data command multiple times when you record a macro, insert a new worksheet in the workbook before you choose the command again.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0, Microsoft Excel 97 for Windows, and Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about the QueryGetData Function, choose the Search button in the Visual Basic Reference and type:

    QueryGetData Function