VBA to put a copy of worksheet on the desktop

J

Jack Sons

Hi all,

In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I can
refresh sheet ABC.
When the code finishes it job I want to make a copy of that sheet in a
separate workbook.
Then the actual date (short European notation dmyy) and time (f.i. 241110
16.31) should be added to the name of the sheet in that new workbook (which
becomes ABC 241110 16.31),.
The new workbook (with this one sheet) may get the same name.
After that I want to place that workbook as an icon on the desktop of my
computer.

Is this possible? If so, please help me with the necessary code.
Thanks in advance for your assistance.

Jack Sons
The Netherlands
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top