Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-17-2023, 11:45 AM
David Peck David Peck is offline instance a new dotm file from a Word dotm file and save with new file name Windows 10 instance a new dotm file from a Word dotm file and save with new file name Office 2021
Novice
instance a new dotm file from a Word dotm file and save with new file name
 
Join Date: Jun 2023
Posts: 3
David Peck is on a distinguished road
Default instance a new dotm file from a Word dotm file and save with new file name

I'm using this code to test if a file is a new instance just created from a dotm file and if so, saving it to a file with a docm extension.



When I attempt to reopen the file after closing it, Word reports the file as being corrupt.

The second parameter of ActiveDocument.SaveAs is WdSaveFormat - I'm looking at the MS page for WdSaveFormat
SaveAs Method | Microsoft Learn

I do not see a symbolic constant for the docm file type. if I try to set WdSaveFormat to the default (wdFormatDocument) I get a different error saying the file extension does not match.

Question: Seeking a method to instance a new file from a macro enabled template (dotm) and save it as a macro enabled file (docm)



If IsNull(ActiveDocument.Path) Or ActiveDocument.Path = "" Then
'GET WORKING FOLDER FROM USER
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)
With fldr

.Title = "Select a Folder for this Word File and all of the associated Images to be stored"
.AllowMultiSelect = False
If .Show <> -1 Then
'NOTHING SELECTED NEED MSG
MsgBox "You must specify a Folder for this Word file to be stored", vbOKOnly + vbExclamation, "FOLDER NOT SELECTED"
Exit Sub
Else
'PATH IS SELECTED
selectedTargetPath = .SelectedItems(1)
End If
End With
Set fldr = Nothing

saveDate = Now

'SAVE FILE TO FIX ACTIVE DOCUMENT PATH SO FILES CAN BE COPIED TO THE CORRECT LOCATION
WordDocFilePathAndName = selectedTargetPath & "" & _
"8_5x11 Photos " & Year(saveDate) & "." & Month(saveDate) & "." & Day(saveDate) & _
" " & Hour(saveDate) & "." & Minute(saveDate) & "." & Second(saveDate) & ".docm"
ActiveDocument.SaveAs WordDocFilePathAndName
End If
Reply With Quote
 

Tags
macro enabled file, macro enabled template



Similar Threads
Thread Thread Starter Forum Replies Last Post
I have a dotm file and can't add bookmarks because it reverts to normal doc Dpucher Word VBA 1 07-21-2019 08:15 PM
instance a new dotm file from a Word dotm file and save with new file name View/edit macro in DOTM file. eduzs Word VBA 5 04-14-2018 04:33 AM
Which .dotm file used for replies in Outlook 2013? kungfauxn00b Outlook 0 04-17-2014 01:41 AM
instance a new dotm file from a Word dotm file and save with new file name Editing .dotm/.dotx/dot file martinlest Word 9 10-09-2013 01:57 PM
instance a new dotm file from a Word dotm file and save with new file name Macros being stripped from dotm file Brian Muth Word 1 10-09-2012 10:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft