|
|
|
|
|
|
|
|
|
Excel
|
Check if file exists
|
|
|
Ease of Use
|
Intermediate
|
|
Version tested with
|
2007
|
|
Submitted by:
|
Mohideen
|
|
Description:
|
Before running tool created in Excel Macro check if supporting files are available
|
|
Discussion:
|
I use this code to check if mdb files & image files which i use in the excel vba tool is available & is not deleted
|
|
Code:
|
instructions for use
|
If Dir("full path + file name") = "" Then
msgbox "File Not Found
Your Code
Else
Your Code
End If
|
|
How to use:
|
- Use this code to workbook_Open
|
|
Test the code:
|
- Already this code is tested in Excel 2007
|
|
Sample File:
|
No Attachment
|
|
Approved by Jacob Hilderbrand
|
|
This entry has been viewed 336 times.
|
|
|