Hi all, this is my first post however I am a frequent visitor of the site due to the knowledge and information. I am fairly new to VBA and usually find answers on here to enable me to proceed however on this occasion I haven't been able to.
I have a table in which column A has a list of employee numbers (the number of which varies everyday).
I am trying to get the email address from our internal phonebook held on internet explorer.
So what I am trying to do is:
Take the employee number from a list in column A.
Find in ie phonebook (a constant will be http//'thisurl/adcd***(then varies with the employee numbers')***.
Locate email (there will only be one).
Paste the email address back to a cell in excel (it will replace the employee number).
Loop through the remaining employee numbers until the last populated cell.
Eventually I would like to then create an employee to those employees with text and then a table from excel but that isn't as necessary at the moment.
Apologies if this is not specific enough but I am limited as to what information I can give.
I have found scenarios to find emails on specific constant URLs but have not been able to adapt.
Many thanks in advance
Ps go easy on me.... I'm new
I have a table in which column A has a list of employee numbers (the number of which varies everyday).
I am trying to get the email address from our internal phonebook held on internet explorer.
So what I am trying to do is:
Take the employee number from a list in column A.
Find in ie phonebook (a constant will be http//'thisurl/adcd***(then varies with the employee numbers')***.
Locate email (there will only be one).
Paste the email address back to a cell in excel (it will replace the employee number).
Loop through the remaining employee numbers until the last populated cell.
Eventually I would like to then create an employee to those employees with text and then a table from excel but that isn't as necessary at the moment.
Apologies if this is not specific enough but I am limited as to what information I can give.
I have found scenarios to find emails on specific constant URLs but have not been able to adapt.
Many thanks in advance
Ps go easy on me.... I'm new
