Skip to Content
0
Former Member
Dec 03, 2009 at 01:06 PM

Excel VB to send some sheets

30 Views

Hi all,

I have an input schedule with 2 sheets, one of them hidden. The visible sheet sends data to one application (App1) and the hidden sheet sends data to a different application (App2). Both applications have default calculations, and the calculations of App1 depend on the values stored in App2.

Therfore we need to control the order in which the data in both sheets is sent. Using VB we need to send the data of one of the sheets (to App1) and once it has finished, send the data of the other (hidden) sheet (to App2). Thanks to the answers in the thread we can do it, however we lose the confirmation message after the second send (we actually don't even know when it finishes, the state box only shows up for the first data send). When we try different options, all fail because we don't know how to control the order of execution in the VB: we cannot stop until the macro of SEND and REFRESH has finished.

So, does anybody know how to get a confirmation message with the MNU macros or otherwise how to control de order and moment of execution in VB with BPC macros?

Regards,

Rafa