Export Query to Excel - Field Order

J

Jo Ann

I am trying to export a query to Excel. I created a simple Marco: Open Query,
Output To.. But the problem is, the order is messed up. After creating the
database, it was decided that everything should be alphabetized. I did that,
and I even changed the order in the query. When I export directly from the
query it's fine, but when I export through the macro, the order messes up
again. Any ideas?

Also, how do I change the cell sizes on the excel that the information is
exported to?

I appreciate any help! Thanks.
 
J

Jo Ann

Looks like I solved the first part- I was opening the query, but I selected
form for the output. I changed them both to query, and worked like a charm. I
could still use advice on the cell sizes for excel, though. Thanks!
 
Top