bctek
asked on
One line of code...need help
I keep getting an error that the file cannot be found:
Excel.Workbooks.Open("fake _users.xls ")
yet fake_users.xls exists right in my BIN directory. How do I get it to open this worksheet with a relative path to the EXE?
Excel.Workbooks.Open("fake
yet fake_users.xls exists right in my BIN directory. How do I get it to open this worksheet with a relative path to the EXE?
ASKER
i dont want the full path, i want a relative path to the EXE.
ASKER
ERROR returned: "Additional information: 'fake_users.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
still doesn't work :(
same error returned.
" '.\fake_users.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct."
the file exists right next to the .exe
If I put the absolute path in, it works fine, but can't get it to open relatively
same error returned.
" '.\fake_users.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct."
the file exists right next to the .exe
If I put the absolute path in, it works fine, but can't get it to open relatively
Can you paste the full path of where the file is
ASKER
the app.path worked. ALl set now! Thanks
Good, sorry I misread the question at first. Have a pleasant evening
Excel.Workbooks.Open("c:\m