I tried to use the workspace to minimise the time to open all the source and destination
workbook to make it looks good. But another problem found, the size and order etc of the
workbooks won't be saved every time i save the workspace. And I've set the split and freeze
panes in the worksheets, it won't be saved by workspace!
And every time i save the workbook in workspace for the 1st time after i open the workspace,
it asking me whether wanna save to a new copy of file or overwrite the file..
workbook to make it looks good. But another problem found, the size and order etc of the
workbooks won't be saved every time i save the workspace. And I've set the split and freeze
panes in the worksheets, it won't be saved by workspace!
And every time i save the workbook in workspace for the 1st time after i open the workspace,
it asking me whether wanna save to a new copy of file or overwrite the file..