On Error open wb

[samot79]

Hi,

I have a macro where I import data to one wb from a CSV file.

Code look like this:

Please Login or Register  to view this content.

I want to execute a vbCritical msgbox saying file not found if line "Open "Myfile.CSV" For Input As #1" generates an error.

[xlnitwit]

Hi,

You might test with Dir for the existence of the file

Please Login or Register  to view this content.

[samot79]

Works just perfect. Thanks!