Help needed: Pasting image from clipboard to excel

[Anonymous]

Hi, I am currently taking numerous screenshots and pasting onto a single document. I am trying to paste these images then onto a worksheet within my excel spreadsheet. I am running into issues trying to paste these images in. A paste special error message keeps popping up. Please let me know if I am missing anything. Thank you for the help! I am currently using the following objects: Microsoft Word VBO: -Select All -Copy to ciipboard Microsoft Excel VBO -Paste

[Anonymous]

Hi, Follow below steps to Paste Clipboard to Excel worksheet. Added new page in MS Excel VBO As ""Paste from Clipboard"" Step 1:- Add two Data Items Handle (number) Document_Name (string) Step 2:- Right Click Start Stage -> properties -> Add Inputs:- 1. Handle 2. Document_Name • Store in use above Data Items (Handle, Document_Name) Step 3:- Add Code Stage. Step 4:- Right Click Code Stage -> properties-> Add Inputs:- 1. Handle 2. Document_ Name • Values use above Data Items (Handle, Document_Name) Step 5:- Go to Code tab Paste following code Dim range As Object Dim d As Object = GetWorkbook (Handle, Document_Name) Dim w As Object = d.Application range = w.Selection range.PasteSpecial d = Nothing w = Nothing Step 6:- Close Code stage. Step 7:- Link the stages, save and publish than u can use it. * Please find the attachments screen shots Regards, AE.

[Anonymous]

Image to Clipboard :- Code Stage Input - > ValueImage My.Computer.Clipboard.Clear() My.Computer.Clipboard.SetImage(ValueImage)