Hi,

1 Problem : I have a share drive in my company but some times it is
accessable and some times it is not accessable due to some technical reason.

If the share drive is not accessable I get an error can anyone tell me how
to handel this error exit the macro.

2 Problem : How can I come to know if a particular file is available on a
particular path.

3. Problem : How can I come to know if a particular path is available on a
computer.

Regards
Heera
Regards
Heera

Use DIR:

If Dir(filespec) = "" Then
do something else
End If

--
Gary''s Student - gsnu200833


"Heera" wrote:

Hi,

1 Problem : I have a share drive in my company but some times it is
accessable and some times it is not accessable due to some technical reason.

If the share drive is not accessable I get an error can anyone tell me how
to handel this error exit the macro.

2 Problem : How can I come to know if a particular file is available on a
particular path.

3. Problem : How can I come to know if a particular path is available on a
computer.

Regards
Heera
Regards
Heera

On Feb 13, 10:00*pm, Heera wrote:
Hi,

1 Problem : I have a share drive in my company but some times it is
accessable and some times it is not accessable due to some technical reason.

If the share drive is not accessable I get an error can anyone tell me how
to handel this error exit the macro.

2 Problem : How can I come to know if a particular file is available on a
particular path.

3. Problem : *How can I come to know if a particular path is available on a
computer.

Regards
Heera
Regards
Heera

You can use the DIR function.

MyPath="\\server\xyz\abc.xls"
StrReturn=dir(MyPath)
if StrReturn="" then
msgbox "The path is not availableor the file is not there"
end if

Both the solutions were usefull.

Thank you........

Gary can you answer my first problem.

when I dissconnect the cable of network and try to run the macor I get an
error.

It say bad file name error 52. How do i handle this error.
Regards
Heera