Thread: [Solved] How do I use as Save As to take the name from a text and change the file path?
View Single Post
 
Old 05-08-2017, 06:25 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Simply add the path to the .Name parameter:
Code:
Dim fileName As String
Const strPath as String = "H:\HR\Reward & Shared Services\Shared Services Only\1 ~ Starters\5 ~ Offers Sent\2017 Offer of Employment Sent\"
fileName = txtEmployeeName.Value & "Contract"
With Dialogs(wdDialogFileSaveAs)
  .Name = strPath & fileName
  .Show
End With
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote