Hi all,
I have a large list of websites and I need to get their exact corporate names as stated under "Impressum".
Can I get this with macros? Unfortunately I don't an excel expert, I haven't knowledge about macros.
Some example sites:
www.krz.de
www.ks-architekten.de
www.ksconsult-berlin.de
I would be very happy if anyone could help me!
Thanks in advance!
Hello missbg,
Welcome to the Forum!
What information from the web pages do you want to copy to Excel?
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!)
Hello Leith,
I need the company names from Impressum (it's not the same place on all websites).
For example:
Zentrale krz Kommunales Rechenzentrum - http://www.krz.de/
Kühnl + Schmidt Architekten AG - http://www.ks-architekten.de/
KSConsult Personal- und Karriereberatung - http://www.ksconsult-berlin.de/
Thank you!
Hello missbg,
Sorry, I am not familiar with the word Impressum.
It means Imprint.
It's a menu as Contact or Home for example.
Is it possible to get this data somehow?
So essentially from a list of websites, you want to open the Impressum page and extract the company's real name?
http://www.krz.de/impressum and find Zentrale krz Kommunales Rechenzentrum
http://www.ks-architekten.de/impressum and find Kühnl + Schmidt Architekten AG
http://www.ksconsult-berlin.de/impressum and find KSConsult Personal- und Karriereberatung
I'd have to say no.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I'm sorry but thank you for the answer!
Is it possible, all information from Impressum not only the name?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks