Nick,
MSDN is your friend...
http://msdn.microsoft.com/en-us/library/bb241279.aspxalthough according to the page 56 is an acceptable version number. Is the version of Excel on your box that version or later?
>why do I get "Unable to get the SaveAs property of the workbook class.
>
>
>Update it doesn't like the 56 so I need to find the correct filetype parameter.
>2nd Update 39 is the value I want.
>
>I hate automation :-(