+ Reply to Thread
Results 1 to 3 of 3

Excel / Outlook VBA to open attached PDF file

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    HK
    MS-Off Ver
    2013
    Posts
    3

    Angry Excel / Outlook VBA to open attached PDF file

    Hi All
    I need your Excel /Outlook VBA expert to help.

    I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem :

    The email has attached file that is PDF file with password protected. (I know the password to open it). Under the PDF, there is link/icon and use mouse to click on it and then a small window coming up to choose either open or save the excel file or not into computer. Of course, "save the file" into computer.

    However, how could I write up excel/ utlook VBA to do all the above steps automatically ?

    I am using Outlook 2013.

    Thanks for your help in advance

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel / Outlook VBA to open attached PDF file

    Something like this. MyMail is your mail item

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-23-2017
    Location
    HK
    MS-Off Ver
    2013
    Posts
    3

    Re: Excel / Outlook VBA to open attached PDF file

    AlphaFrog

    Thanks for your help

    I will try to use your code and let see what will happen

    But in your code --> strName = MyMail.Subject & " " & Chr(45) & " " & Att.Filename <----- Chr(45) is it for me to enter the password ? let say if I would like to keep the password in cell(A2) in "Main" tab...how can I cope with your code?

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rename file automatically attached to new Outlook Message
    By marcosis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2018, 11:11 AM
  2. Replies: 0
    Last Post: 01-20-2015, 10:07 PM
  3. copy data from outlook attached excel file into a local one
    By s_samira_21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 03:36 PM
  4. Replies: 0
    Last Post: 09-17-2014, 03:24 PM
  5. Need outlook macro to copy contents of a attached xls file
    By rajkumarmp in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2013, 10:16 PM
  6. [SOLVED] cannot open excel files attached to outlook
    By Ohio Ray in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 09:05 AM
  7. Replies: 2
    Last Post: 02-18-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1