excel-vb interface

  • Thread starter Thread starter markhernz
  • Start date Start date
M

markhernz

hi! just want help on how i can integrate vb with excel, i want to use
vb to create a macro that when clicked, a sheet of some sort pops up,
the user inputs data into this screen, then the data is then
transferred. and accumulated on excel... excel will be my database
dump....

i would also like to learn how to use the "tabs" activeX control in
vb... how can i put values into them?
 
Hi,

A simple solution would be to use the Data, Form method.

- set up your database table in which a single row at the
top designates the names of the fields.
- select any cell directly below that row
- choose (from the menu) Data, Form.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Hi,



In your vb editor, first you make a reference to the excel library and then
you use the function CreateObject().
 
Back
Top