Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How do I use as Save As to take the name from a text and change the file path? How do I use as Save As to take the name from a text and change the file path?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2018, 04:23 AM
macropod's Avatar
macropod macropod is offline How do I use as Save As to take the name from a text and change the file path? 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
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
Quote:
Originally Posted by rosscortb View Post
the only thing I have done different is change the strPath to be saved in the 2018 folder instead of the 2017 one
You've actually changed more than that - you've changed what you're supplying for the filename, too. You previously had:
fileName = txtEmployeeName.Value & "Contract"
You now have:
fileName = txtLastName.Value & "," & txtFirstName.Value & " - Contract"


Not that that has anything to do with the error. What is causing the error is that you have also deleted the terminating '\' from the filepath, which should end with:
2018 Offer of Employment Sent\"
not just:
2018 Offer of Employment Sent"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-08-2018, 04:30 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
I have changed a little bit more, you're right but with the little I know I knew that wasn't the issue.

Thanks for your help. Worked a treat.

Ross
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 07:49 AM.

Contact Us - Privacy Statement - Top

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