My file has 10 worksheets, the last of which is named TABLE and has a summary table of all data in range C2:G57. I need to be able to export an image of that summary table to frequent intervals each day. I'd like to be able to do it with a macro or single click. The only 2 methods I've employed so far are:
1) Manually select the TABLE worksheet, then open the Windows "Snipping" tool, highlighting the desired range, and then saving it as Capture.jpg on my desktop (overwriting the existing Capture.jpg file); OR
2) Manually select the Table worksheet, selecting C2:G57 with the cursor, then opening the Windows Paint 3D program, pasting the range, then cropping the picture area and saving it as an image to the desktop.
Both methods are pretty crude, and take 30-60 seconds. Is there a way for me to export the desired range as an image with a single click / macro?
1) Manually select the TABLE worksheet, then open the Windows "Snipping" tool, highlighting the desired range, and then saving it as Capture.jpg on my desktop (overwriting the existing Capture.jpg file); OR
2) Manually select the Table worksheet, selecting C2:G57 with the cursor, then opening the Windows Paint 3D program, pasting the range, then cropping the picture area and saving it as an image to the desktop.
Both methods are pretty crude, and take 30-60 seconds. Is there a way for me to export the desired range as an image with a single click / macro?