Saving as a macro enabled workbook using VBA code, So when you try to save it, Excel prompts you with two choices: Workbook contains macros or VBA code. Below is the code in module: Sub save_file() Dim tDate As String Dim FileSaveName As String Dim fPath As String tDate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd ![]() But it is being saved as a macro free workbook. I am using the following code to save a workbook as a macro enable workbook on the selected path as today's date. How to force users to save as a macro enabled workbook?, right ho, may be incredibly straightforward this (I hope it is) I'm using excel 2007 - i've created a macro enabled template file, and I'm wanting to. Vba code to save excel file as macro enabled
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |