Macro for links with different endings (tickers)

[rolex]

SOLVED by KUMAR

[LokeshKumar]

Could you give me website link and table name...I will give you code which fetch out data without query connection.

[rolex]

Getting tickers to excel

[rolex]

getting tickers to excel from websites

[LokeshKumar]

Hi,

Could you please just try the following code

Please Login or Register  to view this content.

Here is your attachement..Tickers.xlsm

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

[rolex]

Thank you! It looks such short script making more than the one I tried to create which is nowhere near.

I really appreciate your help, was doing it for along time but now I can see how it should have been done.

[LokeshKumar]

Click on the star if you think some-1 helped you. in this case its me.......

[LokeshKumar]

Hey
Use the following code....
I tried to send you msg......

Please Login or Register  to view this content.

[LokeshKumar]

Hi
There is an error since you have not added the following library:-
Tools->References->Microsoft HTML Object Library...

I have attached the file after adding the library....hope it will work fine at your end.

here is your attachment...Tickers.xlsm

Cheers....