hi,
Could someone help me. I'm wondering is it possible ussing vba to pull data from web page.
page address: http://www.geonames.org/postalcode-s...ml?q=&country=
I'm trying to write a macro which could import result of searching to excel file.
i have no idea how to start with that
Thank you in advance for help
i found this movie on you tube http://www.youtube.com/watch?v=Z9N60AIZQNE
it will be grat if macro will do something like this one. for example: i've got list of cities and it will search for post code, and country and put this data to the excel file.
or if it'll work like i wrone in previous post.
I'm begginer in vba. I was trying to find something in net, but frankly speakinf mostly i don't understand information which i read.
Thanks in advance for any help.
ps. if someone know where i can find information about this ( info for dummies) i'll be pleased.
Hello young_86,
The macro code below is called by the button on"Sheet1". This has been added to the attached workbook. This level of knowledge is more advanced than what you will find easily either on the web or in books. I will answer you questions as best as I can.
Module1 Code
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi All Experts,
Can anybody tell me any website (Example: Nseindia.com) page Data
extract in excel as it same view format (at least data extract that’s
sufficient) & update it when refresh from external data link toolbar.
If I refresh Sheet then automatically Datasheet refresh
That is possible in Excel? Pls guide me
Regards
Amar
amartakale,
Welcome to the Forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Leith Ross you are my god!!!! its awesome, thank you soooo much.
Hello young_86,
You're welcome. Glad I could help. If you have any questions about the code, just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks