Create a new workbook every week and paste picture per sheet

[Ron Morris]

Hi,

This is what I had in mind but am definetely open to better solutions.

I have sent an Excel file to a customer where they can generate their own quotes based on the criteria they choose. Once they are finished, they click on a save button which will save the file by the quote number they enter onto their drive.

What I would like to do is take the quote page only and paste it into a new workbook. I would like a new workbook created each week automatically. Each quote page would represent a sheet in the workbook. I would also like the sheet to be added automatically (representing the quote).

I can handle the code for the copy/pastespecial/picture but am not sure how to do the rest or if there is a better way.

Thanks in advance.

Ron

 

[Anne Troy]

Ron: I'm checking "unanswereds". I don't understand what you're saying. Could you possibly reword it?

 

[Ron Morris]

Hi,

The file I have sent the customer is 1MB. I do not want them to send me an E-mail everytime they do a quote because it is too large and takes too long to open.

I would like to just get a copy of the quote (which is on it's own tab), and copy /pastespecial as a picture into a new workbook that could be automatically created each week. Every quote would be it's own tab (sheet). I would like to have each sheet renamed as the quote number, which will be on the quote sheet.

Here's another thought: If the limit is 255 sheets per workbook, why not create a new workbook once the limit of 255 sheets is reached.

Is this even possible?

Ron