My apologies for crossposting this, but I did not get any response in
microsoft.public.access

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/4929
214ae589afd9/b11bf56313b894d4?lnk=st&q=access+export+to+excel#b11bf56313b894d4

The specific problem is mentioned in the above post, but here is a
basic description of the problem.

When using saved queries that are used as part of a union query, the
UNION query does not export to excel successfully and prompts the user
to "enter parameter value" when no parameters are used. However, the
query works correctly when you simply run it in access, and it is
possible to export to other formats, but it consistently fails when
exporting to excel.

I know the description in my previous post is rather long, but I
wanted to provide as much information as I could.

If anyone has any ideas, can reproduce the error, or can point me to
someplace where I can submit this to Microsoft, I would appreciate it.

Thank you.