Webcomponent-excel question

P

PO

Hi!

I'm using the excel webcomponent (Office 2000) in a webapp.
I have two questions:

1. Is it possible to have more than one sheet in the component. (I've tried
Spreadsheet1.Sheets.Add, which resulted in an error).

2. After the excelreport has been generated the user normally exports the
report to Excel. When the sheet opens in Excel I want a
Workbook_SheetChange - sub to be present. Can I add this sub to the
webcomponent so that it exports to Excel together with the worksheet or is
there an other solution?

TIA
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and excel 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Export Report to Excel not working? 0
Compare two different workbook sheet to show the difference in text 0
two questions on exporting from a form 3
Pivot table in Excel. Exported data from access as excel sheet. 0
Export Report to Excel Worksheet 0
Excel 2010 Windows.Activate name issue 4

Top