Apr 07 2021 09:12 PM
I have a folder with subfolders in it. Each folder will have some Excel files coming into it whenever user generates Excel reports. I want to convert these Excel reports into pdf files automatically. Any one of the following will work:
1. Generate pdf automatically whenever a new Excel file is generated or added into a folder OR
2. Generate pdf files for all Excel files at a set time once in a day.
Request experts to guide how this can be achieved. Thank you in advance.
Regards,
Pawan
Apr 08 2021 12:30 AM
Because you don't describe exactly what you want.
Specific area in the worksheet,
Single worksheet in PDF,
Certain worksheets in the workbook,
Whole workbook in PDF.
Here is a Link of what I once found on the Internet.
Saving a Range of data as a PDF with a button in excel
There are many ways to find a solution, that is the magic of Excel. It depends on what you need the solution for.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Apr 27 2021 11:26 AM
Apr 27 2021 12:20 PM
I'd ask Power Automate or PowerShell people, that's more question for them.
Apr 27 2021 01:16 PM