ChangeFileOpenDirectory - In Excel (1 Viewer)

SteveClarkson

Registered User.
Local time
Today, 01:03
Joined
Feb 1, 2003
Messages
439
Hello all,

I am aware of the "ChangeFileOpenDirectory" method in Word VBA, but am looking for the same functionality for the save as window in Excel.

I am opening the Save As dialog using VBA, but would like it to open on a particular network drive/folder, but don't want to change the Excel default permanently.

Any ideas?

Thanks!
 

HaHoBe

Locomotive Breath
Local time
Today, 02:03
Joined
Mar 1, 2002
Messages
233
Hi, Steve,

I always worked around that using either ChDrive "C" or Left(ChDir, 1) and ChDir as "C:\Temp" (and keeping the starting CurDir in a variable). Maybe there is a way using API or other methods but I didn´t learn about any of these procedures up to now...

Ciao,
Holger
 

Users who are viewing this thread

Top Bottom