relative path in shell command (excel)

G

Guest

Hi guys.

Im having some trouble to make a relative path inside the SHELL command in a
excell macro... (whereever i have my xml the command shell looks for the.VBS
file in the same directory)

Shell ("wscript.exe .\Script_Congressso.vbs") doesen´t work...

Thnks a lot

SpeeD
 
T

Tom Ogilvy

in your macro that calls you macro, set the default directory to the
directory with your macro

Chdrive "C"
ChDir "C:\my\macros"
Shell ("wscript.exe Script_Congressso.vbs")
 

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

relative path 1
Simple Shell Commands 4
The Differences in the Shell Command in Excel 2003 and 2007 1
Hyperlinks property return a relative path ... 5
Run .vbs from a Excel macro? 5
Excel 2000 Simple Shell Command Doesn't Work in Excel 2007 1
Help: Excel and Shell Command 7
Shell command 2

Top