hi
how to create and open an excel file in vb.net when the button clicks..

Recommended Answers

hi
how to create and open an excel file in vb.net when the button clicks..

check here :

Jump to Post

All 2 Replies

Okay.. If you want to open it EXTERNALLY you can just use the System.Diagnostics.Process.Start("excel.exe") .. If not you need to make a container for the excel to open to.. To create a blank excel file and open it I usually start off with an invisible richtextbox.. Then i use the Richtextbox1.savefile("C:\Test1.xls") .. Then I do
System.Diagnostics.Process.Start("C:\Test1.xls") .. Works for me but youll have some text from the Rtf format in the first two cells..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.