Need VBA code syntax to check if a TEXT file exists on a certain drive and folder.

[AshikHusein]

I am using a batch file to automatically import a certain table which is originally in the TEXT format. The batch file invokes an ACCESS macro which does the actual TransferText procedure.

There are time that the TEXT table may not exist in the required drive and folder. But the windows scheduler is programmed to run the macro to import that table, irrespective of whether it exists or not.

I would like to know what VBA code I could write to check this. I would imagine that it would be a function returning a boolean expression to check whether the particular .txt file exists in the drive. Would appreciate help in the above matter. Thanks

 

[AshikHusein]

I would like to apologize for posting this on the REPORTS section in error. it should have been in the VBA section. Am reposting it in the VBA section.