2 Questions

[Michelle]

1. I have the following code that saves a copy of a the
workbook in a directory, what I would like is for it to
prompt me to name the file, I have tried several things
and I can not seem to make it prompt me. Here is what the
code is now.

ActiveWorkbook.SaveCopyAs "H:\Common\Count\Old\Count.xls"

2. I would also like to send an email to one person that
says when the other person is done working in the shared
workbook.

 

[Frank Kabel]

Hi
for the first question have a look at
GetSaveAsFilename
method in the VBA help

 

[Guest]

That works if I want to save it in the current directory
but what I want is to save it on a server under a
different directory.

 

[Dave Peterson]

You can change drives/folders in that getsaveasfilename dialog.

And Ron de Bruin has lots of code examples at:

http://www.rondebruin.nl
specifically:
http://www.rondebruin.nl/sendmail.htm