Auto screen shot

[Mohith6my]

Hi,
Required suggestion on this.

Once the command in excel is given , the excel should be minimized and the screen shot of the desktop has to be taken, the image of the screen shot has to be saved in a folder with file name from a cell in the excel and the link of the image should be available in another file.
Is this possible?

 

[John_w]

Try adapting the code at

Macro to take screenshot then save to desktop without user intervention

Not sure if this is even possible but I am looking for a vba script that will allow me to screenshot my screen, save it to a specific path and use a specific filename format without user intervention. It's like when I click the button it will automatically save it to my desired path without...

www.mrexcel.com

What do you mean by 'the link of the image should be available in another file'? What link? Which other file?

 

[Mohith6my]

For example, inputs will be given on column B and macro command will be given. The excel has to be minimized and the screen shot has to be captured against the filename of the input given in column B.