Opening a web page in Excel (Manually vs Macro)

Derek_35 · Apr 23rd, 2002, 09:58 PM

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

brettvba · Apr 23rd, 2002, 10:17 PM

there might be something that makes it take longer post your code,

Tom Schreiner · Apr 23rd, 2002, 10:19 PM

Post your code Derek...
Maybe someone in here can clean it up.
Probably not me, but someone else.
By the way, you're not using a loop, are you?
Inside Joke!
Tom

Derek_35 · Apr 23rd, 2002, 10:28 PM

To simply open & close a webpage

dim ID as integer
ID = 1
Workbooks.Open Filename:= _
"http://www.testing.com/?user_id=" & ID

ActiveWindow.Close
Application.DisplayAlerts = False

[ This Message was edited by: Derek_35 on 2002-04-23 21:30 ]

brettvba · Apr 23rd, 2002, 10:44 PM

im curious as to why you have the code close the window just after you open it and why you have display alerts at the end of your code?

Also i have xp as well and it opens just as fast if not faster with a macro!

[ This Message was edited by: brettvba on 2002-04-23 21:49 ]

Derek_35 · Apr 23rd, 2002, 11:03 PM

Yes, that code is worthless. It only opens then closes.

I have a small amount of code between the open and close obviously, but the point I was trying to make was even with the code I provided, it is taking me 15-20 seconds to open and close a webpage in Excel.

There has to be something wrong. I'm on a 1.8 GHz machine with 512 megs of RAM and a DSL 1M/1M line.

Are there any settings that could be a little screwy?

-----------------

I've just determined that 80% of my time holdup is on the close, if that helps anything.

[ This Message was edited by: Derek_35 on 2002-04-23 22:11 ]

Derek_35 · Apr 24th, 2002, 12:29 AM

If anyone cares...

I figured out my problem. I had published so much information previously and I never deleted them, therefore each time something closed it was saving all of my previous published files!

I think there was 8 of them...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 09:58 PM	#1
Derek_35 New Member Join Date: Apr 2002 Posts: 25	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

Apr 23rd, 2002, 10:17 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	there might be something that makes it take longer post your code,

Apr 23rd, 2002, 10:19 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Post your code Derek... Maybe someone in here can clean it up. Probably not me, but someone else. By the way, you're not using a loop, are you? Inside Joke! Tom

Apr 23rd, 2002, 10:28 PM	#4
Derek_35 New Member Join Date: Apr 2002 Posts: 25	To simply open & close a webpage dim ID as integer ID = 1 Workbooks.Open Filename:= _ "http://www.testing.com/?user_id=" & ID ActiveWindow.Close Application.DisplayAlerts = False [ This Message was edited by: Derek_35 on 2002-04-23 21:30 ]

Apr 23rd, 2002, 10:44 PM	#5
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	im curious as to why you have the code close the window just after you open it and why you have display alerts at the end of your code? Also i have xp as well and it opens just as fast if not faster with a macro! [ This Message was edited by: brettvba on 2002-04-23 21:49 ]

Apr 23rd, 2002, 11:03 PM	#6
Derek_35 New Member Join Date: Apr 2002 Posts: 25	Yes, that code is worthless. It only opens then closes. I have a small amount of code between the open and close obviously, but the point I was trying to make was even with the code I provided, it is taking me 15-20 seconds to open and close a webpage in Excel. There has to be something wrong. I'm on a 1.8 GHz machine with 512 megs of RAM and a DSL 1M/1M line. Are there any settings that could be a little screwy? ----------------- I've just determined that 80% of my time holdup is on the close, if that helps anything. [ This Message was edited by: Derek_35 on 2002-04-23 22:11 ]

Apr 24th, 2002, 12:29 AM	#7
Derek_35 New Member Join Date: Apr 2002 Posts: 25	If anyone cares... I figured out my problem. I had published so much information previously and I never deleted them, therefore each time something closed it was saving all of my previous published files! I think there was 8 of them...