Thanks, I figured it out the way I wanted:
Dim cpyName As String
Dim newName As String
cpyName = ActiveWorkbook.Worksheets("Main").Range("G1")
newName = "C:\Temp\" & cpyName & ".xls"
ActiveWorkbook.SaveCopyAs (newName)
--
In Excel 2003 is it possible to save a copy
of the workbook to a specific file location,
allow the user to enter the file name by a
prompt but keep the original file open?
The copy is saved and closed in the
designated file location.
--
I have a worksheet where users log daily
activities. There are three columns where
they need to respond either "Yes" or "No"
to these activities based on a specific question.
For ease of entry I have made a data validation
from a list with either Yes or No as the options for
each cell in the col
I will use conditional formatting in the 2nd and 3rd columns instead.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add
