2003 Macro is not running fine in 2010 why?

**latifpatel.t** · 09-06-2016, 07:13 PM

Hi

I have a macro which i am trying to use in excel 2010 its not working fine(2003 working fine), its taking so much of time and result is not responding. Due to the ms office update i am suffering to use those macros.

May be having solutions but i am not aware of it, Suggest me how to use those macros again, Thank you in advance.

Macro states like this.

I am using this macro to grab data from website.
sheet1 contains only links
sheet2 will be the data grabbed
sheet3 will be like temp.,
I tried using xlsm also but still its not responding.

Please Login or Register  to view this content.

here is the code i am using.

Please Login or Register  to view this content.

**xladept** · 09-06-2016, 07:18 PM

Can you post your code?

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

**AB33** · 09-07-2016, 03:46 AM

latifpatel.t,

There could be many reasons:
The site might have changed; that is, the data are not longer available if the table has changed.
IE has many versions. Some versions will not work on some of the DOM objects.
The simplest solution would be to test the URL manually(Using excel import from Web) and see if the data are still there. If you are getting an error when you try to import then, the site might have changed.
If you could attach a sample excel book, we should be able to test it.

**latifpatel.t** · 09-07-2016, 08:28 PM

Please Login or Register  to view this content.

Then Run the macro. in 2003 it will work fine. but in 2010 not responding.

**AB33** · 09-08-2016, 03:57 AM

I have tested it in excel 2010 and it works.
Yes, it is not returning a table. As I said, the site might have changed.

You need to get rid of naming your sheet with index nos. The error is more unlikely to be connecting to the site.

Please Login or Register  to view this content.

**latifpatel.t** · 09-08-2016, 01:25 PM

According to the code you provided we cannot loop and grab the data.
and the website is fine when i opened in chrome using tool like weburlopener.com, 50 links at a time less than 2 seconds it opened,

if we clear sheet1 contents the next link will not load.
sheet1 is like input data(links), and the code works like sheet1 cell a1 link will be copy pasted i.e., data to sheet3 and from that data only few required fields will be copied to sheet2, and only sheet3 data will be cleared, and it will continue loop to loop sheet1 cell a2, a3...,
finally sheet2 contains 1st row will be the first link data, 2nd row will be second link.

links which are in sheet1 are from same website, and data is in same format. so it will be easy to take data with good format.

i think my problem is like the code is perfect which i am using now in MS Excel 2003, if we run the same code in 2010 excel then it will not work perfectly, starting two or upto 10 maximum rows it will work taking little time later it is not responding.

**AB33** · 09-08-2016, 02:09 PM

I am completely lost.
If it works on Chrome, why are you then using IE?
I have not given you any code. I have given you to show you the code works in excel 2010. The code is not running is not the same as the code errors. The code does not error, but it might not give you the required output.
This code loops through all cells in sheet 1, column A and the output is on sheet 2. I have run and it works; that is, I got the data, but it might not be the data you are after.

Please Login or Register  to view this content.

**latifpatel.t** · 09-08-2016, 05:26 PM

no its working.,

**scottiex** · 09-08-2016, 05:29 PM

Does it work if you only do a small number of iterations?
if so maybe you just need to clear your history every so often...

Please Login or Register  to view this content.

doing once each 20 a below

Please Login or Register  to view this content.

**AB33** · 09-08-2016, 05:33 PM

This is going to my last reply to this thread before I ignore you.
"no its working.," does not help me either.
If it is not working, it is your code not mine. I got involved to test why the code is not "Running", "Not" working in excel 2010. Unless you attach an excel book with desired result, I will leave for others to help you.

**AB33** · 09-08-2016, 05:35 PM

I run the code on the entire link and did not get a single error. I have got data.
Not getting an error and not getting the desired result are two different things.

**latifpatel.t** · 09-09-2016, 05:12 PM

Sorry i am trying to upload but its not uploading attachment.
thanks for trying.
suggestion from my friend,
when u export data from web then excel automatically uses Internet Explorer as default browser. Instead of how to make
use of other browser like chrome or any. how to change it.

example,
Open excel,
Alt + A + FW
then a window pop which is IE.

I am having Internet Explorer version 11 i think, which is a problem or excel 2010? confused.

2003 Macro is not running fine in 2010 why?

LinkBack

Thread Tools

Rate This Thread

Display

2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Re: 2003 Macro is not running fine in 2010 why?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] CheckBoxes.Add Works fine in 2010 but not 2007 or 2003

[SOLVED] Advanced Filter Macro does not work, running manually works fine

Project with AddIn runs fine in Excel 2000, 2003 and 2007...2010 crashes

Macro works fine in 2010, Crashing in 2003 - Posting problem code - Please Help?

Macro works fine in Excel 2003 but not in 2007

Flash videos cause Excel 2010 to crash but work fine in 2003 and 2007

Excel 97 not running macro that runs fine in 2000

Loop in my macro doesn't seem to be running; however, it compiles fine...

Bookmarks

Bookmarks

Posting Permissions