create pdf

  1. J

    VBA to create a pdf, name it from a cell value and save to the users choice of location

    Hi there, I am trying to create a VBA project that does the following: Selects 2 named sheets - Sheet 1 & Sheet 2 Opens a Save As box for the user to select where they want to save the file Creates a pdf file of the 2 selected sheets named as the same content in cell G3 and the current date...
  2. J

    VBA code error help, Issue with a loop. Issue with saving as pdfs with constantly changing names.

    Hello everyone, VBA newbie here. I didnt write this code but Im attempting fix some errors. Whats supposed to happen is that a loop that is supposed to iterate over certain rows and create subsequent word and pdf files related to isnt working. The debugger gives an error at the part which...
  3. T

    VBA and Acrobat add-in to create new PDF with bookmarks

    My question is hopefully rather simple, but I'm relatively new to VBA and I know nothing about Acrobat API. After spending the better part of the past two days scouring the web for an answer, I've only found long-outdated results (like like this post from 2016 based on this blog from 2009 and...
  4. M

    Create code for button

    Hi there I need to create a button, called "Submeter", which will be in a sheet called "Comp.proc.norm.NLT 107 98 ". I need to come up with a code for that button that does the following things: *Creates a PDF of the worksheet and saves it in a selected location, for now it could be a folder...
  5. B

    Macro to Create PDF with Current Date

    I'm pretty new to all this, but I was wondering if anyone could help with a macro. I'm trying to get it to create a PDF of my current worksheet with certain cells as the file name in a predetermined folder. For instance: A1=Job A2 = Dallas A3 = Today() Folder = /work The PDF would be created...
  6. K

    Error creating pdf files from Excel 2013 macro

    I have just moved from a laptop running XP/Excel 2007 to a laptop running Windows 8 64-bit/Excel 2013. I have a .xlsm file that contains a macro which prints various sheets from the graph into 7 pdf files stored in other folders. The part of code that creates (i.e. overwrites the existing...
  7. derek.hughes

    Print to PDF as name of each sheet.

    I have a spreadsheet exported from Access that contains each department's budget information (used, remaining, etc.). I want to create a command button that when clicked will create a separate PDF for each worksheet. I want each .PDF file to be named the same as the Worksheet name. Can you...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top