Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2017, 05:58 AM
dingar dingar is offline VBA runs I then save as to keep master free from editds but does not work Windows 8 VBA runs I then save as to keep master free from editds but does not work Office 2013
Novice
VBA runs I then save as to keep master free from editds but does not work
 
Join Date: Apr 2017
Posts: 2
dingar is on a distinguished road
Default VBA runs I then save as to keep master free from editds but does not work

I have created a document that takes input from the user via a form. Depending on selections by user certain sections of the document are deleted and the section header page as Not Applicable inserted. The problem comes when the document is saved as, the master (original document) also has the edits in place.



Any help much appreciated.

KR

Dingar
Reply With Quote
  #2  
Old 04-27-2017, 06:11 AM
macropod's Avatar
macropod macropod is offline VBA runs I then save as to keep master free from editds but does not work Windows 7 64bit VBA runs I then save as to keep master free from editds but does not work Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

You should be creating a new document via the .Documents.Add method - preferably to open a template (.dotx/m file), not opening (e.g. via the .Documents.Open method ) or modifying an existing document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-27-2017, 06:35 AM
dingar dingar is offline VBA runs I then save as to keep master free from editds but does not work Windows 8 VBA runs I then save as to keep master free from editds but does not work Office 2013
Novice
VBA runs I then save as to keep master free from editds but does not work
 
Join Date: Apr 2017
Posts: 2
dingar is on a distinguished road
Default runs I then save as to keep master free from editds but does not work

Hi Macprod

Many thanks, to get this in my mind correctly are you saying that the code behind the submit button should create a new document and apply the changes to the new document?
Reply With Quote
  #4  
Old 04-27-2017, 03:18 PM
macropod's Avatar
macropod macropod is offline VBA runs I then save as to keep master free from editds but does not work Windows 7 64bit VBA runs I then save as to keep master free from editds but does not work Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Precisely.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Free upgrade to Visio 2013 with Office 365 is not free? JonFleming Visio 3 02-22-2016 05:46 AM
VBA runs I then save as to keep master free from editds but does not work Auto save has done dark - does not work for me bitraker Word 1 12-28-2015 09:40 AM
I know hotmail is free however, it should work right and it isn't. What to do? talosian Outlook 0 04-07-2015 06:23 AM
Powerpoint save as WMV but media doesnt work. hooney PowerPoint 0 02-21-2013 09:45 PM
VBA runs I then save as to keep master free from editds but does not work URGENT: macro icons don't work when 'save as' AndyDDUK PowerPoint 9 11-21-2012 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:25 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