excel to pdf

There is a worksheet called "Index" in column F. Various sheets are listed therein. I am currently using below code to export listed sheets as pdf. Currently all the sheets are individually exported. I want all of them to be saved as pdf in a signle pdf file with file name as mentioned in cell...

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...

Hello I am providing the link of a pdf file here You cannot view this file so you will have to download and open it in Adobe PDF only. Once you open the file it will look like Image 1 (that I have attached) The form name is LLP Form No.1 In the attached form on page 1---->Part A : Reservation...

Hi I'm a real rookie in the VBA world, so I hope you will bear with me. I've been working on a workbook, where the finishing touch is, that it generates a PDF with the final results. This means combining ranges from different sheets. So far I've manage to create an VBA code which creates...

Dear Forumers, I am very new to the concept of VBA. I have a workbook with an identical template in each sheet. Each sheet represents different areas of the business. What I want to do is, when I have all the information in these sheets, I want to send the selection of the print area as a PDF...

Hi, I am currently using a VBA code that I got of this site, made one or two adjustments to fit my needs, but the problem I am having is I want it to like shrink everything on the excel sheet to fit onto one PDF. As it is now it saves it as 4 - 5 pages and thus does not look good. Can someone...

Hi guys, I am trying to figure out this macro and can't seem to make it save correctly. I am trying to save this selection to pdf and then make it save the filename as "O'shirts Estimate (value of cell 4f and the current date). It only saves the file as this O'shirts Estimate & WST Screen...

Hello, This question most likely has already been posted before, but when I try to search for it I mostly get questions around creating an Excel button that will save a spreadsheet into a PDF. I have a xlsx file that I use for invoicing. In that file I have a button that navigates to a URL...

Hi All, New poster here on the site; I am a IT professional working in SAP BW/BOBJ. I need a little help from my VBA friends however. I have scheduled a report to be emailed to me daily, I need a VBA script to open the attachement then run an excel macro to format the file correctly. Finally...

Hello guys, My question is not only for excel but also for microsfot word and microsoft powerpoint. In a folder I have many .xlsx,.doc .docx, .rtf, .ppt, .pptx files. I need to convert all these files to PDF form. I have installed office 2010 which allows me to save files as pdf. I can also...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...