pdf conversion

Hey everyone, I have recently converted from a PDF to Excel and have various formatting issues which I am trying to fix. Below is an example of the table once converted. ABCDEFGHIJKLMNOP1Ref 1Ref 2TitleDocsTimeStatusRemarksLastNext 1Next 2Next 32testremark 13123456test aN/Aremark 24remark...

Hi everyone, I've got a bit of a weird question that's come about at work and I've found bits and pieces of possible solutions, but nothing definitive. We use form fillable PDFs to gather proposals (some dropdowns, some free-text, very little numbers) and we need to use that as a viable data...

I have a macro that refreshes some pivot charts in a page of data and then exports the data into a PDF format: Sub Export_PDFReport() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual ActiveSheet.PivotTables("PivotTable1").PivotFields("Total").CurrentPage =...

directory: X:\Case study - 11\Code\Reports Step 1: I am fetching the data from the pdf (filename:ceds) in excel by doing this: "Data -> get data -> from pdf". Step 2: I then obtain 7 different sheets in a current excel file. Step 3: I want to save this excel file in a folder(folder...

Hello friendly excel people 🙂 I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page. What I'm trying to do, is to...

I have a converted spreadsheet (from a PDF) that contains location records in multiple rows and columns for hundreds of properties. I would like to create a separate tab of two columns (property name/cell address,) based on a search for "NAME:" in the all of the data. The conversion did not...

I have an Excel document that I convert to PDF. I then need to insert a signature line in Adobe so I can send it out with Adobe Sign. Is there a way to have a signature line convert with the PDF, vs having to always place it in?

It is possible to take website snapshots quickly and easily with any chromium-based browser (this includes Chrome (obviously), MS Edge, Brave, and Opera) as they all include headless browser functionality - this means that you are able to use VBA give your browser instructions to generate...

I tried to create a procedure whose objective is to convert the excel spreadsheet to pdf and save it in the folder "D:\Users\(UserName)\Documents\Project\(MachineName)", this program will be used by several users on different computers , how can I make the PDF be saved in the documents...

Hi, I've got a spreadsheet that I use as a dashboard and we have navigation links to the various sheets that are hidden from the users and when converting the dashboard to PDF, the internal links don't work. Any thoughts on options for this?

Hello- I have a folder with 25 different PDFs that have values of different investments. The PDFs can be grouped into 4 different layouts, meaning 10 are organized the same way but with information specific to that PDF, 9 others organized the same way but with info specific to that PDF, and so...

I have created a macro based program and in that i am using a code to convert excel sheet into pdf. The program is now saved on shared folder on the computer network for use by all. The vba code to convert to pdf works fine from my computer when the .xlsm file was only on my computer and also...

Dear MrExcel community. Over the last year I have needed to collect and process more and more data which is coming my way from an online survey distributed to colleagues. The output of this survey is generating an array of data which is 40 column x 300 row (thereabouts). I am currently...

Excel VBA code to write Print Area as PDF and email Hello, I have created a excel workbook that uses =Indirect(“Data!A &RowIndex”) to pull data through into my news letter layout. In my news letter I have: Member First Name in cell (Data!A1 &RowIndex) Member Last Name in cell...

Hi, I have a folder of datasheets in a folder on a mapped drive N:\Datasheets All the computers in our office have N: drive mapped. I can insert a hyperlink to a file using the toolbar that displays as N:\testfile.pdf but if the mouse is located over the cell it shows...

I've tried numerous times to get a macro to save as PDF in a specific folder location combined with saving that PDF named as a cell's contents using cell J5. Just can't see what I'm doing wrong. What does work (doesn't include cell J5 naming) is shown below. It saves the PDF as "mega" which...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi all, I looked up a macro on this site to print an excel sheet to pdf, but I'm running into some issues when using it. Now, the post is 8 years old, so I suspect some of the commands have changed since it was posted. The error that I'm getting is a compile error "Assignment to constant not...

My company uses Xactimate estimating software to generate PDF estimates in the format shown below. Is there a way to convert the values in the tables to Excel without purchasing converter software? I only need the values in the tables with the headers "Description, Qty, Remove, Rep..." etc. so...

Hi all, Introduction: I am trying to find text differences b/w two PDFs via Excel. The PDFs I am comparing are older and newer versions of the Preferred Drug List (PDL) that state Medicaid programs publish 2-4 times a year. My team's current process is to compare the older and newer versioned...