jimmyboy2512
07-02-2014, 05:18 AM
Hi all,
I run a small business from home selling items on ebay and I use Royal Mail to post multiply packets and would like to be able to monitor the tracking for these item using a excel form.
I can get VBA to make a search of "A1" on the website and bring up the results page but Iam unable to get excel to read the webpage and put status of the item in column "B".
I would like to be able to enter multiple tracking numbers in to column "A1, A2 etc" on excel and the the VBA to complete a websearch on royal mail website and return the data if its delievered or not to column "B".
I have checked the source code on the webpage and have found the bit of information im after "the item is delivered or not" but are unable to get excel to put the status in column "B"
Is anyone able to help?
Thank James
I run a small business from home selling items on ebay and I use Royal Mail to post multiply packets and would like to be able to monitor the tracking for these item using a excel form.
I can get VBA to make a search of "A1" on the website and bring up the results page but Iam unable to get excel to read the webpage and put status of the item in column "B".
I would like to be able to enter multiple tracking numbers in to column "A1, A2 etc" on excel and the the VBA to complete a websearch on royal mail website and return the data if its delievered or not to column "B".
I have checked the source code on the webpage and have found the bit of information im after "the item is delivered or not" but are unable to get excel to put the status in column "B"
Is anyone able to help?
Thank James