Problem saving to earlier version with macro

Hi from a cold but sunny Birmingham UK.

I created a macro for a friend some time ago which creates a new invoice and offer the 'Save As...' box to type in the customer name etc, then saves the invoice. However, he's just upgraded to Office 2007 and now wants to save the invoices as an earlier version to ensure his customers can open it when he emails it to them.

The problem is, in the 'Save As...' box bought up by the macro it only offers 'All Files (*.*)' as the save format and saves to xml format. Any idea how I can get it to (ideally) pre-select Excel 97-2002....or at least offer him the option to select it himself please?

I've tried adding format code into the macro - ActiveWorkbook.SaveAs DstFile, FileFormat:= _ xlExcel9795, but it makes no difference.

Thanks for looking!

Chris.

I would think it would be better to save to a pdf, you can add a free addin to convert 2007 documents to pdf, see

http://www.excel-it.com/Excel%202007/save-pdf.htm

Then some code here

http://www.rondebruin.nl/pdf.htm

Thanks Roy - could be useful. I'll try it tonight!

Thanks for taking the time.

Chris.