My problem deals with an Excel Workbook that takes almost 15 seconds to save. Probably because the code and forms it contains makes the size of the file over 500KB. The code calls for the workbook to be saved 3 different times and a new workbook created which also is saved. So it takes almost 1 minute just to go through the saving processes.
Is there a way to create a file that would use Excel as the interface but use code from an outside source so the workbook that is saved does not contain all that code.
Or do you have any other suggestions for reducing the size of the workbook or making the saving process go quicker.
Thanks in advance.
HSMMIT
Is there a way to create a file that would use Excel as the interface but use code from an outside source so the workbook that is saved does not contain all that code.
Or do you have any other suggestions for reducing the size of the workbook or making the saving process go quicker.
Thanks in advance.
HSMMIT