Check to see if a file exists

Hey guys,

I have an excel spreadsheet used to populate word documents based on a template file that is loaded like this....

Please Login or Register  to view this content.

How can I check to see if this file exists before continuing with the macro as my colleagues tend to keep moving the spreadsheet to wherever they want (something I want to avoid as I need to keep central control)?

Any help appreciated.... !

what if you put the directory at the beginning of the path?
something like

"C:\Templates\Template_LOA.dot"

Regards

Dav

Unfortunately not really possible as it gets moved a lot so the path is only relative to the workbook - also surely that shouldn't make a difference as VBA understands ThisWorkbook.Path at other places in the code, most notabley in a few lines time when that file is loaded up.

Please Login or Register  to view this content.

Works for me. Dominics code is shorter than mine so better
is the directory and the file name returning exactly what you expect, so with the above ammend ment of the file, is this what you are looking for an d in the right place?

Regards

Dav

Chris

Have you checked you are working with the right directory and filename?

Hello Chris,

Did you add a folder "Templates" to your default workbook directory? Or are you trying to access "Templates" in the "Office" folder?

The default path for Excel workbooks is "My Documents". The system path for templates is generally "C:\Program Files\Microsoft Office\Templates".

Sincerely,
Leith Ross

Thanks for all your suggestions guys...

I have found the problem! The template files were hidden, so that my colleagues couldn't get they're hands on them... so now I have unhidden the files and hidden the folder that contains them, now all of the solutions offered above work perfectly. Thanks for your help!