opening and updating a second workbook

[LordCo]

Hi,

I have a workbook that creates estimates and workorders. One thing that I'd like to do (I don't need to do this, I'd just like to) is to have a second workbook open after a specific event, copy select data to that workbook, save and then close.

Does anybody have any suggestions on how I would do this?

Thank you,

Jim Cook

[Ivan F Moala]

On 2002-04-27 12:36, LordCo wrote:
Hi,

I have a workbook that creates estimates and workorders. One thing that I'd like to do (I don't need to do this, I'd just like to) is to have a second workbook open after a specific event, copy select data to that workbook, save and then close.

Does anybody have any suggestions on how I would do this?

Thank you,

Jim Cook

Jim
Have a look at the Event codes for Workbooks
In the VBA Editor press F1 and type in;
[Using Events with Microsoft Excel Objects]

This should get you started. For further
help in coding post to this board.