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!
-
VBscript to query excel spreadsheet
Thanks for the input. I'm now getting this error after changing both of those lines: Line 20 Char 5 [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. Here is what I currently have: retvar =... -
VBscript to query excel spreadsheet
Guys, again, I appreciate the help. Ok, so I modified it to look like this: retvar = GetAssetTag(WScript.Arguments(0)) Function GetAssetTag(sn) Dim sConn, sSQL Dim rst, cnn Dim sPath, sDB sPath = "C:\Users\E048321\Desktop" 'your path sDB = "MWR-ITInventoryTemplate... -
VBscript to query excel spreadsheet
That's why I'm confused. It seems to hang up at "As String" in that line. In fact, when I remove all of the "As ..." portions, it completes, but outputs nothing... -
-
VBscript to query excel spreadsheet
Wow, Skip, thanks for the fast reply!! I've named this script "getasset.vbs", and am running it from a command prompt like this: getasset.vbs D3500D1 "D3500D1 is the serial number I'm attempting to find the asset tag for. However, I get the following error: Line: 1 Char: 25 Error... -
VBscript to query excel spreadsheet
I'm very new to VBScripting and am hoping that someone can be of some help, and have a feeling that it's rather simple... I have an inventory spreadsheet of PC's serial numbers (column K) and asset tags (column J). This is located on a network share (\\server\path\inventory.xls). I need a...
