excel Macro

[vijaychennai]

Hello all,

I already created excel form.

the form text box data match with acess database then sheet1 will show.

My Question:

i am using my database in common share drive. i want to know if common share drive is not no there means the excel want's to close automatically....

what code i want to use...

 

[vijaychennai]

Please Reply.....

 

[ogo]

Hi Vijay,

I just wanted to know if common share drive is not there does the code throw any error?. If yes you can check for this particular error and use.
Application.quit
within an If block

 

[VBACO]

When your form or workbook loads you can have it check to see if the file exists. I havent tested this but it should work.

If Dir("S:/[your db location.mbd")="" then Application.Quit