I have a Macro that uses TransferText to import a specific text file name. If the file does not exist, i want the Macro to halt/quit/ PRIOR to the TransferText attempting the import and erroring out. Basically, I need to validate that the file exists before TransferText attempts to execute. Is there an Action available for this?
Note, TranferText looks for a file name with with the following property as the import file is labeled with a date format:
="\\filepath\FileName" & Format(Date()-1,"mmddyy") & ".TXT"
Thanks in advance!