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.

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

-----Original Message-----
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.
.

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.

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

-----Original Message-----
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.
.

.

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

wrote:

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.

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

-----Original Message-----
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.
.

.


--

Dave Peterson