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 export as vba macro

In the VBIDE you can export the code module (FileExport). This can then be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as importing
fails, but you can move the code to a module and use simple single calls to
the macros from the worksheets.

--

HTH

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


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate original
worksheet