Your description of the problem is not clear, but I will try to parse it and
see if I can offer a recommendation.
You say you e-mail the WB, I assume as an attachment. You say there is a
specified path for saving the WB, I assume this same path is used by you and
the reipient which means that you each have a folder with the same name and
it is not on a shared server.
I assume the button you refer to has a macro attached to it to fill the
appropriate cells and initiate the save. If all this is true then:
If the file path/name must remain the same, then any existing file will be
overwritten when you save it. To avoid the alert dialog box, insert in your
code before the save line: Application.DisplayAlerts = False . Then after
the save line insert: Application.DisplayAlerts = True
If I have guessed wrong then you need to explain the problem a little better.
"Spreadsheet Solutions" wrote:
Dear members;
I send an email to someone containing a workbook to be updated.
The path and name off that workbook is : Drive\Folder\Workbook
When that person clicks a button some cells are filled and that specific
workbook needs to be updated and saved.
This gives a problem, as the attached workbook -with the same name- is
stored in a temporary folder when you open it.
Clciking the button saves that workbook; The workbook in the destination
folder is not updated and saved.
No, I can't open two workbooks with the same name, so how do I manage to
update and save the workbook which is not the attached one.
And if possible, how can I avoid the File already exist, do you want to save
yes/no message.
It always has to be saved as Drive\Folder\Workbook
Hope to have been clear;
Thanks in advance;
--
Mark Rosenkrantz
--
Spreadsheet Solutions
Witkopeend 24
1423 SN, Uithoorn
Netherlands
--
W: www.rosenkrantz.nl
E:
--