Newbie Help

S

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!
 
T

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.
 
Top