Export using field name as filename???? 1

[maca9]

Hi

Here is the code i am using below to export a query to excel.

Is there anyway the file can be called the [JOBID] field when it is eported as opposed to them all being called supplier quote.

Private Sub Command100_Click()

Dataexport = "C:\Exports\Supplier Quote.xls" 'this name the path of the excel file you need to write to

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "supplierexport", Dataexport, True

End Sub


Any help appreciated.

Thanks

Scott

http://www.vegajewellery.co.nz

Diamond Specialists

 

[danvlas]

Dataexport = "C:\Exports\" & Me("jobid") & ".xls"

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[maca9]

Thanks Heaps!!

That worked perfectly!!

http://www.vegajewellery.co.nz

Diamond Specialists