pdf export

Hi there. I've searched everywhere and couldn't find a solution for this :cry: I'm trying to export an excel workbook as a single file with the following conditions: - The first sheet shouldn't be exported - The second sheet should be in duplicated - The last sheet should be included or...

Hello, I am using the following macro to save the current selected sheet as a PDF. When I go and edit the path I want it to save to it fails the macro and I think it has something to do with: ("userprofile") But if I create a folder on the desktop: \Holding\ it works fine. I would like to be...

Hello, I have the VBA code below. End goal is to have each tab in the workbook to be exported into its own PDF. Problem: it works fine on my computer, but when someone else tries to use the macro on their own computer, it errors. Sub ExportToPDFs() ' Save Each Worksheet to a separate PDF file...

I am trying to format a text file, that is the result of exporting PDF comments from Adobe, into a table when I import it. The text file is formatted like this, with the comments on a certain page being located beneath the page number. Summary of Comments on RandomDocmument.pdf Page: 1 Author...

I have a button that uses the following code to print the information in the range of cells to a PDF: Private Sub CommandButton1_Click()ActiveWorkbook.Worksheets("Sheet1").Range("L2:L35").ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=Filename, _ Quality:=xlQualityStandard, _...

Hi all, I have a couple newbie questions for a PDF Export Command Button for a workbook. Right now I have created a section on a sheet with checkboxes (triggering a TRUE/FALSE value on each sheet) for printing/exporting. -- removed inline image --- The macro code for the Print work fine...