transferspreadsheet

[rjumelet]

In this command you can specify the worksheet and range of a excel file, has anyone a example of this ?

Thanks in advance,

Rob

 

[zevw]

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel97, "TableName", "C:\Test.xls"

 

[dhaveedh]

Try this,

wrksheet.Cells(r,c)

r = rows
c = columns

For c = 1 To 9
wrksheet.Cells(1, c).Font.Bold = True
Next

I used this to format 9columns of the first row in my worksheet to be the header of my transfer to a spreadsheet from access.


Hope it helps.