Hi All,
I have a file that is used as a destination for bad records discovered while running a SQL Server 2000 DTS Package. This file seems to be suffering some kind of bloating (my hunch is that it has some kind of formatting attached to all cells). I have tried deleting empty cells, and the size of the (empty!) file is still about 13 megs!
Is there any code that I can use to clear all data from the spreadsheet except for the first row of each tab, and also remove any formatting (while keeping formatting in the first row)?
I would prefer to add this code to an access module that handles placing the file in the correct destination each month, but even something that I can run manually when the file gets too large would be great.
Thanks a lot,
Alex
It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.
I have a file that is used as a destination for bad records discovered while running a SQL Server 2000 DTS Package. This file seems to be suffering some kind of bloating (my hunch is that it has some kind of formatting attached to all cells). I have tried deleting empty cells, and the size of the (empty!) file is still about 13 megs!
Is there any code that I can use to clear all data from the spreadsheet except for the first row of each tab, and also remove any formatting (while keeping formatting in the first row)?
I would prefer to add this code to an access module that handles placing the file in the correct destination each month, but even something that I can run manually when the file gets too large would be great.
Thanks a lot,
Alex
It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.