Prev: Duplicity in Lab data
Next: Data subsetting with Arrays
From: TripleK on 7 Apr 2010 15:01
Hi all,

I am creating multi sheet excel file (.xlm or .XLS) using ods
tagsets.excelxp . The excel worksheet has 9 tabs and 7 tabs having
100-200 rows and 8 and 9 tabs having 1000,3000 rows respectively. but
when this file created in network the file size is 12mb. I tried to
open it took 20mins to open . I saved as this file as .XLS and the
file is just 250kb. so then I tried to save this file as different
formt (like .xlsb or .xlsx) using some vb scripts or DDE it is takeing
long time to open and save as. I have 10 - 15 file to save so it takes
long time. So my question is

1. is there a way to reduce file size when using tagsets?
2. or can we 'save as' this file without opening .xlm file (created by
tagsets ods). tthe problem is with opening the file only.

Please let me know if there are any solutions / code for this
problem.
 | 
Pages: 1
Prev: Duplicity in Lab data
Next: Data subsetting with Arrays