Formatting multiple word documents to multiple PDFs after each one has had a macro run to format

Like (0) Share

Report

Posted on 10 Oct 2023 17:27:11 by KerryI

I’m fairly new to flows, but feel that I should be able to do this, but don’t quite know where to start!

I’ve taken on the responsibility of a process that I know can be streamlined.

I have on average 250 word docs that are generated by another software program into one folder, that are currently individually opened, run two macros, then saved as a pdf, and this happens each week, so takes hours. I think I can get the macros into one to simplify that element.

Anyone point me in the right direction??

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Michael E. Gernaey 52,096 Super User 2025 Season 2 on 10 Oct 2023 at 19:23:52

Like (1)

Report

Re: Formatting multiple word documents to multiple PDFs after each one has had a macro run to format

@KerryI

Unfortunately the answer is no, you cannot.

You can easily convert the word docs to PDF (if they are in SharePoint or OneDrive), but there is no way to run the Macro from Power Automate, not even with Graph API.

I wish I had a better answer for you, but since you need to run the Macro, its a no go from the Cloud version. Now from the Desktop Version, you most likely good indeep do this.

Or combine them and have the Desktop version loop the files, execute the Macros, then copy them or move them to OneDrive/SharePoint and then over there have a flow that then converts them.. but you could probably convert them to PDFs in the Desktop version also.. so

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
KerryI 5 on 11 Oct 2023 at 08:01:55

Like (0)

Report

Re: Formatting multiple word documents to multiple PDFs after each one has had a macro run to format

I'll ask the IT team if they will give me the desktop version and go from there - thank you

Was this reply helpful? Yes No