software

Is there a way to copy a file automatically on opening it, before any changes
are made to it (to be used as a failsafe in case the user does not save it
before opening it or before they open and change it, and then want to use it
again)? That is, I want to email a file to someone and, when they open the
file, I want a copy of it to be made automatically, so they will have it to
use again at another time. (I don’t know if it would make any difference, but
a macro is contained in this file.)
--
Dolores

save your file as a template rather than an excel workbook.I save my
templates in the same place as the original workbook.When you open a template
it opens as a copy of the original.
--
paul
remove nospam for email addy!
quot;Doloresquot; wrote:

gt; Is there a way to copy a file automatically on opening it, before any changes
gt; are made to it (to be used as a failsafe in case the user does not save it
gt; before opening it or before they open and change it, and then want to use it
gt; again)? That is, I want to email a file to someone and, when they open the
gt; file, I want a copy of it to be made automatically, so they will have it to
gt; use again at another time. (I don’t know if it would make any difference, but
gt; a macro is contained in this file.)
gt; --
gt; Dolores

Thank you for your suggestion, Paul. It is not exactly what I would like to
find.

quot;Copy the file first,quot; quot;SaveAs immediately,quot; and using a template all
require giving instructions to the user. I had hoped to find something that
would be invisible to the user.
--
Doloresquot;paulquot; wrote:

gt; save your file as a template rather than an excel workbook.I save my
gt; templates in the same place as the original workbook.When you open a template
gt; it opens as a copy of the original.
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Doloresquot; wrote:
gt;
gt; gt; Is there a way to copy a file automatically on opening it, before any changes
gt; gt; are made to it (to be used as a failsafe in case the user does not save it
gt; gt; before opening it or before they open and change it, and then want to use it
gt; gt; again)? That is, I want to email a file to someone and, when they open the
gt; gt; file, I want a copy of it to be made automatically, so they will have it to
gt; gt; use again at another time. (I don’t know if it would make any difference, but
gt; gt; a macro is contained in this file.)
gt; gt; --
gt; gt; Dolores

i thought what i said did exactly what you want...if you send your file as a
template instead of a normal excel workbook,when the third party clicks the
icon for your file it automatically opens as a copy,ie say your workbook is
called Dolores it will open as Dolores1,the original Dolores is quot;untouchedquot;
--
paul
remove nospam for email addy!
quot;Doloresquot; wrote:

gt; Thank you for your suggestion, Paul. It is not exactly what I would like to
gt; find.
gt;
gt; quot;Copy the file first,quot; quot;SaveAs immediately,quot; and using a template all
gt; require giving instructions to the user. I had hoped to find something that
gt; would be invisible to the user.
gt; --
gt; Dolores
gt;
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; save your file as a template rather than an excel workbook.I save my
gt; gt; templates in the same place as the original workbook.When you open a template
gt; gt; it opens as a copy of the original.
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Doloresquot; wrote:
gt; gt;
gt; gt; gt; Is there a way to copy a file automatically on opening it, before any changes
gt; gt; gt; are made to it (to be used as a failsafe in case the user does not save it
gt; gt; gt; before opening it or before they open and change it, and then want to use it
gt; gt; gt; again)? That is, I want to email a file to someone and, when they open the
gt; gt; gt; file, I want a copy of it to be made automatically, so they will have it to
gt; gt; gt; use again at another time. (I don’t know if it would make any difference, but
gt; gt; gt; a macro is contained in this file.)
gt; gt; gt; --
gt; gt; gt; Dolores

Paul, thank you very much for your reply and our patience. I do believe the
template is the best solution.

I am not very familiar with templates myself. My concern, and the reason I
would like something that iscompletely invisible to the user, is that there
are so many other instructions that will accompany this file that I was
hoping not to need an instruction for opening the file. Also, I think many of
the people who will be receiving the file will not be familiar with
templates—which is fine is they doubleclick to open the file. But, if they
open the file by rightclicking, then they have a choice of either New or
Open—and even though New is bolded, I am concerned that without an
instruction telling to choose New, they will choose Open.

In order for an instruction to be needed only the user who opens the
template instead of opening a new file, is there a way to prevent the user
(who chose Open) from using the template itself? And, if so, is there a way
to then give the person who opens the template itself an instruction like,
“Please close this file (without saving changes, if any) and open the file
again either (a) by doubleclicking it or (b) by rightclicking it and choosing
New (to retain the original file for future use)”?
--
Doloresquot;paulquot; wrote:

gt; i thought what i said did exactly what you want...if you send your file as a
gt; template instead of a normal excel workbook,when the third party clicks the
gt; icon for your file it automatically opens as a copy,ie say your workbook is
gt; called Dolores it will open as Dolores1,the original Dolores is quot;untouchedquot;
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Doloresquot; wrote:
gt;
gt; gt; Thank you for your suggestion, Paul. It is not exactly what I would like to
gt; gt; find.
gt; gt;
gt; gt; quot;Copy the file first,quot; quot;SaveAs immediately,quot; and using a template all
gt; gt; require giving instructions to the user. I had hoped to find something that
gt; gt; would be invisible to the user.
gt; gt; --
gt; gt; Dolores
gt; gt;
gt; gt;
gt; gt; quot;paulquot; wrote:
gt; gt;
gt; gt; gt; save your file as a template rather than an excel workbook.I save my
gt; gt; gt; templates in the same place as the original workbook.When you open a template
gt; gt; gt; it opens as a copy of the original.
gt; gt; gt; --
gt; gt; gt; paul
gt; gt; gt; remove nospam for email addy!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Doloresquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there a way to copy a file automatically on opening it, before any changes
gt; gt; gt; gt; are made to it (to be used as a failsafe in case the user does not save it
gt; gt; gt; gt; before opening it or before they open and change it, and then want to use it
gt; gt; gt; gt; again)? That is, I want to email a file to someone and, when they open the
gt; gt; gt; gt; file, I want a copy of it to be made automatically, so they will have it to
gt; gt; gt; gt; use again at another time. (I don’t know if it would make any difference, but
gt; gt; gt; gt; a macro is contained in this file.)
gt; gt; gt; gt; --
gt; gt; gt; gt; Dolores