check for excel workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jnewl - 15 Nov 2007 12:46 GMT

how do i check to see if an excel book is in a folder?

i am automating a process for non technical users and if a workbook exists,
i want to delete so they do not have to respond to the message already exists.

i am using a generic workbook during the update process as a work area

thanks for your help

Reply to this Message

Douglas J. Steele - 15 Nov 2007 13:10 GMT

Assuming the full path to the file is in variable strFilePath

If Len(Dir(strFilePath) > 0 Then
' File exists: delete it
Kill strFilePath
Else
' File does not exist
End if

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> how do i check to see if an excel book is in a folder?
>
[quoted text clipped - 6 lines]
>
> thanks for your help

Reply to this Message

jnewl - 15 Nov 2007 13:19 GMT

thanks much

> Assuming the full path to the file is in variable strFilePath
>
[quoted text clipped - 15 lines]
> >
> > thanks for your help

Reply to this Message