There are a few posts in the Access newsgroups that use the Range
argument in an export, e.g.:


http://groups.google.ca/group/comp.d...a03535ad?hl=en

Debra Dalgleish wrote:
Perhaps there was a reason in earlier versions of Excel, that's no
longer a problem.

You may want to add some error checking so it adds the sheet if it's not
already in the workbook (if possible).

deko wrote:

I've tested in Office XP and Office 97, and it worked, so you should be
okay. There are other undocumented "features" but I guess you assume a
risk in using them.



Thanks for the validation.

I tested on 3 different machines: one with WinXP/Office2003, one with
WinXP-SP2/Office2003, and one with Win2000/Office2002 (all at current
patch
levels). All worked without incident.

Still, there must be some reason why MS said not to do this.

But if I can't get it to break, I'm going to use it.

The only other way to accomplish what I'm trying to do would be to export
each Access table into a temporary worksheet (as you suggested) and
then use
automation to open the workbook and move each table of data to it's
respective range in a new worksheet, and then delete the temporary
worksheets.






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html