Common Dialog problem

[Guest_imported]

In a commondialog how can I detect if a user pressed the cancel button? What is the error that is generated and how can I trap it?

I have:

CommonDialog1.ShowOpen
txt2 = CommonDialog1.FileName
OLE2.CreateEmbed (txt2)

Of course if the user presses cancel the 2nd line will also be read and I'll get an error because there is nothing on txt2!! How can do something like:

CommonDialog1.ShowOpen
txt2 = CommonDialog1.FileName

If user Didnt_Press_Cancel then
OLE2.CreateEmbed (txt2)
End if

I'd like to do something like this, but don't have the knowledge to do it can anyone help?

 

[nantronix]

Set the CommonDialog.CancelError property to TRUE. When the user presses the Cancel button, an error will be triggered.

http://www.nantronix.com

 

[Guest_imported]

Thank you for your reply.
I've allready tryed that, but after that what can I do? I'm just starting with VB so I guess this should sound basic but for me it isn't... How can I avoid the OLE2.CreateEmbed (txt2) line to be runned if the user presses Cancel?

Thanx.

 

[BB101]

repeat
CD.showopen
filename = CD.filename
until filename <> &quot;&quot;

i find this useful... it keeps asking until they select a file

 

[madlarry]

To avoid the OLE2 line being run, put the following error handling statement before the .Showopen statement:

On Error GoTo ErrHandler

then at the bottom of the procedure:

Exit Sub

ErrHandler:

' User pressed the Cancel button

End Sub

This will capture the Cancel button and go directly to the end of the procedure without processing any other lines.

Madlarry