Microsoft Office Forums - View Single Post - [Solved] Macro VBA "Save as" with bookmarks in file name string

Dom37 · 10-26-2011, 03:31 AM

Goodmorning, i need create a macro VBA : Save as
my problem is insert in file name string a bookmark present in my active document. I make so:

Code:

Sub SalvaNonConformita()
ChangeFileOpenDirectory "C:\Documenti\"
myDocname = ActiveDocument.Name
ActiveDocument.Bookmarks("CodAnom").Select
pos = InStr(myDocname, ".")
If pos > 0 Then
  myDocname = Left(myDocname, pos - 1)
  myDocname = "NonConformita_" & MyBookmark & ".doc"
  ActiveDocument.SaveAs FileName:=myDocname, FileFormat:=wdFormatDocument, _
  LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword:="",  _
  ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
  SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:=False
End If
'ActiveDocument.Close
ChangeFileOpenDirectory "C:\Documenti\"
End Sub

where my bookmark is CodAnom

Please help me