Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default In DOS Prompt Change Automatic Dirrectory

When I use the DOS Prompt screen, it automatically shows a particular
directory.
I would like preset the directory that come up automatically.
As it stands right now, it does not come up with the directory I want.
I know that I can use the command "cd" to change the directory, but it is
tedious to have to do that every time I use the DOS Prompt. Is there a way
to accomplish this?
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default In DOS Prompt Change Automatic Dirrectory

Maybe you could create a shortcut (on your desktop???) and use that instead.

I rightclicked on an empty spot on the desktop.
New|Shortcut
I typed this into the location of the item:
%comspec%

Then gave it a nice name.
And finished those dialogs.

Then I rightclicked on that new shortcut and chose properties.
On the Shortcut tab, I changed the "Start In" box to what I wanted.


wab713 wrote:

When I use the DOS Prompt screen, it automatically shows a particular
directory.
I would like preset the directory that come up automatically.
As it stands right now, it does not come up with the directory I want.
I know that I can use the command "cd" to change the directory, but it is
tedious to have to do that every time I use the DOS Prompt. Is there a way
to accomplish this?
Thanks.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default In DOS Prompt Change Automatic Dirrectory

If you are running the Cmd program directly from the Windows Start Run
dialog, you can't change the path. If you are scripting it with Shell in VBA
or VBS, you can use code like

Const THE_PATH = "C:\Test"
ChDrive THE_PATH
ChDir THE_PATH
Shell "cmd", 1

Change the value of THE_PATH to the directory in which Cmd should start.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





"wab713" wrote in message
...
When I use the DOS Prompt screen, it automatically shows a particular
directory.
I would like preset the directory that come up automatically.
As it stands right now, it does not come up with the directory I want.
I know that I can use the command "cd" to change the directory, but it is
tedious to have to do that every time I use the DOS Prompt. Is there a
way
to accomplish this?
Thanks.


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
prompt user to change source of links Bobak Excel Discussion (Misc queries) 4 March 20th 06 07:29 PM
save prompt for user exit, but no save prompt for batch import? lpj Excel Discussion (Misc queries) 1 February 25th 06 02:08 AM
Automatic Color Change Gary''s Student Excel Discussion (Misc queries) 0 February 4th 06 07:00 PM
Can I change a cell and cause an automatic change in other cells Swissmiss Excel Worksheet Functions 2 August 12th 05 05:00 PM
Automatic Change of X-axis Jan Charts and Charting in Excel 3 January 16th 05 07:01 PM


All times are GMT +1. The time now is 08:00 PM.

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

About Us

"It's about Microsoft Excel"