• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

File Save a Different File Name with out Changing the Macro File

Richard

New Member
I am using a (2) Two file system

1 file holds the Macros (Hidden Workbook)

1 file holds the Form (Initial File Name as the ActiveWorkbook)

The Form alows the user to enter

the Administrator,

the Account# and then to choose

the Agreement that they want to work on.


When they choose an Agreement, the Form populates data from the Macro file.

(they can keep choosing Agreements and the Form reflects the info.)


The Problem is when the File is Saved as the NEW Agreement Name the macro EXCEL Field changes to that NEW File Name instead of the Initial File Name.


I need to save the NEW Agreement as a seperate file with its Macros and allow the user to continue working with the Initial File to work on other Agreements without opening and closing the Initial and Macro files.
 
Hi, Richard!

Can you please upload a sample file? Tips are in one of the green sticky topics at this forums main page.

Regards!

PS: If VBA project is password protected as I guess, please unlock it or provide proper password.
 
http://hotfile.com/dl/145671340/3f94c2e/MACROS.xlsm.html

http://hotfile.com/dl/145671630/5f27eec/SB25_UPLOAD.xlsm.html


The UPLOAD file also opens the the Macro File (ussing Sharepoint)


The UPOAD is the Active file

The Macro is Hidden


If I can not Save the New file without Renaming the UPLOAD and Changing the MACRO file,

is there a way to have EXCEL to only look at a Active file instead of a Unique file name.
 
Corrected


I was using the Macro file to hold the Source, Criteria and the Filter Range which looked @ the Upload file for Criteria, I move the criteria to the Upload file ( Activeworkbook) whith the VBA in the macro file.


When I file same as a NEW file Name the file still has the Criteria and when reopened will work exactly like the Upload file.


Side Note:

I can use Activeworkbook saveas "New File Name",

but I can not get Activeworkbook SaveCOPYas "New File Name" to work.


Thanks to anybody that might be working on this, but I found a work around.

Except for the SaveCOPYas problem I will concider this problem


Completed
 
Back
Top