Dialogue for Save As

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David C - 20 Mar 2006 17:10 GMT

How [from VB] do I force the default folder in the 'Save As' dialogue to be a
particulr folder; we are changing our corporate servers, and wish to save
all new and edited Word docs to the new server folders, without the faff of
searching to unfamiliar roots and branches on the networks every time, to
find the new server.

Or is there a VB way to open the SaveAs dialogue and prompt with the new
folder?

Reply to this Message

Helmut Weber - 20 Mar 2006 17:18 GMT

Hi David,

how about this:

Dim oDlg As Dialog
Set oDlg = Dialogs(wdDialogFileSaveAs)
oDlg.Name = "c:\test\"
oDlg.Show

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Reply to this Message

David C - 21 Mar 2006 10:49 GMT

Thanks - I will try it now.

> Hi David,
>
[quoted text clipped - 4 lines]
> oDlg.Name = "c:\test\"
> oDlg.Show

Reply to this Message

David C - 21 Mar 2006 11:21 GMT

Works a treat, thanks

I used oDlg.Name = "c:\test\" & filename to offer a default name too.

Very grateful,
David C

> Hi David,
>
[quoted text clipped - 4 lines]
> oDlg.Name = "c:\test\"
> oDlg.Show

Reply to this Message