Thread: 2 Questions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 35
Default 2 Questions

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.