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:
--