Adding VBA code to Excel sheet

[Ad Brandt]

I've made a program that reads an XML data file, and generates an Excel
spreadsheet with charts of the data. I'd like to be able to manipulate
the scaling of those graphs in Excel. That can be done easily, but
requires some VBA, to define a Worksheet_Change(ByVal Target As Range)
function. My question is: is there a way to write VBA code into an Excel
sheet via OLE, just as you can write data and chart definitions?

 

[Jeff Hopper]

You might try using a template: put the code you need in a workbook, save it
as a template, and then base any new workbook files you create
programmatically on that template. The new workbooks will include the code
from your template.

 

[Ad Brandt]

Thanks, that is a possibility. However, there is also a programmatic
interface, as someone pointed out to me. See
http://www.cpearson.com/excel/vbe.htm