This continues to baffle me...I have Excel XP.
It takes me approximately 5 seconds to manually open a web page in excel and then close it.
If I write a short code to open that same webpage then close it (without anything being done in between) it takes 3x as long.
Why? I know XP has a lot more features than previous versions of Excel and therefore will take slightly longer, but I wouldnt think a macro should take 3-4x as long compared to manually doing a task.
Are there any settings that I may have set that are limiting me from optimally performing this task? Can anyone think of anything? I'm very frustrated.
Thanks, Derek
It takes me approximately 5 seconds to manually open a web page in excel and then close it.
If I write a short code to open that same webpage then close it (without anything being done in between) it takes 3x as long.
Why? I know XP has a lot more features than previous versions of Excel and therefore will take slightly longer, but I wouldnt think a macro should take 3-4x as long compared to manually doing a task.
Are there any settings that I may have set that are limiting me from optimally performing this task? Can anyone think of anything? I'm very frustrated.
Thanks, Derek