ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   runtime error '800a9c64' (https://www.excelbanter.com/excel-discussion-misc-queries/35354-runtime-error-800a9c64.html)

Dimple Wathen

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.)



All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com