I have some daily reports templates set up to open and save with a date
related name in a preset folder.
I have them working so that if the file already exists with the date in name
it will add (x). Example C:\MyReports\DailyReport 12-25-09(1).xls for the
second time template is used.
I would like to use a msgbox to give the user a choice of reopening the
first copy rather than making a second.
I have it set up to work except my statements for opening the first file
does not open it.

sample of my code:
If Ans = vbYes Then
Me.Close SaveChanges:=False
Dim wb1 As Workbook
wb1 = Workbooks.Open(myPath & myFile & myExt)
wb1.Activate
wb1.visble = True
Can anyone tell me what I am doing wrong here.
Thanks
SC

--
SC from Lubbock, Texas