pdf conversion

I have an Excel workbook with multiple worksheets titled P1, P2, P3, etc. I would like to create a macro that combines multiple worksheets into one pdf, but only based on a particular cell value. For example, look at cell L1 in each spreadsheet and if the value equals 1 include it in the...

I was wondering if someone could create a macro that could convert and save a spreadsheet to a PDF, but also, save it as version 2, or anything to distinguish it from the old one if it was already saved? I'm new to excel so any help would be appreciated.

Hello, I've been working in a piece of code that changes, in another workbook, the name of each tab according to cell values and saves each worksheet as pdf file. It does change correctly the tabs name and saves them as PDF, also correctly (named according to each tab name). However the info...

I have a ton of invoices I've extracted from a couple of email addresses that I then turned into Excel documents with the Able2Extract PDF to Excel convert. The problem however, is the data looks like this: Untitled-1.jpg And I'm wanting it to have one big excel sheet with multiple columns...

I have an excel worksheet with ~20 different pages that i would like to save individually as pdfs to specific folders. This is a process that I have to repeat often with fresh data. My 1st idea is a macro that uses the ExportAsFixedFormat function, where i can use variables to update the...

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

Hello all Excel Experts! I have VBA code which uses the .ExportAsPDF method to export my workbook to a PDF file. I need to be able to password protect that PDF file so that it can not be modified. I can do this either with VBA or by running external (DOS) code. Does anyone have any suggestions?

This forum has been invaluable to me, thanks for all of the past help and any that you can give with this issue. My problem relates to PDF files. I use PDF's for a slide presentation of data from a variety of worksheets. Originally I modified some PDF software from Dominic (I think) from...

Hi, I used Adobe Acrobat to convert PDF files to Excel files. When I open the file it looks good, including the column of dates. However, when I sorted by date I get a mess. It turns out that many, but not all, of the the dates are in Afrikaans. So although the cell displays 04/12/15 (April...

Hi everyone, I need you help here. I have PDF table and I want to past in excel then some mistake in text like below. <colgroup><col width="64"></colgroup><tbody> animals ? 2015, wild?area - ?forms </tbody> So any one can help for this solution. :confused::confused::confused:

Hi experts, I have a very serious problem. I have around 600 PDF files and i want them to convert to excel sheets. PDF are in table format. Check image below. I really need your help. Please tell me the best and accurate way to do this. Thank you very much NOTE - I have tried many...

Hello All, Apologies in advance for the long type to follow... But I have a situation where I thought I had the PageSetup going smooth. But the product I receive is just a snippet of what I am after and it keeps slicing my tables off at the page breaks. See Code Below↓ I left out the codes...

I'm looking for help transferring data from a PDF to Excel (the PDF link will be at the bottom of this post). Specifically, I need to get addresses from this document, so, three lines of text into four different cells. I don't need to include the state, but I do need to separate city and...

Hi, I have just started a new job recently and have given given the task of creating the excel of all the pdfs brochure they have. now i can copy paste the things from pdf to excel but that is really cumbersome and boring, can anyone please help me converting the pdf to attached excel format, i...

Hi Team, Once again, I would really appricate your help! Background: I am creating a workbook - where the user selects difference criteria (slicers), which specifies which worksheet is relevent (out of 26 different options). The user then inputs some varible which in turns updates the...

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

Hi, I have some charts in Excel 2007 that I am trying to save as PDF. When I save it as a single worksheet, it saved fine. However, when I group together 6 sheets, the chart sheet skews. The axes and chart titles are not in line with the chart. It's very strange. Has anyone seen this happen...

Hello all, I am having some difficulty with a pdf that I converted to an excel document because I wanted to use the data from the pdf tables in a different program I am currently working on. However, the data is in the improper format. For example, in the table it reads 2-1/8 as string and I...