View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hshayh0rn hshayh0rn is offline
external usenet poster
 
Posts: 74
Default If a file exists then do this...

I need some help with code to do the following:

If a file like: BankNumber & "-Cost Centers.xls" exists in the directory
we're currently using THEN

useform.field_the_the_form.visible = False

BankNumber is defined as a string and is a dynamic part of the file name.

Also, where should this appear within my code? Should it be it's own module
or can it be right on the userform I'm munipulating the fields based on
whether or not the file exists?