Send subform datasheet with Formating to Excel

[Cagney]

I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney

 

[Cagney]

I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney

Sorry for the omition, I am using Access 2003.

 

[Stuart McCall]

I have a subform in datasheet view with conditional formatting and
Check boxes. I want to send this subform DS exactly as it is formated
to Excel. But my check boxes turn into fields with True or False in
them, and my formatting is lost. How can i get this Subform Datasheet
sent to Excel as is, formating and all?
Thanks
Cagney

Try exporting to HTML, then open that in Excel. The formatting probably
won't be perfect, but usually with a few adjustments you should get
reasonable results.