Newbie Help

[szadkowski]

Hi, I would like to know if anyone could point my in the right
direction: ie (text book, or link to a tutorial) on how to write an app
in excel to be able to search records in an excel document as well as
different means to export the results. I have an exesive programming
background, i just need to know where to start with it.

Thank you!

 

[Tom Ogilvy]

HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default.aspx?scid=kb;en-us;257819

For sample connection strings you can see Able-Computing

http://www.able-consulting.com/tech.htm


Also
Excel also has the autofilter, advanced filter, the find method under the
Edit menu.

any of these could be used to do the searching. getting the results to a
new location can be done with copy and paste.

You can turn on the macro recorder while you perform the action manually to
get sample code. Of course the recorder records your manual actions, like
selecting cells and so forth. This is usually unecessary in your actual
code, but it will give you insights into the objects and properties which
you might use.

 

[szadkowski]

Thank you! That helps.. and if anyone else knows of any great books o
tutorials just email me at (e-mail address removed)

Thanks!

Chris Szadkowski

 

[Hari]

Hi Chris,

As per the Gurus JW's book is the best and yes they say even Bovey/Bullen's
book is Very good. (Sad, these books arent available in Delhi)

http://j-walk.com/ss/books/index.htm

http://j-walk.com/ss/books/other.htm


Regards,
Hari
India