View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
konpego konpego is offline
external usenet poster
 
Posts: 7
Default Run macro in another workbook

Hi,

I have two WBs open and are updating/merging data from one to the other. I
want to run a macro in one WB to create data on a specific WS. The results
shall be copied from the WB into the other.
To generate the data there is a pushbutton on one WS (connected to a macro).
The resulting data is gathered on another WS, that is to be copied to the
other WB.

How can I execute a macro in another WB (in VB)?

/konpego