XL98: Sample Macro to Open or Activate a Workbook (184504)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q184504 SUMMARY
When you activate a workbook with a Visual Basic for Applications
procedure, the workbook must first be open. If the workbook is closed, you
receive one of the following error messages:
Run-time error '1004':
Workbook method of Application class failed
Run-time error '9':
Subscript out of range
REFERENCES
For more information about error handling, from the Visual Basic Editor,
click Contents And Index on the Help menu (or on the Balloon Help menu if
you are using a version of the Macintosh operating system earlier than
8.0), click the Index button in Microsoft Excel Help, type the following
text
and then click Show Topics. Select the "On Error Statement" topic, and
click Go To. If you are unable to find the information you need, ask the
Office Assistant.
Modification Type: | Minor | Last Reviewed: | 9/12/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB184504 |
---|
|