A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I get File Save As Dialog Box for Attachments?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 8th 06, 10:43 PM posted to microsoft.public.outlook.program_vba
Mike M 91107
external usenet poster
 
Posts: 2
Default How do I get File Save As Dialog Box for Attachments?

Can someone give me a code snippet that will pop up the MS-Outlook File Save
As dialog box for an attachment to a MailItem from within a VBA macro?

Thanks.

Mike M 91107
  #2  
Old June 8th 06, 11:25 PM posted to microsoft.public.outlook.program_vba
Mike M 91107
external usenet poster
 
Posts: 2
Default How do I get File Save As Dialog Box for Attachments?

I guess I also need to understand how to make the Office.FileDialog.Show()
function available in Outlook. The File Save As dialog is part of the
Microsoft Office 11.0 Object Library. I have it checked under Tools ...
References in my VB Editor, but, do I have to do something special in code to
enable it inside an MS-Outlook macro?

Thanks.

Mike M 91107

"Mike M 91107" wrote:

Can someone give me a code snippet that will pop up the MS-Outlook File Save
As dialog box for an attachment to a MailItem from within a VBA macro?

Thanks.

Mike M 91107

  #3  
Old June 8th 06, 11:36 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default How do I get File Save As Dialog Box for Attachments?

Open an instance of Word or Excel using code. That will also return to you a
file name to save to but it won't link with Outlook at all. In Word or Excel
code show the dialog.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Mike M 91107" wrote in message
...
I guess I also need to understand how to make the Office.FileDialog.Show()
function available in Outlook. The File Save As dialog is part of the
Microsoft Office 11.0 Object Library. I have it checked under Tools ...
References in my VB Editor, but, do I have to do something special in code
to
enable it inside an MS-Outlook macro?

Thanks.

Mike M 91107

"Mike M 91107" wrote:

Can someone give me a code snippet that will pop up the MS-Outlook File
Save
As dialog box for an attachment to a MailItem from within a VBA macro?

Thanks.

Mike M 91107


  #4  
Old June 8th 06, 11:27 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default How do I get File Save As Dialog Box for Attachments?

You can't. You'd have to open the system save dialog using a Win32 API call
and then do all the saving yourself in code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Mike M 91107" wrote in message
...
Can someone give me a code snippet that will pop up the MS-Outlook File
Save
As dialog box for an attachment to a MailItem from within a VBA macro?

Thanks.

Mike M 91107


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
bypassing save dialog box philippe Outlook - Using Forms 5 April 26th 06 02:52 PM
Empty Dialog Box Will T Outlook - General Queries 1 March 29th 06 10:06 PM
IE and Outlook Express flashing file dialog box Sir Timbit Outlook Express 9 March 14th 06 06:22 PM
Empty "Select Destination File" Dialog Box when Importing Appointm Debbie Outlook - Calandaring 0 March 3rd 06 04:01 PM
Slow pull down menu within the insert file dialog box Harold Outlook - General Queries 0 January 26th 06 04:00 PM


All times are GMT +1. The time now is 12:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.