pdf creation

Ok something I haven't attempted before. I have a spread sheet that has sheet containing all of the information for different electrical loops. (sheet name "DATA") I started with a signal template on a separate sheet ("Cable Schematic") and I use other formulas directly in the cells on that...

I've got 2 seperate files. One is a macro-enabled excel(Data) with userforms ad another is a macro-enabled word(Cover Page) with userforms. I want to combine these 2 into a PDF to form a report. Is something like that possible? Could you also please refer to helpful articles on this situation...

I have an excel file with several macro that work fine on multiple computers. I have a new employee that just started and the macros do not work for him. He gets a runtime error -2147417848 (80010108). The specific macro is for creating a PDF is that matters. Not sure if it a setting in excel or...

Hello, Ill try an explain this as best I can. I need to open a workbook remotely called "Main Monthly File May2019_pre sonia.xlsx" select the sheet "Covered Bonds Movements" then set the print range "A1:H130" and then convert that area to PDF but the kicker is the PDF has to be 1 A4 sheet with...

Hi all, Hopefully this is possible. I have a workbook containing around 100 or so sheets. The first sheet is the summary sheet, that contains amounts owed by each customer. These are displayed as a list from top to bottom, with the amounts owed beside each name in the adjacent column. What I...

Hi All, The below code creates a PDF from a named range in cell A55 on the "Menu" sheet and saves this to a folder based in a value in cell A52 on the "Menu" sheet. What I'd like to achieve, is that if the value of cell A115 on the "Menu" sheet is "Zone" then output the PDF file to a path in...

This may be a little complicated and perhaps unachievable, so let me explain further. I make customer orders using an excel workbook template. This workbook contains 4 individual sheets which i need to print onto A4 paper. The sheets are automated from 1 master sheet within the workbook. So as...

Hi, I am trying to set up a macro so that when I run it, in loops through all the cells in a column that have a value, and creates a PDF (using the name / location from the adjacent column) So, I have a spreadsheet that looks like this: 1 c:\temp\1.pdf 2 c:\temp\2.pdf 3...

Hello All, I have a an Active X Button that when clicked brings up a Userform with checkboxes for each sheet in my workbook. What I am trying to do is allow the user to select which sheets they want to generate into a PDF. Currently, regardless of what checkboxes are selected once the user...

Hello all, I am encountering the following error message when I try to generate a PDF from a checkbox list of multiple sheets. "Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving." Any help would be appreciated with helping...

I have the below macro that prints a chart fine but I am curios if there is a way to reference to a cell on a different sheet not included in the print request for the file name ? Thanks in Advance Gerry. (Title!$AA$5) file name location Sheet name is Title Sub SaveREPORTEWToPDF()...

Hello All, I am trying to select sheets to generate a PDF by using a UserForm with checkboxes so the user can select which sheets he/she wants generated into a PDF. Below is my code and I feel as if I am close but I continue to get a "Run-time error '9': Subscript out of range" at the...

3 tabs involved: 1. Dashboard - displays graph and text dynamically filled upon selection of DataValidation list in cell C1 (on Dashboard). 2. Calc - where the data on Dashboard pulls from. It's an intermediate manipulation of the data that is entered in the 'Enter Local Program Data' tab 3...

Hey everyone, First time posting here, I was hoping I could get some help with a small piece of code. I have a folder full of invoices and each invoice is a separate excel workbook (totaling over 400 files). The prepared invoice is the first sheet titled "Summer Invoice" of each workbook. What...

Hi, I've situation like this. In "Sheet1" I'll have data like below list. <tbody> Employee No Name Category Amount 12236 ABCD Telephone $2100 12243 EFGH Medical $4200 12256 IJKL Telephone $1566 </tbody> The above data should come in the following format in...

I have 500 number in excel file need to mass create PDF files using VBA I’m using below Macro to write on PDF, however I failed to do mass PDF files creation from my excel list, any one can help please Sub WriteToAdobeFields() 'topmostSubform[0].Page2[0].f2_12_0_[0] Dim...

Hi, I've situation like this. In "Data" sheet i'll have data like below list <colgroup><col><col><col><col></colgroup><tbody> Emp. No Name Category Amount 12236 ABCD Telephone $2100 12243 EFGH Medical $4200 12256 IJKL Telephone $1566 </tbody> The above data should come in the...

Hi, I am using the code below to export an active sheet to Outlook. Most things work well, however, I want the PDF filename to be only the name of the active sheet as opposed to the full workbook name. I know it is something simple, but for some reason cant see it or get it to work. Any help...

Hi Excel Wizards, greetings from Portugal :) I have already checked every post about worksheet-to-pdf macros, and none does the trick for the problem I have... Can somebody please help me? I have an excel file with about 50 tabs, and I wanted to put a button on my summary sheet that would only...

I have code I am using to merge 2 different PDF's, if "gPDDoc1" has 1 page and "GpDDoc2" has 20 pages. I am not familiar with the page ordering of my resulting merged PDF: mergefile = gPDDoc1.InsertPages(1, gPDDoc2, 0, 1, 0) The full code I am using is here: Sub Merge() Dim gPDDoc1 As AcroPDDoc...