Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-25-2023, 08:11 AM
mathew_grainger22 mathew_grainger22 is offline Open template & Save as - Macro Windows 10 Open template & Save as - Macro Office 2021
Novice
Open template & Save as - Macro
 
Join Date: Jul 2023
Posts: 1
mathew_grainger22 is on a distinguished road
Post Open template & Save as - Macro

Hi all,



I'm struggling to create a Macro for Word that can open a template from my file explorer then prompt a save as box to save in a new location.
Reply With Quote
  #2  
Old 07-25-2023, 08:55 AM
Italophile Italophile is offline Open template & Save as - Macro Windows 11 Open template & Save as - Macro Office 2021
Expert
 
Join Date: Mar 2022
Posts: 338
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

If your “template” is genuinely a template, i.e. has a .dotx or .dotm file extension, then you don’t open it, you create a new document using Documents.Add method (Word) | Microsoft Learn, and save it using Document.SaveAs2 method (Word) | Microsoft Learn
Reply With Quote
  #3  
Old 07-25-2023, 09:06 AM
gmayor's Avatar
gmayor gmayor is offline Open template & Save as - Macro Windows 10 Open template & Save as - Macro Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It doesn't really matter whether the document is an actual template or a document, you still can, and should, create a new document from it, using the method described in the previous post.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
macro, save as, template



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro save a form generated from a template elaineAda Word VBA 2 05-05-2022 05:29 PM
If you open a custom template that was created with 2010, using 2016 and then save it... dianahbr Word 4 02-27-2018 01:44 PM
Open template & Save as - Macro Adding a save as macro button to a template nparsons75 Word 6 01-08-2016 07:47 AM
Word ask to save template whenever i save a derived document jorbjo Word 3 10-04-2012 10:52 AM
Macro to open template not working Brandi Mail Merge 2 06-24-2010 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft