Results 1 to 2 of 2

Save to pdf with a pre-defined filename

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2009
    Location
    Cáceres, Spain
    MS-Off Ver
    Excel 2010
    Posts
    11

    Save to pdf with a pre-defined filename

    I'm trying to adapt a macro from Ken Puls (www.excelguru.ca) which uses the print to pdf function in Excel2007 so that is has a predefined filename (job number, date, job type, users initials).

    I have the following two snippets and I need to know how to combine them. I think I need something like the following:

    Dim sDefaultName as String
            sDefaultName = 'picked up from worksheet
    ' then a combination of the next two lines
            vPDFPath = Application.GetSaveAsFilename(, "PDF Files (*.pdf), *.pdf")
            Application.Dialogs(xlDialogSaveAs).Show sDefaultName
    
    ' code continues
    How can I combine those two lines? Is it possible with print to pdf?

    Thanks in advance.
    Last edited by oCoCarbon; 02-06-2010 at 12:18 PM.

Thread Information

Users Browsing this Thread

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

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