exporting data to excel

[amsuria]

hi,

i would like to export data to excel...

Currently, im using the codes below:

DoCmd.OutputTo acOutputTable, "Project", acFormatXLS, _
strPath & "\\\Projects_Report.xls"

BUt the problem is, my end users are not allowed to save the exported file
in their desired location... how am i goin to do that?

thank you...

really need your help so bad...

 

[Ruel Cespedes via AccessMonster.com]

Try this:

DoCmd.OutputTo acTable, "Project", "MicrosoftExcelBiff8(*.xls)", "", False,
"", 0

 

[amsuria]

hi ruel,

is it possible to export only those filtered records?

I have a subform that displays the filtered records, and i am thinking of
exporting only those records instead of all records in a table/query.

is it possible?

thanks again..