Assistance with Importing PDFs into Excel via Power Query

anaysha1

New Member
Joined
Dec 20, 2024
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Dear Professionals,

I am working on a task that involves importing PDF files into Excel using Power Query. The process requires importing each PDF file from a folder, transforming all pages from the PDFs into Excel, and then saving the resulting Excel file in the same path but under a newly created "Output" folder, with the same name as the original PDF file.

If you could please provide me vba code that can be use in excel that would be helpful for me.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Dear Professionals,

I am working on a task that involves importing PDF files into Excel using Power Query. The process requires importing each PDF file from a folder, transforming all pages from the PDFs into Excel, and then saving the resulting Excel file in the same path but under a newly created "Output" folder, with the same name as the original PDF file.

If you could please provide me vba code that can be use in excel that would be helpful for me.
Hi Experts, please support here.
 
Upvote 0
Is each pdf in a different folder. Really need to know more about your situation. It would be beneficial if you uploaded samples to a third party site like dropbox or box.net so that we can better understand what you are attempting to achieve. It would also help if you mock up a solution for the sample you provide. We cannot envision what you want unless you show us or explain in complete detail. Your explanation is short of a lot of detail.
 
Upvote 0
Be patient. I don't use Power Automate. Someone will come by.
 
Upvote 0

Forum statistics

Threads
1,226,267
Messages
6,189,940
Members
453,583
Latest member
Ok_category1816

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top