Hi All:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
Can anyone tell me if there is a QUICK way of copying multiple modules from one spreadsheet to another?<o
></o
>
<o
></o
>
I have a spreadsheet called Project and I need to copy a Module and the 2 within it plus a Class Module (whatever that is) and the 12 modules within it. As well I have a User Form and 1 module within it.<o
></o
>
<o
></o
>
Is there a way of copying all of these to a new another spreadsheet that is currently titles NEW <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1:stockticker w:st="on">ADI 1</st1:stockticker>? The file NEW <st1:stockticker w:st="on">ADI 1</st1:stockticker> also has multiple sheets and codes within it so my easiest is to copy all the info from the spreadsheet titled Project to the sheet titled NEW <st1:stockticker w:st="on">ADI 1</st1:stockticker>.<o
></o
>
<o
></o
>
From what I have found so far it seems that I will need to copy (export) these modules one at a time and then import them to the other spreadsheet. Correct?<o
></o
>
<o
></o
>
Also, if that is what I need to do can I do the same with the user form?<o
></o
>
<o
></o
>
I am hoping there might be a VBA to accomplish all of the above because once I have copied the modules and forms to NEW <st1:stockticker w:st="on">ADI</st1:stockticker> 1 I need to do the same for NEW <st1:stockticker w:st="on">ADI</st1:stockticker> 2 thru 15
<o
></o
>
Anyway, I don't want to Export and Import one at a time if I don't have to
THANKS for your assistance,<o
></o
>
Mark
<o
></o
>




<o


Can anyone tell me if there is a QUICK way of copying multiple modules from one spreadsheet to another?<o


<o


I have a spreadsheet called Project and I need to copy a Module and the 2 within it plus a Class Module (whatever that is) and the 12 modules within it. As well I have a User Form and 1 module within it.<o


<o


Is there a way of copying all of these to a new another spreadsheet that is currently titles NEW <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com



<o


From what I have found so far it seems that I will need to copy (export) these modules one at a time and then import them to the other spreadsheet. Correct?<o


<o


Also, if that is what I need to do can I do the same with the user form?<o


<o


I am hoping there might be a VBA to accomplish all of the above because once I have copied the modules and forms to NEW <st1:stockticker w:st="on">ADI</st1:stockticker> 1 I need to do the same for NEW <st1:stockticker w:st="on">ADI</st1:stockticker> 2 thru 15

<o


Anyway, I don't want to Export and Import one at a time if I don't have to

THANKS for your assistance,<o


Mark


