writing code to output form to .xls

[hockeyman9474]

I don't want to set this up as a macro. I would like to write a line to prompt a user to save a form as .xls. Here is where I am:


docmd.OutputTo(acOutputForm,New Contract,(*.xls))

it's looking for an (=) sign somwhere. Where am I wrong.

 

[Pcfred]

I think it needs a defining

Dim strTemp

strTemp = DoCmd.OutputTo(acOutputForm, New Contract, ("*.xls"))

 

[hockeyman9474]

dim as a string?

 

[WinblowsME]

   DoCmd.OutputTo acOutputForm, "New Contract", acFormatXLS