Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-08-2017, 05:59 AM
rosscortb rosscortb is offline How do I use as Save As to take the name from a text and change the file path? Windows XP How do I use as Save As to take the name from a text and change the file path? Office 2010 32bit
Novice
How do I use as Save As to take the name from a text and change the file path?
 
Join Date: May 2014
Posts: 17
rosscortb is on a distinguished road
Default How do I use as Save As to take the name from a text and change the file path?

Hello



I have some code that when run the save as box shows and the file name which is the employee name entered in the text field box by the user. For example. Joe Bloggs contract.docm

This bit is fine. But how do I get it so it shows the name but with a different folder location.
So at the moment the word doc is opened from here -H:\HR\Reward & Shared Services\Shared Services Only\1 ~ Starters\3 ~ Contract Templates\DB Templates

but when it's completed I want it to be saved in this location- H:\HR\Reward & Shared Services\Shared Services Only\1 ~ Starters\5 ~ Offers Sent\2017 Offer of Employment Sent

But with the employees name.


Code:
  Dim fileName As String
    fileName = txtEmployeeName.Value & "Contract"
    With Dialogs(wdDialogFileSaveAs)
      .name = fileName
      .Show
     End With
End Sub
Thanks

Ross
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use as Save As to take the name from a text and change the file path? 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
How do I use as Save As to take the name from a text and change the file path? Change old path to new path (batch) NobodysPerfect Word VBA 2 08-14-2014 10:09 PM
How do I use as Save As to take the name from a text and change the file path? How to change save location and file to print name change? albertc Excel Programming 1 05-13-2012 07:05 PM
How do I use as Save As to take the name from a text and change the file path? 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 08:24 PM.


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