exporting data to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Try this:

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


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...
Click to expand...

--
Ruel Cespedes
Sr. Programmer Analyst
(e-mail address removed)

Message posted via AccessMonster.com
 
great!

thanks...

ams



Ruel Cespedes via AccessMonster.com said:
Try this:

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




--
Ruel Cespedes
Sr. Programmer Analyst
(e-mail address removed)

Message posted via AccessMonster.com
Click to expand...
 
You're welcome. Much luck and success to you.



great!

thanks...

ams
Try this:
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...

--
Ruel Cespedes
Sr. Programmer Analyst
(e-mail address removed)

Message posted via AccessMonster.com
 
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..
 
Back
Top