Guys, hope you can help, im stuck with an anoying problem on an Excel Web Query. I'll try and explain it as simple as possible. Right, here goes...
I have an EWQ that submits the name of a member of staff. This first submital then throws up another page with a hyperlink on it to view the employee' history. The problem being, this hyperlink carries the employees' staff number and NOT their name. My problem is that; I do not know how to get the EWQ to, instead of downloading the first submital page, instead follow the link and then download the consequential page with the history on it. This is really anoying me. I've only started using EWQ's this week but i have a fair grasp of their workings. I just cant think of a way to ignore the first page and load the second one instead.
I was thinking of VLOOKUP, but this is NOT practical as there are over 30'000 staff members, which is constantly being updated. I would much rather a simpler solution via this method.
Guys, hope you can help, im stuck with an anoying problem on an Excel Web Query. I'll try and explain it as simple as possible. Right, here goes...
I have an EWQ that submits the name of a member of staff. This first submital then throws up another page with a hyperlink on it to view the employee' history. The problem being, this hyperlink carries the employees' staff number and NOT their name. My problem is that; I do not know how to get the EWQ to, instead of downloading the first submital page, instead follow the link and then download the consequential page with the history on it. This is really anoying me. I've only started using EWQ's this week but i have a fair grasp of their workings. I just cant think of a way to ignore the first page and load the second one instead.
I was thinking of VLOOKUP, but this is NOT practical as there are over 30'000 staff members, which is constantly being updated. I would much rather a simpler solution via this method.
PLEASE PLEASE PLEASE someone help me...?
Thanks in advance guys,
Paddle n Creek this end :(
D.