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!
-
Closing Application
What is the 'logical' reverse of the following open? Set objExcel = GetObject("", "excel.application") objExcel.Workbooks.open strFullPath In other words, how do you close the current document AND the workbook. One would think it would be: objExcel.ActiveWorkBook.Close... -
Inserting Excel Rows via VBScript
I am going to give this one more try. I am having some difficulty with determining the line of code that will allow me to insert a new row above the currently selected cell. The code created when you record a macro and do this manually will not work when transported to VBScript. Here is a... -
Manipulating Worksheet from VBSript
Having some difficulty in in manupulating some Excel Worksheet functions from an external VBSript application (either standalone or client-side web page). In general, I am not able to get a 'row insert' to work and a succeeding copy and paste. Specifically, I am using a function to insert a...
