TransferSpread***

From: "DuncanG" <DuncanG@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 16 Aug 2005 10:01:09 -0700

I'm trying to export data from a query to excel but I need the 'save as'
dialog box to prompt the user for a file name.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "qryExcel",
"C:\Archive\FileName.xls", True

TIA,
Duncan
.

Follow-Ups:
- Re: TransferSpread***
  - From: Ken Snell [MVP]

Prev by Date: RE: Date field in csv file
Next by Date: Re: TransferSpread***
Previous by thread: Date field in csv file
Next by thread: Re: TransferSpread***
Index(es):
- Date
- Thread