VBA to save range as an image with specific file name?

Hey there! This forum has become my home away from home when it comes to solving my Excel issues, so just a pre-emptive thank you for all the awesome suggestions and feedback everyone offers!

I'm in a pickle and could use some help. Currently we use a spreadsheet at work to assign people to their job tasks for the day. Once that spreadsheet is filled out, we select the relevant range, copy it into a photo editing program, then save it as a jpeg. This seems like an unnecessary step, so I wanted to see if I could make an ActiveX button that'd allow us to click it and have the image saved straight from Excel. Here's the code I have thus far:

Formula:

Please Login or Register  to view this content.

And this works!... sort of. It creates a chart of the image, but it's small-ish and has a ton of negative space. I'm not sure if I'm able to set the size or have it auto-fit to the size of the range selection?

Also, I figure while I'm trying to make this more streamlined anyway, is there a way to integrate some VBA code to also have it save the file as something unique each time? Here's what I had in mind:

Cell E1 has a date in it. It'd be cool if I could put some code into the existing code I have up there so it saves the file name as "SavedRange_DATE-IN-E1.jpg".
I feel like this is doable, so if I can get the image portion sorted I'm sure I could figure out the saving aspect, but if anyone has input while you're here then hey, I'd love to hear it.

Thanks!

Just wanted to bump this one time in the hopes that someone might be able to help. Thanks!