external data
 

i'm looking to get external data - from ms access - into excel the way that
the 'get external data' option works, but i'm looking to do it through vba.
any suggestions?

external data
 

Lou

http://www.dicks-clicks.com/excel/Ex....htm#CreateVBA

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

lou sanderson wrote:
i'm looking to get external data - from ms access - into excel the
way that the 'get external data' option works, but i'm looking to do
it through vba. any suggestions?

external data
 

Just turn on the macro recorder and do it manually. then turn off the
recorder and look at the recorded code. This should accelerate your
development.

--
Regards,
Tom Ogilvy


"lou sanderson" wrote in message
...
i'm looking to get external data - from ms access - into excel the way
that
the 'get external data' option works, but i'm looking to do it through
vba.
any suggestions?

external data
 

"Tom Ogilvy" wrote in message
...
Just turn on the macro recorder and do it manually. then turn off the
recorder and look at the recorded code. This should accelerate your
development.


Nice to know the hack way I employ of gettting code is recommended my the
pros :)

"lou sanderson" wrote in message
...
i'm looking to get external data - from ms access - into excel the way
that
the 'get external data' option works, but i'm looking to do it through
vba.
any suggestions?