Hi, I have automated project with several modules and I am unable to locate or find cause for this error in code,
Detailed description as Windows message box is as below, can someone point where this occuring or possible solutions?
Detailed message
================
Windows Script Host
Script: x:\...\xxx.vbs (This vbs call .xls modules and pass parameters)
Line: 9
Char: 1
Error: Method 'Range' of object '_Worksheet' failed
Code: 800A03EC
Source: XXXDB
Without seeing the code, not specifically, but I would guess you are trying to refer to a named range that does not exist on the specified sheet.
Everyone who confuses correlation and causation ends up dead.
problem is with this error message I am unable to find specific code, any recommedations to trace code? It was working fine before and suddenly it started giving this error and as soon I say ok on msg box it exit .vbs
What is line 9 of your vbscript?
xlWkb.Ane("US;2;PROD;X:\Engine_Auto\") xlApp.DisplayAlerts = False xlWkb.save
Last edited by jikenj; 06-16-2010 at 02:19 PM.
You'll need to review the Ane sub or function in the ThisWorkbook module of the workbook you are manipulating.
jikenj, please take a few minutes to read the forum ules, and then edit your post to add CODE tags.
Thanks.
Entia non sunt multiplicanda sine necessitate
I apologize about CODE tags, will read through rules and update as soon possible
Last edited by jikenj; 06-16-2010 at 03:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks