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?
Printable View
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?
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