exportasfixedformat

Hello, I have a problem with exporting excel to a PDF, does anyone know how to solve this? (It works fine on another computer) Code: ActiveSheet.Range("B1:F8").ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & "/" & pdfname & ".pdf", Quality:=xlQualityStandard...

Hello all and Happy Upcoming New Year. Trying to wrap up a project that has generated a few threads. Thank you to all who have helped me along the way. I have a macro that takes .xlxs files from a desktop folder from a user and saves them as pdf's to specific sharepoint folders on Teams. My...

Totally confounded by this error. Sub has been working perfectly for some time and today stopped working out of the blue. Error code is 1004 - "Method "ExportAsFixedFormatType" of object _Worksheet failed." The sub takes a worksheet as a parameter then exports it to a pdf in a specific folder...

Hi, I am trying to create a VBA code which will generate a pdf report where multiple ranges from a sheet will be printed onto one page. In order to achieve this the ranges have to follow after each, hope that make sense.... So far this is the code I have been able to write Private Sub...

Hello, I need to create a button to save a selection of cells on a worksheet in excel as a pdf. Can anyone help with this? Many thanks, Kat

Hi, Excel 2016. I am trying to send a PDF in landscape orientation by mail using the ActiveSheet.ExportAsFixedFormat function. If I try printing the sheet it manually it works fine in landscape. But it does not work in VBA. I have googled this issue extensively for no solution. Sub...

Hi guys, Got some problems with ExportAsFixedFormat in VBA on Mac, more precisely with the parameter "FileName" which is defining our filepath. I want to decide where I will save file and which name of file will be. Usually I don't get error but when I'm trying to swap "FilePathName" in...

Hello, I have a macro that that fills out a template with textboxes and cells, then it prints to PDF via ExportAsFixeddFormat. It works great on the first run (creates 31 seperate PDFs each run), then on the second run (exact same data), it seems to be running great and bam after roughly 4 PDFs...

Hi all, I'm having trouble with the task of exporting all the worksheets in a workbook into a single PDF using VBA. I'm working on Excel 2011 for Mac. I've come across several suggestions on the internet, including here, and none of them result in a single PDF file containing the worksheet...

Hello, I'm using Excel 2010 and have Acrobat XI Standard. I have about 50 Excel files that I want to turn into 50 individual PDF files. Each Excel file has many sheets, and I want each PDF file to contain all the sheets and have a bookmark for each sheet. The bookmark should be the same as the...

I have a worksheet that I want to convert to PDF using ExportAsFixedFormat. I have a subroutine, PrintSheet, that formats the sheet's margins, header/footer, etc. If I print preview the sheet, everything looks great, but when I use ExportAsFixedFormat, the output PDF cuts off many rows and...

I am trying to use VBA to Open a workbook, save as PDF and Close workbook. When I run the script it will open the desired Workbook, however it does nothing else and I am unable to do anything in Excel. I then use TaskManager to End the Task so that I can try again. Here is the code I am...

Hello again, Got myself in a right muddle with a command button. All i want it to do is generate the pre populated form on sheet8 as a PDF, then open it. I tried this code: Sub ExportAsFixedFormat() Type As XlFixedFormatType Filename As Object Quality As Object...

I've created a web service that generates a dynamic Excel file that has charts and images, and converts it to pdf using ExportAsFixedFormat. I've managed to get it working perfectly on my development machine. Installed is Excel 2007 (v12.0.6661.5000) SP3 MSO (12.0.6607.1000) on Windows 7 Pro...