The information in this article applies to:
SYMPTOMSIn 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. WORKAROUNDTo 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. STATUSMicrosoft 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. REFERENCESFor more information about the QueryGetData Function, choose the Search button in the Visual Basic Reference and type: QueryGetData Function Additional query words: 1.00 5.00a 5.00c XL5 addins
Keywords : |
Last Reviewed: September 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |