Create and Embed Objects in excel

[Eesh_Tyagi]

We can create and embed objects like (.pdf, images, another excel sheets etc) in excel using hot keys automation.

Flow

Go to insert tab --> ALT + N

Click on Text --> Key ZT

Click on create Object --> Key J

Click on create fro file – using click activity

Click on Link to file --> ALT + L(Select Send window messages)

Click on Display as Icon --> ALT + A (Select Send window messages)

Attaching the workflow.

excelObject.zip (252.8 KB)

[aksh1yadav]

HI @Eesh_Tyagi

Good Sharing

Here i just have removed the selector and made file path dynamic to read the current directory so others will find it easy to run , Once again nice and useful sharing

excelObject_Modified.zip (253.9 KB)

Regards…!!
Aksh

[sumitctm]

Hi @aksh1yadav,

I am getting error SelectorNotFoundException.Could you please look into it.

Main has thrown an exception

Source: Click on ‘Create from file’

Message: Click on ‘Create from file’ : Cannot find the UI element corresponding to this selector:

Exception Type: SelectorNotFoundException

Regards,
Sumit

[aksh1yadav]

It is a selectors problem basically. check with UIExplorer

[kararora]

Hello,
alt +N action is not working for after opening the excel by excel application scope.
Can you please help me ?

[Louis_D]

Hi,

Is it possible to specify the cell in which we want to embed?

[Louis_D]

@aksh1yadav @Eesh_Tyagi

[eb978xz]

Great sharing.
But I have seen this approach before with workflow attached