Output Query to Excel

  • Thread starter Frederick Wilson
  • Start date
F

Frederick Wilson

Hello all,

I have a query that I am outputting to an excel spreadsheet. When using
excel VBA I was making every other line highlited.

The spreadsheet would not keep this conditional formating because Access
saved the spreadsheet as Excel 5. I got around the problem using Excel
code to saveas with the parameter xlNormal.

Is there a way to make Access output this query in the current version
of Excel?

Thanks,
--
Frederick Wilson

_____________________________________
for multimedia design services visit
http://www.legalanimatics.com
 
J

Jerry Whittle

Instead of OutputTo try TransferSpreadsheet. It gives you more control of the
spreadsheet type. I'm not sure if that will work with your basic problem of
conditional formatting though.
 
Top