pdf convert

I have a PDF that has three pages - each page has a header and detail and the last page has an additional footer. I'd like to use Power Query to import the PDF tables into Excel I ran the File ->Get data ->From File -> From PDF and it came back with 6 tables and three pages I'd like to import...

Hi, I have two tabs, one called Service and the other called Sub Service. The Service tab is in Portrait mode where as the Sub Service tab is in landscape mode. What I want to do is is run some code that PDFs both files as they are into one document however whenever I do this it seems to only...

Hey there! I am Mark Daniel, and I am new to this forum. I'm having trouble figuring out how to upload a PDF into Excel. Please tell me the solution. Waiting response. Thanks

I am trying to find a way to create a button that will upload data from a pdf file. I am familiar with the "Data>Get Data>From file>From pdf" way of importing the data and am simply trying to create a button that allows the user to open the display that allows them to select a pdf file to...

Hello, I am trying to export a large amount of worksheets into separate pdfs with the file name as the sheet name but I am getting error invalid call or procedure but im not sure what is wrong, any help would be appreciated. Option Explicit Sub ExportAsPDF() Dim Folder_Path As String With...

I have a code to Export/Copy Data from Pdf to Excel using Word. (I have included the code below) So the code should create a Word file and import the selected Pdf file and copy every page as a table to word and then to excel. the code should run with in "tbindex = 0 to wDoc.Tables.Count" Range...

Hello! I am working in a tool to generate reports. I have created a form in one worksheet "Report" and when a change a cell values related to the tag, this form is be populated with the information related to that tag number. I created the following code, but after the macro finish running, the...

Hey hey people. I was tasked with making a macro which combines two ranges into one pdf, one sheet for each range, and sends the single pdf to a list of emails. I have managed to get two seperate pdfs sent to the email list, but I am pretty stumped on how to combine the ranges. I initially came...

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

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

Hello Guys, I was looking for macro codes that can convert pdf files to excel and found this helpful blog - PDF to Excel Converter in Excel VBA - PK: An Excel Expert It runs smoothly but I noticed that it doesn't replace the file PDF type to excel. I was thinking there's something wrong...

Hi Everyone, I was curious if anyone knew of a way to export an excel chart to PDF of which will include a layer for each data series. The ultimate goal is the ability to send a client a series of charts which they will be able review and turn on/off the different series, some of which overlap...

Hello! We are taking a lot of time to manually convert different file types to PDF to be uploaded into an imaging system. I have this code to convert .doc to .pdf, and it's working: Sub WordtoPDF() Application.ScreenUpdating = False Dim file Dim path As String path = "U:\Documents\File...

Apologies if this is in the wrong place, or has been asked before. i am trying to create code to enable me to have a sheet that would enable the user to automatically save as PDF, but only if the cell B6 is completed, this is the code i have. This asks for B6 to be completed but will then go on...

At work, I am able to download a mailing list from our database, but it always comes out as a pdf. When converting the pdf to Excel, it makes a new worksheet for each page of the pdf. This sometimes results in an Excel workbook with 300+ worksheet tabs at the bottom, each with 50 rows. They...