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 dont 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!



"Dolores" wrote:

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 dont know if it would make any difference, but
a macro is contained in this file.)
--
Dolores

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

"Copy the file first," "SaveAs immediately," and using a template all
require giving instructions to the user. I had hoped to find something that
would be invisible to the user.
--
Dolores


"paul" wrote:

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!



"Dolores" wrote:

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 dont know if it would make any difference, but
a macro is contained in this file.)
--
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 "untouched"
--
paul
remove nospam for email addy!



"Dolores" wrote:

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

"Copy the file first," "SaveAs immediately," and using a template all
require giving instructions to the user. I had hoped to find something that
would be invisible to the user.
--
Dolores


"paul" wrote:

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!



"Dolores" wrote:

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 dont know if it would make any difference, but
a macro is contained in this file.)
--
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)€�?
--
Dolores


"paul" wrote:

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 "untouched"
--
paul
remove nospam for email addy!



"Dolores" wrote:

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

"Copy the file first," "SaveAs immediately," and using a template all
require giving instructions to the user. I had hoped to find something that
would be invisible to the user.
--
Dolores


"paul" wrote:

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!



"Dolores" wrote:

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 dont know if it would make any difference, but
a macro is contained in this file.)
--
Dolores