Location of excel file after exporting it from Access 2003

GIStewart
GIStewart used Ask the Experts™
on
I am actually using the Tools | Office Links | Analyze It with Microsoft Excel method, and the excel file seems to get initially downloaded to random places (I think based on my last activity), but it makes it time-consuming to locate and delete if it's in the wrong place - which is normally the case.  Is there a way for it to be always downloaded to my desktop or a particular folder?  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can use the Transferspreadsheet method in either VBA or a macro.  There you can define a file name and path.

Here's a link:
http://msdn.microsoft.com/en-us/library/aa220766(v=office.11).aspx

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