View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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