export to pdf

Need help with macro to perform following task. 1. I have a file (Original file) with 5 sheets (Index, Report1, Report2, Report3, and Report4) 2. Colum B in Index sheet contains list of sheets for which pdf file is to be created (e.g. it contains Report1 and Report2 in cells B1 and B2...

I have had some code which has always worked fine. However now it keeps erroring for some reason, I have highlighted where the script is erroring. I am simply trying to export the sheet to a pdf. The value in S2 was previously this ="AdminList "&TEXT(Controls!$B$2,"MMMM DD YYYY...

Hi, Is it possible to change the page orientation of specific pages within the same worksheet when exporting to PDF? I have written a macro that exports them all as portrait but I'd like to export certain pages as landscape as they have charts. Appreciate any assistance or guidance.

The issue I am having is that when I export the file to a PDF using VBA I loose my company logo at the top of the pdf version of the worksheet. It for some reason will not export with the file. While when I "print to pdf" it will stay attached. I have tried doing a command so that it prints to...

I am new to Excel VBA Still I had created an macro that work as I need. In an workbook I had two sheets(data and hello) so data's are in data sheet and print format is in hello sheet, Please find the below code which is working and the pdf is saving. But this code is only for two rows, Kindly...

I am new to Excel VBA Still I had created an macro that work as I need. In an workbook I had two sheets(data and hello) so data's are in data sheet and print format is in hello sheet, Please find the below code which is working and the pdf is saving. But this code is only for two rows, Kindly...

Hi Everybody, Today I stumbled upon a quirky issue. Manually I have been saving 2 sheets as PDF, and they have been combining into one PDF file very nicely. This includes the "page 1 of x" sequencing in the footers. Because this is becoming repetative for some workbooks, I wrote a macro to...

I'm creating an expense database for real estate apartments at an appraisal company. I want to create a macro that exports a photo for each property into a word doc or pdf. Each property is a different row, and I would put the photo into the last column of each row. It's a large database and...

for worksheet to pdf printActiveSheet.ExportAsFixedFormatand what is the code for userform to exportas fixed format?