XL98: Cannot Record Macro to Change External Data Properties (188236)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q188236 SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, if you open the External Data
Range Properties dialog box while you record a Visual Basic for
Applications macro, the resulting recorded code does not work when you run
it. If you run the recorded macro, you receive the following error message:
Run-time error '1004':
The formula you typed contains an error.
CAUSE
This problem occurs because the macro recorder in Microsoft Excel records
macro code incorrectly when you open the External Data Range Properties
dialog box. The recorded code looks similar to the following:
ExecuteExcel4Macro "(,TRUE,FALSE,FALSE,FALSE,FALSE,TRUE,1,TRUE,TRUE,TRUE)" WORKAROUND
To work around this problem, remove any lines of code that resemble the
incorrect code from your macro. After you do this, use the information in
the "More Information" section in this article to edit your macro to
specify the appropriate settings for the External Data Range Properties
dialog box.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98
Macintosh Edition.
Modification Type: | Major | Last Reviewed: | 6/17/2005 |
---|
Keywords: | kbbug kbpending KB188236 |
---|
|