I've got no idea on how to connect exel as Vb please help

Read This Thread:
http://www.daniweb.com/techtalkforums/thread37479.html

Basically, you have to create an object of the excel.application class. This will allow you to manipulate the object as you see fit..... such as setting it's visibility and some other fun gadgets that come with it's methods and properties.

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.