Hi Guys,
I am trying to collaborate with a graphic designer sitting on the other side of the world. The only communication medium we have is a phone line. Every time she makes even a minute change to an element on a page, she has to take a screenshot, save it and mail it - all manually till now.
As you can guess, this gets downright irritating and is significantly hampering progress on the project.
My idea is to create a simple .xls file with a macro which will capture a specific hotkey combination (in a global manner) so that she can just press ctrl+shift+q (or whatever) from inside her photoshop / illustrator with the .xls file open and minimised (and the macro listening for the key combo) and this key combo would capture the screenshot and send it to outlook / thunderbird as an attachment just waiting for the send button.
My question is whether this is the best (and free) method of achieving this and if it is then how can we make an excel macro listen for global hotkeys, capture screenshot and mail?