read an excel file

Check this out. this project reads an excel file and displays the contents of the worksheets in listview. worksheets are displayed as tables.

(you need to have lvbuttons installed in your system. if you dont have it. just unzip this file and copy lvbuttons and paste it in your root system directory usually system32 and register it. i hope i can be a help for others as it is for me)

now you dont need that kind of button anymore, i ediited this file and changed the button from lv to the normal button.

Please read this guideline regarding CodeBank attachments.

Where did you get that OCX? Do you have the source code for it? If so, include that, not the compiled file.

Thanks.

sorry but the ocx is from la volpe. its a third party ocx actually. i thought its ok coz lvbuttons can be downloaded for free from the internet. its nothing but some kind of enhanced button in vb which is capable if displaying xp style without manifest, java style, mac style and five more styles available.

cannot find object or library? i got error on the line "Dim tbl As ADOX.Table". do i need a reference or anything do allow this? thanks :thumb:

you need to have a reference to Microsoft ADO Ext. 2.7 for DDL And Security or msadox.dll

could u post a link of where can i download freely that DLL file? thanks!

(i've tried to download some but the links says "High Security Alert" and i can't download it) :(

Thanks

Search microsoft site for MDAC. ADO is included in it.