Hi folks, I had successfully created a VBA module which would transfer results from one workbook (source) to another workbook.
But i encountered one weird problem, in the testing workbook, the speed of transfering between the two workbooks was pretty fast. But when I export the module to the actual workbook, the speed of transfering between the two workbooks were very slow. The codes for the testing and actual are exactly the same but produce different results speed.
I manage to solve the problem by re creating the module again in the actual workbook instead of importing.
Wondering does anyone faced the same problems as me before? As I still do not understand why there is the drop in speed.
But i encountered one weird problem, in the testing workbook, the speed of transfering between the two workbooks was pretty fast. But when I export the module to the actual workbook, the speed of transfering between the two workbooks were very slow. The codes for the testing and actual are exactly the same but produce different results speed.
I manage to solve the problem by re creating the module again in the actual workbook instead of importing.
Wondering does anyone faced the same problems as me before? As I still do not understand why there is the drop in speed.