Tips for fast updates and printing in automating of Microsoft Excel
1. Use ScreenUpdating property
Application.ScreenUpdating = False
' code here
Application.ScreenUpdating = True
2. Use ADO to update xls file - is much faster than updating cell by cell
3. Use cell array - is much faster than updating cell by cell
No comments:
Post a Comment