| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative path in shell command (excel)
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change absolute path to relative path | Excel Worksheet Functions | |||
| How do I hide a shell command called from VBA in Excel | Excel Programming | |||
| Excel Macro - Relative Path | Excel Programming | |||
| Shell command stopped working: is it part of Excel 95 , or Windows? | Excel Programming | |||
| Writing Command Shell (stdOut) to Excel Cells | Excel Programming | |||
Linear Mode
