yinkajewole
Active Member
- Joined
- Nov 23, 2018
- Messages
- 281
How do you i know the particular line of code that consumes time to run?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Knowing the time it takes for code to run
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,888
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
You could comment out all the lines that aren't relevent !
OR
You could apply a timer before and after the line you think is causing issues.
What seems to be the issue ?
How long is your code taking to run ??
CAn you share the code....it may be soething else slowing your code down, if that is the problem
OR
You could apply a timer before and after the line you think is causing issues.
What seems to be the issue ?
How long is your code taking to run ??
CAn you share the code....it may be soething else slowing your code down, if that is the problem
Upvote
0
yinkajewole
Active Member
- Joined
- Nov 23, 2018
- Messages
- 281
Actually, there are some bitmaps in some archives. Using VBA, I use 7zip to extract the bitmaps and set them to a Picture box one after the other on a userform.
Well, I think using an external program (7zip) to extract the bitmaps must have been the cause of the little slow down.
However, I'm think that using a DLL to extract the bitmaps and possibly using binary mode can make it faster. Unfortunately, I don't have the idea.
Do you have any idea on how to go about this?
Well, I think using an external program (7zip) to extract the bitmaps must have been the cause of the little slow down.
However, I'm think that using a DLL to extract the bitmaps and possibly using binary mode can make it faster. Unfortunately, I don't have the idea.
Do you have any idea on how to go about this?
Last edited:
Upvote
0
