Hi Ken

I am trying to do thisin the MSaccess form coding

I added a button to run Excel application and the code for the button looks
like this

Private Sub Command93_Click()
On Error GoTo Err_Command93_Click
   DoCmd.TransferSpreadsheet(acExport, acSpreadsheetTypeExcel9,
qKPWC_RECOUP, "C:\TRY", YES)

Exit_Command93_Click:
   Exit Sub

Err_Command93_Click:
   MsgBox Err.Description
   Resume Exit_Command93_Click
   
End Sub

but the code dosent run and is giving me an error

1) It gives me a error that a = is included somewhere. Does the
transferdatasheet action return any value. If it does what datatype does it
return

I tried modifying and added a
Dim x as integer
and assigned
x =    DoCmd.TransferSpreadsheet(acExport, acSpreadsheetTypeExcel9,
qKPWC_RECOUP, "C:\TRY", YES)
thinking that it might be returning a numeric value
but now while executing the code it gives me
Compile error : highlighted on Transferspreadsheet method
"Expected function or variable"

Please help

Madhuri