Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2016, 03:17 PM
dwirony dwirony is offline Changing file directory from a temp folder Windows 7 64bit Changing file directory from a temp folder Office 2003
Advanced Beginner
Changing file directory from a temp folder
 
Join Date: Oct 2016
Posts: 49
dwirony will become famous soon enough
Default

Quote:
Originally Posted by Guessed View Post
That requires a bit more effort. This takes the current filename before the first period (assuming the first period is at the file extension), and appends the new file extension
Sub Savetolocation()


Dim sLocation As String, sFile as String
sFile = Split(ActiveDocument.Name,".")(0) & ".docx"
sLocation = "C:\Users\dwirony\My Documents\Overflow Folder\" & sFile
ActiveDocument.SaveAs2 FileName:=sLocation, FileFormat:=wdFormatXMLDocument, CompatibilityMode:=14
End Sub
Luckily for me the first period is at the file extension. Genius solution, thanks for the help Andrew.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing file directory from a temp folder Word 2010 Macro to rename Folder in Directory staicumihai Word VBA 2 10-28-2016 03:01 AM
Changing file directory from a temp folder vba code for folder name, subfolder directory, file name & revision times klpw Excel Programming 2 12-24-2015 12:31 AM
Changing file directory from a temp folder Command button - save in temp folder and send email with attachment bigbird69 Word VBA 13 11-18-2012 10:06 PM
outlook 2003 always not remove temp copy of opened attachments in temporary folder c.itech Outlook 0 06-20-2011 10:34 PM
Error 451 - Couldīt Open Temp file greenberet Outlook 1 09-06-2010 05:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.


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