View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions Spreadsheet Solutions is offline
external usenet poster
 
Posts: 33
Default Update workbook which is an attachment.

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