Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Dos Directory

When I use START PROGRAMS and MSDOS PROMPT, I get the Windows directory.
When I use my macro and shell out, I get another directory, but not the one I
want. I can make a batch to get to the one I want, but is it possible to get
ther automatically, the first time I shell out?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default Dos Directory

Hi denny,

ChDir

before your start shell, see vba-online-help on chdir

arno
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Dos Directory

That worked. Thanks. Can I set a prompt command before or as I shell out

"arno" wrote:

Hi denny,

ChDir

before your start shell, see vba-online-help on chdir

arno

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default Dos Directory

Denny, for our archives please answer in the ORIGINAL thread if possible

--
Don Guillett
SalesAid Software

"denny" wrote in message
...
That worked. Thanks. Can I set a prompt command before or as I shell out

"arno" wrote:

Hi denny,

ChDir

before your start shell, see vba-online-help on chdir

arno



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Dos Directory

Sorry. I don't understand. I don't know if you mean reply to the top one
regardless of what... or the last one??? In this one, I did it in order (the
last one, I thought). In another, I did it on the one that applied to my
question.

"Don Guillett" wrote:

Denny, for our archives please answer in the ORIGINAL thread if possible

--
Don Guillett
SalesAid Software

"denny" wrote in message
...
That worked. Thanks. Can I set a prompt command before or as I shell out

"arno" wrote:

Hi denny,

ChDir

before your start shell, see vba-online-help on chdir

arno






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
Directory Jeff Excel Discussion (Misc queries) 1 October 5th 06 04:51 PM
open in old directory save in new directory tim64[_2_] Excel Programming 0 June 15th 05 07:48 PM
set last used for getting directory smokiibear Excel Programming 8 December 15th 04 07:38 PM
Creating a macro that lists directory names within a directory.... Andy Excel Programming 4 November 28th 04 06:13 AM
Check if directory empty OR no of files in directory. Michael Beckinsale Excel Programming 2 December 4th 03 10:12 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"