View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Update workbook which is an attachment.

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