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

Recommended Answers

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 meeting, networking, learning, and sharing knowledge.