Subform - Select All

[Badswell]

Probably an easy one...

I have a subform that displays the results of a query. I'm looking for the VB code that will select all the values displayed in these results & copy to the clipboard. From here, going to have it auto-open a set Excel file to export that data produced by the query.

 

[KeithG]

So basically you want to export the query to excel? Correct?

 

[Badswell]

Exactly. I already know the specific file & range to drop it in, just need a way to grab the query results.