Send hotkey does not work

Ask in Your Language 中文
1

%E6%97%A0%E6%A0%87%E9%A2%98
%E6%97%A0%E6%A0%87%E9%A2%98540×720 18.3 KB

I want to insert a column with formula in excel. Below is what I did:

  1. write value to cell “w2”
  2. select range w2:w10
  3. send hotkey ctrl+d to apply the formula.

But step3 does not work.
Any help?

2

@cllrebecca

Have you checked ‘Visible’ option for Excel Application scope activity or not ?

3

Yes. I checked Visible

4

Is it becasue I didnot save the excel after send hotkey ctrl+d? How to ?

5
  1. Pass Hotkey and then use Save Workbook
  2. Without exiting Excel Application Scope place a message box after Send Hotkey and check if Formula is working without clicking OK on message box.
    3)If working then use Save Workbook Activity otherwise check selector of Hotkey
6

thanks. works now

1 Like
7

Can you mark this as solution?

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.