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