Use dialogue box to decide which format to save to

[WeeBeng]

I have written code to save some data into either excel or text format. I wish to be able to know which format has been selected so as to decide which function to call. How would i be able to do this using a common dialogue box?

[John G Duffy]

The CommonDialog1.FilterIndex property will give you the value that the user selected from the List of Filters you supplied.

private Sub Form_Load()
CommonDialog1.Filter = ("Text|*.txt|BMP|*.bmp")
CommonDialog1.ShowSave
Debug.print CommonDialog1.FilterIndex
End Sub




John G