I have this project where I put a macro template in the Data\Input folder of my package. The macro generates a table on one on its worksheets. Now, I’ve run the process on testing environment and I am investigating on something that requires me to check that macro workbook. Is there any way I can retrieve it?
You can read any cell of the table from
the excel worksheet and check whether data exists within that cell or not. If it exist s, it means table has been created else not.