aspx_professional thread: Using VSA within an .aspx page....
Hello, all,
I would like to know how to use VSA within an .aspx page to create a
kind of embedded macro which gets evaluated at run-time. What I have done
is to use the server-side Table, TableRow and TableCell objects to
construct a web-based pseudo-spreadsheet with certain fixed cells, whose
calculations are performed by .aspx page code. However, I also want to
give users the ability to dynamically add a row to the table *and* provide
a simple algebraic formula on the fly, using cell references, for each
cell. I recall reading somewhere that VSA (the successor to VBA) fully
integrates with .NET, and can be used for this purpose...don't know of
anyone who has done this, however.
For example, I would like my users to be able to add, say, a 26th row,
row 'Z', with four cells, 1,2,3, and 4. The formulas might look something
like Z1 = Z1 + Y1, Z2 = Z2 + Y2, etc. VSA code would then operate on
these expressions accordingly.
Anyone have any experiences with this that they would care to share?
Thx,
Regards,
Matt Seltzer
Technical Analyst
EMI Recorded Music, NA