Change Directory

walding

New Member
Joined
May 16, 2002
Messages
34
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

walding

New Member
Joined
May 16, 2002
Messages
34
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)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi AW,

Is this any better?

<pre>Sub GetName()
Dim MyName As String

MyName = Application.GetSaveAsFilename
MsgBox MyName

End Sub</pre>
HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,622
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top