Opening File (error handeling)

[Stephen]

Hi all,

I need to open 2 excel files (example; "A.xls" and "B.xls") with
macro but it can happen that A.xls or B.xls is not present. Is there
way that if A.xls is not present it continues with opening B.xls or th
other way around?

Stephe

 

[Frank Kabel]

Hi Stephen

try something like
if dir("C:\temp\a.xls") = "" then
' file doesn't exist
Else
workbooks.Open "C:\temp\a.xls"
' process file
End if

 

[Nikos Yannacopoulos]

Stephen,

You can check if the file exists and not try to open it if not, by something
like this:

wrkbook = "PathAndFileName.xls"
If Dir(wrkbook) <> "" Then Workbooks.Open wrkbook

If you need to do this for, say, three or more, then it's preferable to
either assign the individual workbook names to an array, or keep then on a
worksheet, and loop through.

HTH,
Nikos

 

[Stephen]

Thanks people!! Just what I was looking for.

Many many thanks...

Stephen