How to know cell's address from Excel Query
I'm interested 'bout the AddIn. But actually I do many queries in that
closed workbook.
Some google user say that do query in opened workbook will cause bad
performance.
So, if I use code to open file, delete range and save file, didn't it
will cause leak of memory?
Any other solution how to delete range in closed workbook without open
it first?
Thanks,
Renata
|