VBA acOutputQuery and acFormatXLS.  What does this mean?

KABOOM
KABOOM used Ask the Experts™
on
I'm just taking over for another person at work and trying to debug one of our small programs.  Can anyone tell me what acOutputQuery and acFormatXLS is.  From what I can gather, I believe they're standard functions in one of the libraries.  What they exactly do escapes me though.

DoCmd.OutputTo acOutputQuery, "EIASTORAGEDATA", acFormatXLS, "I:/EIA Storage/EIA Storage.xls"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
acOutputQuery simply means export a query.  "EIASTORAGEDATA" is likely the query which is being exported and acFormatXLS means export to *.xls format (Microsoft Excel formatting).  The last parameter is the output path of course.


-Paul.
This question has been abandoned and needs to be finalized.

You can accept an answer, split the points, or get a refund (information at http:/help/closing.jsp)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

joekendall, cleanup volunteer
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered by: paelo

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Joe
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial