View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default relative path in shell command (excel)

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")

--
Regards,
Tom Ogilvy

"SpeeD" wrote in message
...
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