Modify a batch of word documents

(0) Share

Report

Posted on by mbeser

Hello everyone.

I am new with Power Automate Desktop and i'm looking for a automation flow.

I have a document folder, which includes .ie 100 Word documents. In manually i need;

1. Open each word documents

2. Change the fonts ie Arial 12

3. Save the document.

Can i do this with power automate, without manual operations?

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (5)

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (1)

Report

Get Files
For each %CurrentItem% in Files
Launch Word Open: %CurrentItem%
Use the Desktop Recorder to use the menu to Select All, Arial Font, size 12
Save and Close Word
End #For Each

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like (1)

Report

You could even use Save As instead of just Save, and save the new version to another folder, then delete the old version; that way if something goes wrong, you will know which ones are done and which ones aren't.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report
Hello @mbeser

You can use keyboard shortcut "Alt - H - FF" to focus into the combobox of font name in the ribbon of Word app.

Below is my sample flow that meets your requirement.

Folder.GetFiles Folder: $'''C:\\Users\\User01\\Documents\\Word Files''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files SET FontName TO $'''Verdana''' SET FontSize TO 12 LOOP FOREACH CurrentItem IN Files System.RunApplication ApplicationPath: $'''C:\\Program Files\\Microsoft Office\\root\\Office16\\WINWORD.EXE''' CommandLineArguments: $'''/t \"%CurrentItem.FullName%\"''' WindowStyle: System.ProcessWindowStyle.Normal ProcessId=> AppProcessId WAIT (UIAutomation.Windows.ToOpenByTitleClass Title: $'''%CurrentItem.NameWithoutExtension%*''' Class: $'''''' FocusWindow: True) MouseAndKeyboard.SendKeys TextToSend: $'''{Control}({A})''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys TextToSend: $'''{Alt}(){H}{F}{F}%FontName%{Tab}%FontSize%{Tab}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys TextToSend: $'''{Alt}({F4}){Return}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: False END

Launch WINWORD.EXE application with /t switch to open your file.

Wait until window of Word application which has your file name in title bar will open.

Then send keys what ever as you like.

Thank you.

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (1)

Report

Hello @mbeser

As per your note if you want to do it without manual operations then you can
- Write an Excel macro that changes the font of Word documents (tons of readymade code easily available on the web)
- And then call that macro from within PAD.

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report

@mbeser
PS: I can help you with the macro in case you need.

Was this reply helpful? Yes No