Export to Excel

[cassey14]

Hi!

Is it possible that the result in the subform will export to excel file??
Please help..

[nico5038]

In multiple ways.
For once off situations I just click in the upper left corner to select all and use Ctrl+C and Ctrl+V to get a copy via the clipboard.

The other solution would involve VBA and can be done by using the transferspreadsheet command when there is no additional filter to be taken in account. When there is you can create a query first and use that for the transferspreadsheet command.

Need more info?

Nic;o)

[cassey14]

In multiple ways.
For once off situations I just click in the upper left corner to select all and use Ctrl+C and Ctrl+V to get a copy via the clipboard.

The other solution would involve VBA and can be done by using the transferspreadsheet command when there is no additional filter to be taken in account. When there is you can create a query first and use that for the transferspreadsheet command.

Need more info?

Nic;o)

yes I need more info..can you please give me example code?

[nico5038]

Create a button and activate the OnClick event to enter this line of code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "your table name", "c:/temp/result.xls", True

Replace the "your table name" with your table (or query) and make sure the quotes are still there and change "c:/temp/result.xls" into the path & file you want.

Nic;o)

[NeoPa]

Hi!

Is it possible that the result in the subform will export to excel file??
Please help..

Cassey,
Your threads include far too little information.
I've asked before that you read through POSTING GUIDELINES: Please read carefully before posting to a forum before posting your questions. Please do so before your next question as our experts should not be expected to work out the question for you as well as the answer.

MODERATOR.

[cassey14]

Cassey,
Your threads include far too little information.
I've asked before that you read through POSTING GUIDELINES: Please read carefully before posting to a forum before posting your questions. Please do so before your next question as our experts should not be expected to work out the question for you as well as the answer.

MODERATOR.

Ok Im sorry about that..I am in a hurry that time..Ok I'll explain further..I have a search form..And in that search form I have a subform..When they search the results will display in the subform..I want to export to excel the result in the subform based on the query they search..