Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 16th 05, 05:49 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 65
Default 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   Report Post  
Old November 16th 05, 06:29 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to change absolute path to relative path hwijgerse Excel Worksheet Functions 0 November 25th 05 08:18 AM
How do I hide a shell command called from VBA in Excel Robert Lyriotakis Excel Programming 2 December 8th 04 03:25 PM
Excel Macro - Relative Path Skip[_4_] Excel Programming 2 July 28th 04 08:34 AM
Shell command stopped working: is it part of Excel 95 , or Windows? Charles Jordan Excel Programming 9 May 4th 04 06:39 AM
Writing Command Shell (stdOut) to Excel Cells Ryan Waltz Excel Programming 0 January 28th 04 11:52 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017