Attachment.SaveAsFile Method

  • Thread starter Thread starter Richard Winston
  • Start date Start date
R

Richard Winston

I have a hardcoded value for this method in a macro I wrote. I'd like
to make this more dynamic. Is there a control that I can use to pop up
a file dialog allowing the user to select where he wants the attachments
to be saved?
 
How about designing a UserForm with a CommonDialogControl on it? You can
then call the control from your macro like this:

Dim myForm As New UserForm1

myForm.CommonDialog1.ShowSave

The blank UserForm won't get displayed, just the dialog.
 
Back
Top