|
-
Jun 10th, 2003, 06:03 PM
#1
Thread Starter
Addicted Member
SHELL out to excel
ok im am using access (vba) and i am opening excel.exe something like this:
shell("address to find excel.exe then the file name to open",1)
or something like that...but here is the problem when i pass it a file in a directory that contains a space in the name excell tries to open the wrong thing.
example: if i opened excel in vb like:
shell("C:\excellfolder\excel.exe C:\example folder\example.xls",1)
then itsays this opon entering excel
canot find "C:\example.xls"
then cannot find "folder\example.xls"
it splits it at the space but i do not want it to what can i do to keep it from splitting it at the space?
p.s. i know the code example probably sucks but it is something like that.
thanks ahead of time for the help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|