Verify if a workbook exist with a macro
 

hello,
i want to verify if a workbook exist in a disk with a macro???

regardes

Verify if a workbook exist with a macro
 

Hi Homero

You can use Dir

Sub test()
If Dir("C:\Data\test.xls") < "" Then
MsgBox "Exist"
Else
MsgBox "Not exist"
End If
End Sub




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Homero" wrote in message ...
hello,
i want to verify if a workbook exist in a disk with a macro???

regardes