Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-17-2013, 02:58 PM
fumei fumei is offline Why no 'SaveCopyAs' method? Windows 7 64bit Why no 'SaveCopyAs' method? Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

The main problem issue is the fact you need to have DIFFERENT VBA modules in three different files. I am not sure why that is important, but if it really is, perhaps do this.

1 Verify current document
4 Save current document as original filename
2 Run VBA to remove modules & Saveas "FileName_Finalized_1"
3 Run VBA to remove modules & Saveas "FileName_Finalized_2"

This assumes the removal process is accumulative. If not then you may need to close and reopen original file. And of course you will need to come up with the VBA to edit the code modules.

Last edited by fumei; 10-17-2013 at 09:32 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Why no 'SaveCopyAs' method? Creating a sorting method. Balliol Word 2 07-25-2013 06:18 AM
Why no 'SaveCopyAs' method? SaveCopyAs tinfanide Excel Programming 2 11-02-2011 06:02 AM
Why no 'SaveCopyAs' method? Shared Contacts & Calendars. Best method crobertson Outlook 1 05-08-2009 05:47 AM
Why no 'SaveCopyAs' method? Method to update saves to all copies aultduell Word 1 11-24-2006 12:50 PM
Retrict Method Condition markp Outlook 0 12-22-2005 05:38 PM

Other Forums: Access Forums

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