W
winnie123
Hi,
I hope I can explain this well enough for you guys to help me out.
I have set up a wb for price changes which is to be emailed to a director to
approve or reject. Iam using Excel2003 and Outlook.
I am still testing this so it is not a Live wb yet. But the sales managers
will all need access.
The wb consists of
wsheet Input
wsheet LookupList
wsheet PriceRequest
wsheet Approved
wsheet Rejected
The input sheet is like a form but I am using data validation list from the
LookupList sheet. Once all fields have been entered the user clicks a command
button and the data on ws Input is copied to ws PriceRequest, the wb gets
emailed to the Director for approval. The data is then cleared from the Input
ws. That bit works.
The Director will open the file within the emailed message and
approve/reject the request by clicking on the appropirate check box Yes or No
on the Input ws, depending on which option has been selected this will copy
the data to either the Approved ws or the Rejected ws, email the wb to the
person who sent the request.The data is then cleared from the Input ws. This
bit works
The problem I have is how do I update the original wb.
I have tried to save file by clicking the x on Excel so that it prompts to
save but when I say yes, it is not saving to the original path. Infact I do
no where it is saving to, probably some temp folder.
Any ideas how I get get around this?
The other problem I think I may have is if more than one request gets
emailed to the director before he has had time to approve or reject, on save
(if I get around this) it may overwrite new data.
I hope this make sense and apologies for this long winded question.
Thanks
Winnie
I hope I can explain this well enough for you guys to help me out.
I have set up a wb for price changes which is to be emailed to a director to
approve or reject. Iam using Excel2003 and Outlook.
I am still testing this so it is not a Live wb yet. But the sales managers
will all need access.
The wb consists of
wsheet Input
wsheet LookupList
wsheet PriceRequest
wsheet Approved
wsheet Rejected
The input sheet is like a form but I am using data validation list from the
LookupList sheet. Once all fields have been entered the user clicks a command
button and the data on ws Input is copied to ws PriceRequest, the wb gets
emailed to the Director for approval. The data is then cleared from the Input
ws. That bit works.
The Director will open the file within the emailed message and
approve/reject the request by clicking on the appropirate check box Yes or No
on the Input ws, depending on which option has been selected this will copy
the data to either the Approved ws or the Rejected ws, email the wb to the
person who sent the request.The data is then cleared from the Input ws. This
bit works
The problem I have is how do I update the original wb.
I have tried to save file by clicking the x on Excel so that it prompts to
save but when I say yes, it is not saving to the original path. Infact I do
no where it is saving to, probably some temp folder.
Any ideas how I get get around this?
The other problem I think I may have is if more than one request gets
emailed to the director before he has had time to approve or reject, on save
(if I get around this) it may overwrite new data.
I hope this make sense and apologies for this long winded question.
Thanks
Winnie