Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dimple Wathen
 
Posts: n/a
Default runtime error '800a9c64'

Anyone ever seen this error message:

runtime error '800a9c64'

results with:

set ws = wb.Worksheets("Sheet1")

where wb is an opened workbook that has macros.

When I manually open the workbook, I have to answer "Enable Macros?"

Thing is, if the workbook is already open and has been opened with
macros DISabled, then:

set ws = wb.Worksheets("Sheet1")

works without error.

(I am using VBSCRIPT as in a .VBS file.)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Runtime error for macro that works in workbook created in Crystal Excel Discussion (Misc queries) 1 June 22nd 05 08:43 PM
Runtime Error 9 Lizz45ie Excel Discussion (Misc queries) 1 May 27th 05 08:44 PM
Excel help giving runtime error Hari Prasadh Excel Discussion (Misc queries) 1 January 21st 05 01:23 PM
Why do I get the runtime error message430 when I start my compute. Thorcat Setting up and Configuration of Excel 1 December 2nd 04 07:15 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"