How do I use as Save As to take the name from a text and change the file path?

		Microsoft Office Forums > Microsoft Word > Word VBA
How do I use as Save As to take the name from a text and change the file path?

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-08-2017, 06:25 AM

macropod

Windows 7 64bit How do I use as Save As to take the name from a text and change the file path?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

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]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Turn OFF auto-adding file path as default alternative text for inserted objects	Sergey SPb	Drawing and Graphics	7	04-24-2017 11:25 PM
Word for Mac 2011: Change default open/save file locations?	cglenn	Word	0	06-01-2015 10:34 AM
Change old path to new path (batch)	NobodysPerfect	Word VBA	2	08-14-2014 10:09 PM
How to change save location and file to print name change?	albertc	Excel Programming	1	05-13-2012 07:05 PM
Word Macro: Save file as text with current file name	jabberwocky12	Word VBA	2	10-22-2010 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 AM.