need help in excel sheet and visual basic ?

Question

I am working on project work in which database will be prepared on excel sheet and user interface on Visual Basic

so can u provide how to interconnect them?
or can we use microsoft Access as database

Answer 1

Your question is very vague so it will be hard to explain how to do it.



However, heres the first steps.



Go into excel. Press Alt + F11.

Then go to Insert > User Interface.



You can make buttons, checkboxes, textboxes and interact with excel using these forms.



This site can help you from there:

http://www.excel-vba-easy.com/vba-userform-excel-vba.html

Answer 2

See example below.



Dim objECT

set objECT=Server.CreateObject("ADODB.Connection")



objECT.ConnectionString="DRIVER={Microsoft Excel Driver (*.xls)}"



objECT.Open



BUT note.

first 8 records have to be of correct type.

Only serial read and no random access is possible.



OK

Answer 3

Not sure about using Excel and VB but I know you can use Access:

http://en.kioskea.net/faq/4768-coding-to-link-visual-basic-to-ms-access



Will teach you to use access and vb