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!


---
Message posted from http://www.ExcelForum.com/

HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy

"szadkowski " wrote in message
...
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!


---
Message posted from http://www.ExcelForum.com/

Thank you! That helps.. and if anyone else knows of any great books o
tutorials just email me at

Thanks!

Chris Szadkowski

Tom Ogilvy wrote:
*HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default...b;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 unde
the
Edit menu.

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

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

--
Regards,
Tom Ogilvy

"szadkowski " wrote i
message
...
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 a
app
in excel to be able to search records in an excel document as wel
as
different means to export the results. I have an exesiv
programming
background, i just need to know where to start with it.

Thank you!


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com

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
"szadkowski " wrote in message
...
Thank you! That helps.. and if anyone else knows of any great books or
tutorials just email me at

Thanks!

Chris Szadkowski

Tom Ogilvy wrote:
*HOWTO: Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy

"szadkowski " wrote in
message
...
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!


---
Message posted from http://www.ExcelForum.com/
*


---
Message posted from http://www.ExcelForum.com/