copy selection of table to excell spreadsheet

[Greycon]

Hello All,

I am just starting to learn VBA for access, after being
comfortable in Excel. Glad to see that Microsoft stuck
with there format of "works on one, but not the other"
style.

First question, is how do I copy a selection of a table.
Via. VBA

ie..

I run a query, and I want to copy a selection, and send it
to Excel. Not the whole table. And I probably don't
need to keep the data. I just want to run some Excel
magic on the info. I do this alot, and will probably
make it into a add-in.

Second. Where can I find some good newbie info on
access SQL. In Excel, If I did not know how to do
something, I could sometimes record a macro and find
what command I needed. No such luck in Access.

Any info would be great.

Greycon

 

[PHV]

In the Excel VBA help file take a look at the CopyFromRecordset method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244