How do I change a report to excel

[Arlene]

In my form I have created a commnand button to preview a report but instead
of being in a document form how would I change it to be viewed in Excel for
Run time access users.

 

[Jeff Boyce]

Arlene

I'm not sure I'm following...

When I create and preview a report using Access, I see an Access report. I
can export that report to Word or Excel, but it isn't "in" either of those
UNTIL I export it.

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Arlene]

Jeff,

Thanks for replying to me, What I was trying to do was I have created a Form
and within that form I have text boxes and Combo boxes. I have created a
Command button to view the report from a query but is there is a way to view
the report in a excel format instead of an access report. Here is a code I
have found on the web but not sure how to apply it.
DoCmd.OutputTo acOutputForm, "subfrm_ASSIGNED_DEFAULTS", _
acFormatXLS, "6000003_TARGET_DATA_ALL.XLS", True

 

[Klatuu]

You could use the TransferSpreadsheet to export your query directly to Excel,
then use the Shell command to open the workbook you just created.