Output Query to Excel

  • Thread starter Thread starter Frederick Wilson
  • Start date 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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query is not updatable;; urgent 1
Best method / software for graphical output from dynamic excel data 0
output to Excel 5
Another parcing question 4
Output Access Query to Excel Spreadsheeet 4
Output Query as an Excel file 2
Is there a way to turn off the prompts of a make table query? 3
FormatPercent Function - Access 2003 2

Back
Top