DoCmd.TransferSpreadsheet

[Kalyan Ganesan]

When i use DoCmd.TransferSpreadsheet to export, it assings a default folder and it allows me only to give the file name,how do i assign the folder name as well?

 

[dhookom]

This works for me:

Sub testExport()
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblShifts", "C:\data\access\MyExcelFile.xls", True
End Sub

Do you get an error message?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Kalyan Ganesan]

Your code works..thanks...so the trick is to use acSpreadsheetTypeExcel9 right?

 

[dhookom]

I don't think the type has anything to do with the issue unless it's a combination of type and file name.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016