In VBA code if a workbook that i have referenced is not there - how do i continue

[m.collins]

Hi,

In my macro i open a file on the network. Sometimes this file does not exist and the VBA stops (as expected)

What would be the code to tell VBA to continue through VBA code if the file does not exist withiout getting the error messages?

I assume that i will need to have code for 'if file exists' do this or 'if file does not exist' do this...

Thanks in advance

Mark

[Bob Phillips]

Please Login or Register  to view this content.

[m.collins]

Thanks Bob.

Regards
Mark