Using 3.0, Automation Copy File activity is not accepting wild cards (such as *.xls) for Source File field. Toad 2.7 allows to enter wild cards for file name in Source File field and automation will perform a group copy.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.