How to create a macro in an Excel workbook?

[IdoZe]

Hi all,

I'm processing (reading & writing) an Excel file using both the "CVI Excel Report" and the Microsoft Excel 9.0 ActiveX package.

I want to create a macro, which will be activated on a click to a Chart object which already exist in the sheet. The implementation should use any of the 2 packages above.

Any idea how it can be done?

thanks,

Ido

[AEDavid]

Hi IdoZe,

The best way to get started with this would be the example in the Example Finder under Communicating with External Applications >> ActiveX >> Excel >> excel2000dem.prj.