I am using VBA to copy a table from an unopened Excel file to the active Excel file. The macro was developed in the "record macro" mode and works fine. However, the table is 40,000 lines long, and I would like to apply the advanced filter without opening the file. Your help with this task would...