|
Subject:
|
Excel automation from aspx page
|
|
Posted By:
|
babakwx
|
Post Date:
|
4/4/2006 10:11:31 PM
|
Hi,
I'm stuck to automate some functionality of Excel form my ASPx page.
I can launch an instance of Excel and also inserting data to a cell. However, I couldn't move a sheet.
I found this example in VBA document:
" Sheets(Array("Sheet4", "Sheet5")).Move before:=Sheets(1) "
But My problem is that how to change it to a Visual Basic statement in my aspx page ?
|
|
Reply By:
|
Greg Griffiths
|
Reply Date:
|
4/5/2006 3:17:52 PM
|
check out http://www.greggriffiths.org/webdev/both/excel/ which covers automation of this type.
|
|
Reply By:
|
babakwx
|
Reply Date:
|
4/6/2006 1:03:43 AM
|
Thanks Greg
That was quite useful. However, how can I convert VBA statements like those we see in Macro editor of Excel, to VB statements ?
|
