Excel Ole automation with VB.NET 
Author Message
 Excel Ole automation with VB.NET

Hi,

je need to change tevalue of a cell of a worksheet with VB.NET

my code (which don't work) :

Dim xapp As New Excel.ApplicationClass()

Dim xdoc As Excel.Workbook

xdoc = xapp.Workbooks.Open("c:\book1.xls")

xapp.Workbooks(1).Worksheets.Select("sheet1")

xapp.Range("A2").Select()

xapp.ActiveCell.FormulaR1C1 = "75"

xapp.Workbooks(1).Save()

xapp.Quit()

Error :
Exception from HRESULT: 0x800A03EC.

Thanks by advance,

Didier



Sun, 26 Dec 2004 06:29:18 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Help on OLE Automation (VB 4.0 to Excel 97)

2. VB OLE Automation to Excel

3. VB, OLE Automation and Excel

4. Deactivating Excel's ScreenUpdating in VB OLE automation routine

5. Accessing empty Excel cells via OLE automation from VB 3.0

6. Need help doing a Subtotal through Excel automation in vb.net

7. Excel Addin using vb.net Automation

8. VBA Excel Automation in VB.Net

9. Excel Automation with VB.Net

10. OLE Excel Upgrade From VB 6 To .NET

11. Excel Charts using OLE Automation

12. OLE Automation of Excel from Access 7.0

 

 
Powered by phpBB® Forum Software