-
1 Attachment(s)
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.
-
Re: read an excel file
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.
-
Re: read an excel file
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.
-
Re: read an excel file
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:
-
Re: read an excel file
you need to have a reference to Microsoft ADO Ext. 2.7 for DDL And Security or msadox.dll
-
Re: read an excel file
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
-
Re: read an excel file
Search microsoft site for MDAC. ADO is included in it.