Using Call Shell code

J

JT

I am using the Call Shell command in VB code to directly start and open an
Excel file by name. If the folder name or the filename has a spece in it, it
does not work. It works fine when there are no spaces.
Does anyone have a suggestion for this command syntax or any other command?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Shell Puzzler - “Documents and Settings†folder issue? 5
Word OLE to check spelling in text box 1
OLE Word spelling 0
Shell Command Doesn't Like Spaces? 2
How do I set focus (and select text) on a text box on a modeless userform? 0
How to call a java application from an Excel Macro in Macoffice 0

Top