export button to set default save as

[hughesie78]

Im looking for some help;

I have a windows application devekoped. In vb.net
I have a crystal report viewer for displaying my reports, I have various different report forms which use this viewer.
My problem is that the export button defaults to a .rpt extension , and I need it to default to .xls

I have come across the exportoptions class and created a button using this, but this exports as soon as button is hit.

I want the exact same functionality as you get for the standard export button, I just don’t want the default save as to be ‘rpt’, I want it to be ‘xls’ and still allow the user to changes their export type, probably involving the SaveFiledialog component

Prob is.. I have no idea how its done.. anyone got any ideas or better some code. Id really appreciate help on this.