Embeding Excel Workbook in Solution

[vighnarajhebbar]

Hi...

Does anyone Know how to embed the complete excel workbook inside the VB.NET solution and keep track the data entered inside the excel sheet. i had used OWC spreadsheet component which lacks many excel functionality. so does anyone help me on this?

 

[reasra]

maybe...

I don't know if this answers the question you asked, but you could open an Excel workbook which contains the changes that you want to know about. Then just save the workbook in the application's directory, like so:

Dim wb as Excel.Workbook
'write some information to wb.range("A1")
wb.Save(Application.StartupPath & "\editted_info.xls")

'open the file next time you start the program, if it exists
If file.exists(Application.StartupPath & "\editted_info.xls") then wb.open(... \editted_info.xls)

I don't have a compiler in front of me, so that may have been sloppy. I don't know if that helps, because I don't think I entirely understand the question.