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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying Class/modules in Newly Created files 1

Status
Not open for further replies.

sabascal

IS-IT--Management
Aug 20, 2002
85
0
0
GB
Hi All,

- I have a model: F1 in which a macro generates a new excel file:F2, with some info.
- I need this file to contain a module, so that user can perform certain task.

How do I copy class/modules from F1 to F2 ?

Thanks in advance.
Seb


 
Instead of having the macro in F1 create a new file, use an empty (probably read-only) file with the macros in it, put in the desired data, and save it with a diferent name.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top