Platoche56
New Member
- Joined
- Jul 29, 2017
- Messages
- 2
Hi all,
I have taught myself a fair few languages over the past months and I just stumbled on something I cannot quite comprehend and extensive research online has not helped. The premise is super simple, I was trying to get basic info from a LinkedIn company page (for educational purposes only of course) and was able to extract virtually anything consistently from pages except for "similar companies" and "affiliated companies".
I have tried two main methods to access it: working with the html or simply copy pasting the web page content and then working within excel on that specific data. I do sometimes get the data through the "copy paste" strategy but this depends on which company page I deal with. It works for example for Mac Guff but does not for Pixar.
The odd thing is that when I copy paste manually for Pixar I dot get the similar and affiliated companies data while if I carry out the exact same procedure using VBA I do not get it....
The procedure I use is the following after the page has loaded:
I also tried using Sendkeys but it did not solve it either.
I know there is nothing with the code since I am able to get anything else. I know this is not due to the page not being loaded since I am able to extract data.
What am I missing
? Did you ever come across something like this?
Many thanks,
A
I have taught myself a fair few languages over the past months and I just stumbled on something I cannot quite comprehend and extensive research online has not helped. The premise is super simple, I was trying to get basic info from a LinkedIn company page (for educational purposes only of course) and was able to extract virtually anything consistently from pages except for "similar companies" and "affiliated companies".
I have tried two main methods to access it: working with the html or simply copy pasting the web page content and then working within excel on that specific data. I do sometimes get the data through the "copy paste" strategy but this depends on which company page I deal with. It works for example for Mac Guff but does not for Pixar.
The odd thing is that when I copy paste manually for Pixar I dot get the similar and affiliated companies data while if I carry out the exact same procedure using VBA I do not get it....
The procedure I use is the following after the page has loaded:
Code:
ie.ExecWB 17, 0 '// select all
ie.ExecWB 12, 2 '//copy
tgt.Cells(1, 1).PasteSpecial '//paste dataI also tried using Sendkeys but it did not solve it either.
I know there is nothing with the code since I am able to get anything else. I know this is not due to the page not being loaded since I am able to extract data.
What am I missing
? Did you ever come across something like this?Many thanks,
A
