The first few sections will probably be stuff you already know. There are
some VBA sections that will give you an intro into the objects, properties
and methods that you'll need.
MVP - Excel
Excel Blog - Daily Dose of Excel
"Chris Strug" wrote in message
> I'm looking at using Excel to produce analysis from an ODBC link to a
> party application through Microsoft Query. To make it as simple to use as
> possible I'd like to use VBA as much as possible.
> While I have a good knowledge of Excel, VBA and ADO/DAO, I'm completely
> unfamiliar with using Excel to obtain data through an ODBC link.
> Simply, can anyone point me in the right direction for any web resources /
> books / articles etc that would act as a introduction.
> I can already use MS query to link to the app and retrieve data, however
> there are things like programmatically defining query parameters and so on
> that I would like to be able to do.
> Just for some background, I'm going to be looking at reporting from a 3rd
> party application (a warehouse management system named ATMS). This app.
> have an ODBC link set up. However as there will often be more than 65000
> rows of data I'm going to have to filter it before I fetch it.
> I realise that this is possible with Access (and indeed would probably be
> easier in some important aspects), however because any data fetched *must*
> be read only and because I'm probably going to want to do some quite
> advanced analysis I have decided on using Excel.
> Any and all advice is gratefully received.
> Kind thanks