Hi..
I have 2 very very similar files..the only difference is that the files are for 2 different regions.
I have vba that does everything in the files and basically, all the user has to do is press 2 buttons and it creates a pdf report for them.
But, one of the files is 400kb and another file is 21mb! I have looked at the data in each worksheet and cannot see much more data in the 21mb file...so, I was wondering if there is any way to check what is actually making the file so much larger? i.e. which worksheet is the one causing the issue?!
Cheers,
Eoin
I have 2 very very similar files..the only difference is that the files are for 2 different regions.
I have vba that does everything in the files and basically, all the user has to do is press 2 buttons and it creates a pdf report for them.
But, one of the files is 400kb and another file is 21mb! I have looked at the data in each worksheet and cannot see much more data in the 21mb file...so, I was wondering if there is any way to check what is actually making the file so much larger? i.e. which worksheet is the one causing the issue?!
Cheers,
Eoin
