2 Questions

M

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.
 
F

Frank Kabel

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

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.
 
Top