webpage

I am trying to learn MSXML2.XMLHTTP- how to get data from a webpage and how to input data from excel into webpage field. To do so, I am trying to login Facebook with using XML and not IE or an HTTP request with Excel VBA. 1. Login into Facebook using XML and not IE or an HTTP request with...

I'm trying to click on button using element by classname tag name but no success

Can someone please help me? I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique? https://www.nhl.com/standings/2019/league

Hello. I am trying to import a webpage and its tables into excel I use the data tab, then from web, and import the webpage When I do this, the web view on the pop-up displays the webpage perfectly. Note - It does have the "table highlighting is disabled because...." On this webpage, there...

Dear Excel experts, I made a nice dashboard in excel with graphs (from pivot tables) with slicers. I want to save this excel dashboard as a webpage, while maintaining the functionalities (using the slicer to select things, on which the graph automatically adjusts itself). Saving as a webpage...

Hi, I have managed to get on to a webpage through some basic script. On that webpage there are a number of Hyperlinks. I need to identify the appropriate Hyperlink (in the below case it would be where the 'label' is "S-C-BSS-1" and then click it. Is this doable? If so...how? Element...

Hello, Anyone who knows if it is possible to set up a webpage (HTML/PHP?) with some fields to fill and then generate excel file that you can download with those data from webpage? Have been searching for this subject for a while now, but can't really find any related.

How can I navigate to the second page of a webpage? Suppose I want to go to the second page of the questions webpage on mrexcel: Dim IE As SHDocVw.InternetExplorer Set IE = New SHDocVw.InternetExplorer IE.Visible = True IE.navigate...

How can I ensure the extraction of data from a webpage has finished before proceeding to the next sub?

Hi, I've created a helpful Hyperlink+VLookUp formula that could really benefit from a small addition. But I just can't seem to figure out a solution. Here's my formula: =HYPERLINK(VLOOKUP(A1,Tab2!$A$1:$B$52,2,1),"Name") Basically, it returns a webpage stored another sheet that matches a...

Hello Experts, Requesting your support. I have been trying this code for more than a week. I have a webpage when I navigate, I need to click a link "Transcript". The problem is the webpage having two transcript link. But I use the 2nd one. I tried using SendKeys "{TAB}". Sometime only it is...

Hi All! Thanks in advance for the help! On a daily basis, I am taking hundreds of cells of data fromexcel and typing them into a webpage. With the webpage, each field of inputis separated by a tab. Is anyone familiar with a way that I could take thesehundreds of cells and get the data into the...

Hello Excel Users, Can someone help/show me how to fill in forms on this webpage via Excel VBA : http://repackr.com/ Thank you to read my problem Christinia

Hi, I am new to webscrapping. I want to transfer data of my excel into webpage form and submit it. And want this process to repeat it again and again for different cells.

Hi People, I've got some VBA code where i log into a website and navigate to a webpage however, i then need to click a tab on that webpage to see the information i want to extract (the URL is different each time as its includes the date and time) therefore I need to use VBA to click on the...

Hi Guys, I'm trying to share a pivot-table within my department & to date I've been sharing the pivottable itself via a single file webpage at a shared location. The data i'm showing is hours spent on programs by person & task. The trouble now is that we have grown both our client base & our...

Hi guys, Got a VBA code to log me into a website and navigate to a certain webpage. now i need some code to select all information on the webpage and paste this into cell a1 on the tab "sheet1". Does anyone know how to do this? I've tried a couple of things but so far no luck :(

hi All, I am looking for a VBA code that allow me to click a tab (provided as image) on a web page. The web page is not showing any id specific to the tab. Here is the source code. td height="36" valign="bottom"> a href="javascript:submitTab('pair_search')" tabindex="6" img...

I have a tab in a spreadsheet that is saved as a .mht with autopublish turned enabled. I added the follow code under the tag: The webpage flashes every 5 seconds like it's refreshing. The problem I'm noticing is that when I change a value in a cell on the excel file and click save, despite...

Hello, I've only just discovered that I can import data from a web page by: Import External Data ~> New WebQuery Much scarier than the reality in practise! I do however have a question, if the data I want is split across multiple web pages like this one here...