D
Dimple Wathen
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.)
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.)