I will preface this by saying what I am asking is (almost) identical to this post: Search a website with Excel data to extract results and then loop
The only difference is that I'd also like to retrieve the 'Main Business Location'.
QHarr has provided a solution to retrieving just the Entity Type which I tried to follow, but unfortunately I am not familiar with VBA at all, and so I must have done something wrong in following his/her steps as my VBA popped out an error instead. I would love to ask him/her directly but I don't have enough reputation :(
My data is in "Sheet1".
Here is the first two rows of what sits in Sheet1
Here are the steps I followed.
- Alt + F11
- Tools > References > tick Microsoft HTML Object Library > OK
- Insert Class Module
- Copy paste QHarr's class clsHTTP's code
- Insert Module
- Copy paste QHarr's Standard module's code
- Run
An error pops out, saying "Compile error: User defined type not defined", and highlights the code "http As clsHTTP" and the "Public Sub GetInfo()" is highlighted in yellow, like so.
My two questions are:
- What have I done wrong?
- How can I also retrieve the Main Business Location?
Thank you all.
Aucun commentaire:
Enregistrer un commentaire