in
All Tags » VBA » pdf (RSS)

Browse by Tags

  • Excel to PDF converter (using VBA)

    I would like to create a PDF from Excel VBA. a)The PDF should have same colors as the charts in the original excel and b) should also retain the hyper links in the original excel
    Posted to Windows (Forum) by microsoft on 05-21-2010

  • outputting reports to PDF via code

    hi guys, i have a big MS access project that links to a SQL backend, what I need to do is output reports to PDF format via code in some way. It needs to be flexible because different clients may need to create these PDFs using different drivers. I am very experienced in VBA programming inside of Access...
    Posted to Access (Forum) by microsoft on 05-20-2010

  • Save PDF FIles into Txt Files with VBA in Access

    The problem I have is that I need to save multiple PDF Files as TXT, so that I will be able to parse the txt information and save it into a database. My company does not allow for software to be installed so that is not an option. I need for an Access database to be able to take a PDF file and save it...
    Posted to Access (Forum) by microsoft on 05-17-2010

  • .DOC to .PDF in VBA

    I have Acrobat 5.0 installed so I have access to Acrobat Distiller(acrodist.exe) and other Acrobat components. This is what I use today: ___________________________________ Dim oConverter As ACRODISTXLib.PdfDistiller Call LoadDoc(OriginalPath & FileItem.Name) ' Opens word document Call SetMark...
    Posted to Miscellaneous (Forum) by microsoft on 05-02-2010

  • VBA code to pause event function until a report has been created by Adobe Acrobat

    Hello ~ I use the following to print a report: Dim stDocName As String stDocName = "rptConfirmationPDF" DoCmd.OpenReport stDocName, acNormal Adobe PDF is set as the "Specific Printer" in the report's page setup. I would like to pause the remainder of the event function (not shown...
    Posted to Access (Forum) by microsoft on 04-25-2010

  • Excel: Print File to PDF Distiller

    Hello, I have a module that will create a folder and then print a spreadsheet into pdf. (See Code below) It does not work, and the following msg pop up. "When you create a postscript file you have to send the host fonts. Please go to the printer properties, "'Adobe PDF Settings' page...
    Posted to Excel (Forum) by microsoft on 02-23-2010

  • Access Report to PDF without Save As Dialog

    I have an Access database that I have created a form where the user can check multiple reports and when I press a button I need it to export each as a PDF. Here's the catch. I want the user to be able to select a folder location on the form, and when the button is pressed I need code or a macro to...
    Posted to Access (Forum) by microsoft on 12-24-2009

  • Print report to pdf using vba

    Hi all. I'm trying to print a Access report to pdf using vba. I have code that works fine, except that it promps me for a file name. Is there any way to set the filename so the user don't have to? This is the code I have so far: Dim stDocName As String stDocName = "myReport" 'print...
    Posted to Access (Forum) by microsoft on 09-11-2009

  • VBA Code to create PDF from XLS

    Can someone please provide VBA code to create a PDF from XLS with the file name automatically taken from a cell value without any dialog pop ups, so fully automatic? I have surfed and tried so numerous different codes and nothing works. I have Acrobat Distiller 8 and Acrobat 8 Professional installed...
    Posted to Excel (Forum) by microsoft on 08-16-2009

  • MS Excel VBA problem - I need to open and print a pdf using vba

    I can hook into word and powerpoint, documents and presentations but also need to open and print a pdf, Binder does not support pdfs so vba my only alternative. Software restrictions prevent other programs. Below the code to open .doc s and .ppt s: Dim appPPT As PowerPoint.Application Set appPPT = CreateObject...
    Posted to Excel (Forum) by microsoft on 08-06-2009
Page 1 of 2 (20 items) 1 2 Next >