| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
| Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
| updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
| External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
| Saving worksheet as CSV after pulling data from an external data source | Excel Programming | |||
Linear Mode
