I am new to VBScript. Actually all this object stuff feels odd to me - I am used to procedural thinking in programming - Assembly, Fortran, Basic etc. Because of this I still haven't gotten through the VBScripting book, but have run into a problem maybe someone could help me with.
I can execute the following from the Command prompt
Can you tell me how the quotes are paired? I see there are 3 at the start, then doubles all the rest except a single at the end. Is there a place where I can learn about this stuff?
Posts: 2665
Score: 46
Joined: 6/29/2006
From: Orange County, California
Status: offline
The reason for so many quotes is that VBScript will take anything within a pair of quotes as a literal string....when you have spaces and you need quotes to be part of that string then you have to add a few extra to get there. So technically you could have written that same command in these ways
Function AddQuotes(strText) AddQuotes = Chr(34) & strText & Chr(34) End Function
NOTE: Chr(34) = "
Also notice how I use WScript.Echo to check and verify the output is the same as what I am looking for.
Another trick I use is copy the command that works from the command line, paste into notepad, replace all " with two "", then add " to the front and the end, and then finally test it with a WScript.Echo
...now that I go over this little trick that works most of the time for me...maybe this would help
Well, It did get me going pretty good. I made a lot of progress but have run into another puzzle. It seems to be involved with the use of the wildcard character "*". When I use the statements:
objFSO.DeleteFile "C:\Documents and Settings\Wes\My Documents\WorkAreaforRealScript\UploadFilePrepArea\*.*"
or
objFSO.CopyFile "C:\Documents and Settings\Wes\My Documents\WorkAreaforRealScript\*.exe"
or even
objFSO.DeleteFile "C:\Documents and Settings\Wes\My Documents\WorkAreaforRealScript\*.exe"
They all act as I expect. The * seems to work as the wildcard character. However in the statement:
If objFSO.FileExists("C:\Documents and Settings\Wes\My Documents\WorkAreaforRealScript\*.exe")
I don't get the behavior I expect. This statement is always analyzed as if there are no files with an .exe extension. It acts as if it is looking only for the specific file "*.exe" which does not exist. Am I doing something wrong here? How can I check a folder to see if there are any .exe files in it? (My problem started in the case of the program getting to the CopyFile statement when there was no .exe file in the folder.)
Posts: 1916
Score: 16
Joined: 5/15/2003
From: USA
Status: offline
You cannot use wildcards in fileexists. One way to do this would be to use files collection and then check for the exe extension. Here is the example from the WSH docs.
_____________________________
Mike
For useful Scripting links see the Read Me First stickey!
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Newbie needs help 
Printable Version
Newbie needs help - 
I didn't think of that, but after seeing what you suggested I wondered why I didn't think of it myself. 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread