Member Avatar for mohankumar554

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

  • 3 Contributors
  • 2 Replies
  • 189 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Pacman21
Member Avatar for Pacman21

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.