How do I automatically delete the import errors table when I import a table from an excel file using the transferspreadsheet action in VBA?
The problem is that the name of the table created is unpredictable because tablename generated = [name of worksheet from source file]_[ImportErrors]
All I would like to do is be able to access this table once it is created in VBA...
Any help would be really appreciated,
Thank you.
The problem is that the name of the table created is unpredictable because tablename generated = [name of worksheet from source file]_[ImportErrors]
All I would like to do is be able to access this table once it is created in VBA...
Any help would be really appreciated,
Thank you.