Answered

How to send keys in Excel - ALT + W + F + R

(0) Share

Report

Posted on by sdfjlkfs

Hi there, I'm trying to freeze the top row in Excel from PAD. Tried various ways to send ALT + W + F + R keystrokes to Excel without success. What's the right way to do that? Any help would be appreciated!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @sdfjlkfs

It is working for me

You can send key to specific cell, here i am sending key to A1 cell.

Hope it helps 🙂
Mark it as solution if it resolves your query

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @sdfjlkfs

I would recommend running vbs script as well to freeze first row

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("%NewVar2%")

'Activate the first sheet
Set objWorksheet = objWorkbook.Sheets(1)
objWorksheet.Activate

'Freeze the first row
objExcel.ActiveWindow.SplitRow = 1
objExcel.ActiveWindow.FreezePanes = True

'Save the changes and close the workbook
objWorkbook.Save
objWorkbook.Close

'Quit Excel
objExcel.Quit

'Set objects to nothing
Set objWorksheet = Nothing
Set objWorkbook = Nothing
Set objExcel = Nothing

Here %NewVar2% is a variable passed from power automate flow which is the file path of excel file 🙂

Hope it helps 🙂

Was this reply helpful? Yes No
sdfjlkfs 16 on at

Like (0)

Report
Copy link

Link copied!

Thank you Nived! It works 😉

Was this reply helpful? Yes No