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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Scripting Registry changes in Win98
Aside from your symptoms you report, the following statement is incorrect (both ocurrences): newfolder = "\\acnetpdc\users\" + username it should be newfolder = "\\acnetpdc\users\" & username -
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... -
How do I get a form to get focus
Have you considered using: frmSettings.Hide- griffinmt
- Post #5
- Forum: Visual Basic (Classic)
-
How to access the range's name ?
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 =...- griffinmt
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Stripping apostrophes from SQL or strings
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... -
Manipulating Worksheet from VBSript
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? -
Get Forms result and email
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" -
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...
