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