Send Keys to Excel through Code Stage

[nikhiln]

Hi All,

I need copy a specific section in Excel as an image using Excel short cut (Alt , H, C , P  Enter ) I can perform that action.
As Excel VBO is limited to specific functionality,  Is is possible to do the same via code Stage.

Thanks


------------------------------
Nik
------------------------------

[AntonHosang1]

Write another line in the code stage in the VBO to paste to the target Cell:
ws.Range(destinationAddress).PasteSpecial(-4104)
You'll need another input variable as named above destinationAddress

------------------------------
Anton Hosang
RPA Developer
Smart Automation Services
Europe/London
------------------------------

[nikhiln]

Hi Anton,

Thanks for the Code , I am getting this error "PasteSpecial method of Range class failed"
Please find attached the screenshot.

Thanks
Nik

------------------------------
Nik
------------------------------