PDA

View Full Version : Solved: calling saveas dialogue box



rodney_malod
11-11-2005, 05:21 AM
i wish to call the saveas dialogue box so a user can specify a directory to save in.

however i have a variable "fname" that is the name the file is to be saved as. any ideas people???

Marcster
11-11-2005, 05:52 AM
Hi rodney, welcome to VBAX :hi:.

Does this work?:


With Dialogs(wdDialogFileSaveAs)
.Name = fname
.Show
End With



Marcster.

Killian
11-11-2005, 05:52 AM
Hi and welcome to VBAX :hi:

This should do it (depending on the version of Word)Dim dlg As Dialog

Set dlg = Application.Dialogs(wdDialogFileSaveAs)
With dlg
.Name = fname
.Show
End With

rodney_malod
11-11-2005, 07:27 AM
Thanks muchly both of you!!

got my project working!! :D