i have created a macro, in which 6 variables are created using the fallowing code
This macro is run more than 100 times in a day. For the first few days the file was ok but now the file size has become 10mb, even though there is not much data in that, considering the amount of data in that the file size shud be no more than 1Mb. I think this is because every time the macro is run the 7 variables are created again and again so it is taking too much memory. Am i correct? If yes then wat is the code for disposing the variable?? if no then wat is the reason for the file being soo heavy??