rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 574
- Office Version
- 365
- Platform
- Windows
I would like to check to see if the current file format is a macro enabled template file and then initiate a save as command if it is. I am using the code below and I was wondering if this would work, or if there is a different code I should be using.
Code:
If ActiveWorkbook.FileFormat = ".xlst" Then
MsgBox"Current workbook is an Excel template. The workbook will be saved as a macro enabled workbook."
'I have my save command here
Else
Exit sub
End if