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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBScript read from relative path location
Neither of those work. It's weird because if I put Set objWorkbook = objExcel1.Workbooks.Open("C:\Documents and Settings\lrobinson\My Documents\Scripts\budget_input.xls") in the script it runs fine, but when I try the two solutions above I get the error 'C:\Documents and Settings\lrobinson\My... -
VBScript read from relative path location
I have a script that reads information from an excel file and otputs the information to a text file. Other people will be using this script, so I just tell them to put the script and the input file in the same folder and it should run. How can I get the Script to find the excel file in the same...
