ChangeFileOpenDirectory - In Excel

[SteveC24]

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]

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