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 (AKSHAY YADAV)]

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 (Sumit)]

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 (AKSHAY YADAV)]

It is a selectors problem basically. check with UIExplorer

[kararora (karan arora)]

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

[Louis_D (Louis Diesel)]

Hi,

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

[Louis_D (Louis Diesel)]

@aksh1yadav @Eesh_Tyagi

[eb978xz (Yida Zhao)]

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

[Amruthrao_Amruthrao_A]

any solution for huge MB size as from front end if file size is high than it is hanged.

[abhinavkeshri8]

Hi Askhay,

Thank you for sharing this, however could you please help me with steps where we can attach an object to excel without opening excel (Backend).

Regards,
Abhinav