import and export vba
 

dear all,
to comfirm if it is correct.
1)to export microsoft excel objects (sheets/thisworkbook) from 1
workbook to another workbook, i need to export to cls and in the
destination file do the import of the .cls file. in the destination
when import new folder class modules will be created. open the .cls
and copy the script to sheets or thisworkbook.

2)for modules, export as .bas and import to the destination workbook.

hope to get the advice.
thanks

import and export vba
 

What you say is correct, but if you export

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tango" wrote in message
om...
dear all,
to comfirm if it is correct.
1)to export microsoft excel objects (sheets/thisworkbook) from 1
workbook to another workbook, i need to export to cls and in the
destination file do the import of the .cls file. in the destination
when import new folder class modules will be created. open the .cls
and copy the script to sheets or thisworkbook.

2)for modules, export as .bas and import to the destination workbook.

hope to get the advice.
thanks

import and export vba
 

Try again.

What you say is mainly correct, but if you export it will automatically
create the correct type, and you don't need to copy anything, import will do
it all. When you import, you must ensure that the class file doesn't already
exist.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tango" wrote in message
om...
dear all,
to comfirm if it is correct.
1)to export microsoft excel objects (sheets/thisworkbook) from 1
workbook to another workbook, i need to export to cls and in the
destination file do the import of the .cls file. in the destination
when import new folder class modules will be created. open the .cls
and copy the script to sheets or thisworkbook.

2)for modules, export as .bas and import to the destination workbook.

hope to get the advice.
thanks