Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

commandbars into saved as file

Status
Not open for further replies.

ratman

Technical User
Jun 26, 2000
143
US
I have a macro that copies an excel file(lets call it file#1),&nbsp;&nbsp;&nbsp;closes it, saves it as another file name(lets call it file#2 which now contains the main macro), executes several commands,&nbsp;&nbsp;assigns 3 other macro's to commandbars, then before it closes it is saved to another filename(lets call it file#3).&nbsp;&nbsp;<br><br>My problem is that the commandbars are installed to file#2(which happens to be the file containing the main macro) and not file#3 where I want them.&nbsp;&nbsp;<br><br>How do I get the commandbars into the final file (file#3).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top