topic RE: Send Keys to Excel through Code Stage in Product Forum

Send Keys to Excel through Code Stage

nikhiln — Fri, 14 May 2021 09:30:00 GMT

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
------------------------------

RE: Send Keys to Excel through Code Stage

GeoffHirst — Fri, 14 May 2021 12:24:00 GMT

Hi Nik,

Thanks for using Blue Prism.

There is another VBO called Windows Sendkey you should be able to find it here .

Please advise if this helps.

regards

Geoff Hirst

------------------------------
Geoff Hirst
Partner Pre Sales
Blue Prism
------------------------------

RE: Send Keys to Excel through Code Stage

nikhiln — Fri, 14 May 2021 12:54:00 GMT

Hi Geoff,

Thank you for the VBO link, Is there any documentation or use case representation for using this VBO .

Thanks

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

RE: Send Keys to Excel through Code Stage

AntonHosang1 — Fri, 14 May 2021 13:05:00 GMT

Hi Nik, why not make another Excel Action, and use this code if you already have the region selected.
Selection.CopyPicture(Appearance:=1, Format:=-4147)
Tweak as necessary to make it more flexible:

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

RE: Send Keys to Excel through Code Stage

nikhiln — Fri, 14 May 2021 13:12:00 GMT

Hi Anton,

Thanks for the suggestion but, I am not using spy mode for Excel Operations.

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

RE: Send Keys to Excel through Code Stage

GeoffHirst — Fri, 14 May 2021 13:32:00 GMT

Hi Nik,

I am not sure about an actual example but there is a user guide if you sign into the Digital Exchange and search again for the asset, you can be taken to the full page description where you will find a link to the user guide. It is possible that an example exists in their download file.

An alternative for you. There is the Utility - Strings asset, this should be in your Blue Prism install location. There is an action called Escape Sendkeys String that might help or at least give you some direction to create exactly what you need yourself.

regards

------------------------------
Geoff Hirst
Consultant - Digital Exchange - EMEA
Blue Prism
------------------------------

RE: Send Keys to Excel through Code Stage

AntonHosang1 — Fri, 14 May 2021 13:53:00 GMT

Hi Nik, it's not referring to spying
You asked for a code stage (" Is is possible to do the same via code Stage.")

So if you wish to use the Excel VBO and simply make another code page in there, then the code above can help. It would work on a range that is already selected. Otherwise you can tweak it to put the range address instead of 'Selection'.

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

RE: Send Keys to Excel through Code Stage

nikhiln — Fri, 14 May 2021 14:07:00 GMT

Hi Anton,

Apologies for misunderstanding, can you send me the complete code .

Thanks

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

RE: Send Keys to Excel through Code Stage

AntonHosang1 — Fri, 14 May 2021 14:32:00 GMT

Put 4 inputs: handle, workbookname, worksheetname, address
No Outputs needed.
This will need the range address like "A1:C5" for the area to copy as picture.

Dim ws As Object = GetWorksheet(handle, workbookname, worksheetname)
ws.Range(address).CopyPicture(Appearance:=1, Format:=-4147)

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

RE: Send Keys to Excel through Code Stage

nikhiln — Fri, 14 May 2021 16:18:00 GMT

Hi Anton,

Thanks for the code, I am able to copy the image, Can i use the same syntax o Paste the image to another excel cell?

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

RE: Send Keys to Excel through Code Stage

AntonHosang1 — Tue, 18 May 2021 19:55:00 GMT

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
------------------------------

RE: Send Keys to Excel through Code Stage

nikhiln — Wed, 19 May 2021 08:22:00 GMT

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
------------------------------