I have a macro, "hideone", in excel 2010 that is calling another macro in a word 2010 template document, "wordhideone". My problem is I want to save the changes that "wordhideone" is doing without having a save as box come up. Kinda like just hitting the save icon. Please let me know if you need additional information.
Dim wdApp As Object, newDoc As Object
Dim strFile As String
Dim myDoc As String
myDoc = "Risk Audit Report Template"
strFile = ThisWorkbook.Path & "\" & myDoc & ".docm"
'~~> Establish an Word application object
On Error Resume Next
Set wdApp = GetObject(, "Word.Application")
If Err.Number <> 0 Then
Set wdApp = CreateObject("Word.Application")
On Error GoTo 0
wdApp.Visible = False
Set newDoc = wdApp.Documents.Add(strFile)
' hideone Macro
ActiveDocument.Bookmarks("one").Range.Font.Hidden = True
ActiveDocument.Bookmarks("one_01").Range.Font.Hidden = True
Thank you for your help and I hope you are having a good day.