• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Capturing Screen and pasting to Word while Excel is minimalized

mikerek

New Member
Hello guys,

I'm wondering if there is any possibility to run a macro using shortcut while excel is inactive.
But first things first...
My plan is to make a macro (the only way available in my company) which will be capturing the IE/Chrome window (while pressing some keyboard shortcut) and pasting this image to Word document. The problem is that the procedure has to be initiated while Excel is inactive (minimized). So presumably it should go like this:
-excel macro is initiated (or maybe Word macro would be better?)
-excel file is minimized (or not) by the user, but the program is "listening" for given shortcut
-shortcut is used so the screenshot should be taken and pasted to word file without activating excel
-and so on...
oh and word file can be inactive too.

or maybe there is some way to initiate macro from IE level? How do you guys think? I will be very grateful for any advise/idea.

Thanks!
 

Easy way : from Data menu, From Web
It is not a screenshot but a data grabbing.

For capturing screen there are different tools to achieve your need
but in a manual way …

For a programmatic way, you must search within Windows API
(I haven't found it in my archives) …
 
Back
Top