I am trying to force the user to always save the workbook as a newly named
file into a specific folder. My problem is that the Save As dialog comes up
twice???? Here's my code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Check for Save versus SaveAs
If SaveAsUI Then
SaveAsFile
CreateShortCut
End If
End Sub
Sub SaveAsFile()
Dim strDocName As String
Const FilePath As String = "H:\ProdDev\Client\"
ChDrive FilePath
ChDir FilePath
strDocName = Application.GetSaveAsFilename
If strDocName <> "False" Then
ActiveWorkbook.SaveAs Filename:=strDocName
End If
End Sub
Tom Ogilvy - 23 Feb 2007 19:43 GMT
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Check for Save versus SaveAs
If SaveAsUI Then
SaveAsFile
CreateShortCut
Cancel = True
End If
End Sub

Signature
Regards,
Tom Ogilvy
> I am trying to force the user to always save the workbook as a newly named
> file into a specific folder. My problem is that the Save As dialog comes up
[quoted text clipped - 19 lines]
> End If
> End Sub
chemicals - 23 Feb 2007 20:02 GMT
MUCH OBLIGED Tom!
> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
> 'Check for Save versus SaveAs
[quoted text clipped - 28 lines]
> > End If
> > End Sub
Joel - 23 Feb 2007 20:10 GMT
I think you need to change this line from <> to =
If strDocName = "False" Then
> I am trying to force the user to always save the workbook as a newly named
> file into a specific folder. My problem is that the Save As dialog comes up
[quoted text clipped - 19 lines]
> End If
> End Sub