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.
1. When the code finishes it job I want to make a copy of that
sheet in a
separate workbook.
2. 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 name of the original sheet remains
unchanged.
3. 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
In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I
can
refresh sheet ABC.
1. When the code finishes it job I want to make a copy of that
sheet in a
separate workbook.
2. 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 name of the original sheet remains
unchanged.
3. 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