"Type into" Activity in Excel

Help Activities
1

Hi all,

I have a question regarding “type into” activity for Excel. How can I select the following “button”?

image

When I use this activity I can only select the drop-down arrow, but the different table formats do not appear. Can anyone help?

Best regards

Tom

2

Hi tom,

Can you please explain in more detail what you want to achieve so we could assist you more correctly!

3

I tried to click on the drop-down arrow first, then switched to Studio and clicked the button there. But then an error appears that “Document is not open in Excel”. This is not true though. Any ideas?

image

4

Error saying is Excel appears to be busy before running add Kill process for excel and let me know what error it gives again

5

I would like to format the table. When I click on the drop-down arrow through the activity, I only select this and not the formats directly. And if I select the formats in Excel beforehand and then only change the rows for them, Studio says that the document is not open in Excel (see screenshot). But this is obviously wrong. Any idea what the problem could be?

image
image887×390 16.6 KB

6

Hey tom if you are performing certain activities in excel so you try Macro also it will be much easier!!

Let me know if this resolves your issue.
Happy Automation
:slight_smile:

7

Hi @tom.ri

instead of doing in ui automation , you can have other option app/web recorder.

or you have the best option to go with excel vba macros they also you have record option.

8

@tom.ri,

You should be using Keyboard Shortcut activity for this.

Sample solution:

image
image535×1442 72.1 KB

Excel work

Sample code:

ExcelWork.zip (12.3 KB)

Thanks,
Ashok :slight_smile: