Change Directory

[walding]

Hi,

I have some script to save 4 text files from an excel workbook.

I want to be able to prompt at the start to ask which directory they want it in.
Is there a way to do this that brings up the explorer navigation window in the same way as it would if you clicked "Save As" manually?

Thanks

AW

 

[Richie(UK)]

Hi AW,

See if this link helps:

http://www.erlandsendata.no/english/vba/folders/selectfolder.htm

HTH

 

[walding]

Thanks Richie. That works OK.

It would be better if I could navigate by shorcuts (like you can in "Save As"). A lot of my directories are deep into explorer!

I have Windows 2000, if that's any help.

Is that possible?

Thanks

AW

 

[Richie(UK)]

Hi AW,

Is this any better?

<pre>Sub GetName()
Dim MyName As String

MyName = Application.GetSaveAsFilename
MsgBox MyName

End Sub</pre>
HTH

 

[walding]

Thanks! And so much simpler, too!