Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error 9: Subscript Out of Range Dilemma
Here is my dilemma. The following code snippet listed below depicts an object variable name "xlobject" that holds an instance of "Excel.Application". At this point in the code, I have one workbook assigned to the "xlobject" (meaning that xlobject.workbooks.count = 1). The first line of code... -
Need VBScript Equivalent of VBA Excel Copy Method
Can anyone help me find the VBScript eqivalent of the VBA code listed below? I'm pretty sure VBScript does not support named arguments, so I'm even wondering if this is even possible. Here it is: Sub Macro2() Sheets("Sheet1 (2)").Select Sheets("Sheet1 (2)").Copy... -
How To Copy Excel Sheet From One Workbook To Another
The code snippet below works under NT, but is failing when I run this in Windows XP: 'copy current invoice to the master invoice 'workbook, place at beginning of workbook xlsheet.Copy(xlMasterWorkbook.Sheets(1)) if err.number <> 0 then MsgBox "Error " & Err.number & ": " & Err.description... -
VBScript Code In IE That Opens Excel WorkBook Not Running In XP
I am currently working on an .asp application that manipulates Excel from a web page using VBScript. The application works fine on an NT platform, but it needs to be modified to work under Windows XP. I am having problems with the section of code described below. Here is what is happening...
