need code

J

Jack Sons

If anybody reads this: This is the xth time I post the question below
the dotted line, but to my chagrin the post never appears in this NG.
Since more than 20 years I am a user of this NG
(microsoft.public.exel.misc). Sometimes I do not post for months, and
another time I may post three questions in a week, all depending on my
activities. For some two weeks my postings seem not to come through, I
do not see them in this NG (I tried the NG
microsoft.public.exel.programming but also to no avail). Am I blocked
by those who manage this NG? What ohter cause could there be? Please
answer to (e-mail address removed).

Jack.
----------------------------------------------------------------------------------------------------------------------------------------------

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.
 

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