Search results for query: *

Aside from your symptoms you report, the following statement is incorrect (both ocurrences): newfolder = "\\acnetpdc\users\" + username it should be newfolder = "\\acnetpdc\users\" & username

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

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

Have you considered using: frmSettings.Hide

This little snippet may answer some of your question. I'll leave it up to you to 'decode' it. It was used to transform all of the named cell areas from one sheet over the the same cells on another identical sheet. Sub MoveNames() ' ' Define all the names onto a new sheet ' cm =...

Actually, your issue is not with an apostrophe, it is with the single quote character. In fact, what you should be using all the time, except for quoted strings, is the apostrophe (lower case tilde on most keyboards). Try something like: sText = Replace(sText,"'","`") sText...

While I am at this, does anyone know of a good online source that documents and has good examples of using the excel and word objects from a VBScript environment?

Is this the kind of thing you are looking for? "mailto:youknowwho@youknowwhere.com?subject=this is the subject stuff&body=this is a sample chunk of the message body"

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