shockey8oz
New Member
- Joined
- Sep 17, 2012
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I am trying to pull in a work schedule table from my company's intranet. I have tried entering credentials with the same failing results. I am using Office 365. My default browser for my operating system in Edge. I have Chrome and FireFox available. I would love to use the automatic page updating WebQuery for this project versus building a macro to import the data. Any insight would be much appreciated.
My issues are:
1) The Data Query doesn't recognize any tables on the webpage. (SEE IMAGE 1)
a) An inspection of the HTML code shows the entire page is built as a table. I would need to go into the fourth table level to get to my desired data
b) XPATH for reference ("/html/body/table/tbody/tr/td/table[2]/tbody/tr/td/table/tbody/tr/td/table[3]")
2) The Webpage view shows a browser incompatibility issue. (SEE IMAGE 2)
a) I am using the updated URL
My issues are:
1) The Data Query doesn't recognize any tables on the webpage. (SEE IMAGE 1)
a) An inspection of the HTML code shows the entire page is built as a table. I would need to go into the fourth table level to get to my desired data
b) XPATH for reference ("/html/body/table/tbody/tr/td/table[2]/tbody/tr/td/table/tbody/tr/td/table[3]")
2) The Webpage view shows a browser incompatibility issue. (SEE IMAGE 2)
a) I am using the updated URL