Results 1 to 3 of 3

Thread: Opening a Pdf file using VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 11-30-2011, 02:48 PM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    You could try something like

    Code:
    Sheet1.Hyperlinks.Add Range("A2"), "C:Temp\MyPDF.pdf"
    Range("A2").Hyperlinks(1).Follow NewWindow:=1
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 11-30-2011, 03:05 PM #2
    littleiitin
    littleiitin is offline
    Member littleiitin's Avatar
    Join Date
    Aug 2011
    Posts
    90
    Rep Power
    15
    OH...

    Hyperlink.

    Thanks Admin for letting me remember.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Open PDF file with PowerPoint VBA
    By bg52ip in forum Powerpoint Help
    Replies: 4
    Last Post: 06-12-2013, 11:28 PM
  2. Pause worksheet for 10 sconds while opening the workbook - VBA
    By Portucale in forum Excel Help
    Replies: 2
    Last Post: 01-29-2013, 02:45 PM
  3. Print excel sheet to a PDF file
    By xander1981 in forum Excel Help
    Replies: 2
    Last Post: 12-14-2012, 02:16 PM
  4. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  5. Protect Excel File From Opening Only In Designated Computers
    By mikeydo in forum Excel Help
    Replies: 1
    Last Post: 06-26-2012, 08:17 PM

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
  •  

Forum Rules