Hi,
I have an excel file,having lot or micros, connecting to database, doing some complex calculation..inshot that excel file is itself an application.
Now I want to open that excel in VB.net form, on button click. I prefer to open that excel in vb.net form itself having all the excel tool bar etc, If that is not possible then opening in separate window using excel will also solve my purpose (coz when we open in excel it self we will get all the toolbar option etc automatically)
Please Help
Anurag

http://support.microsoft.com/kb/301982
http://support.microsoft.com/kb/302094

There is a couple of links which should get you started. If I recall, you can manipulate spreadsheets fairly easily within vb.net. The easiest task to accomplish what you want would be to open the file directly on a button click.

Furthermore I found this code snippet which might help...

Dim excel As Microsoft.Office.Interop.Excel.Application

Dim wb As Microsoft.Office.Interop.Excel.Workbook

Try

excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open("c:\\test.xls")
excel.Visible = True
wb.Activate()

Catch ex As COMException
MessageBox.Show("Error accessing Excel: " + ex.ToString())

Catch ex As Exception
MessageBox.Show("Error: " + ex.ToString())

End Try

Hi,
Thanks for reply. I have already tried this method, its working fine for a simple excel file, but when i am trying to open my excel file having micro and VBA code its not working.
Is there any alternative.
Thanks
Anurag

What specific error message are you getting?

I am not getting any error but it is opening a blank excel sheet.

Can you enumerate ( foreach ) the sheets in the workbook?