webpage

  1. P

    How to click on download button tableau dashboard webpage using excel vba

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

    NHL.com website; How to get tables into PQ

    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
  3. A

    Help with web query

    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...
  4. A

    How to save an excel Dashboard as an interactive web page

    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...
  5. D

    How to click hyperlink on 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...
  6. R

    HTML/PHP that can generate excel file for download

    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.
  7. T

    Navigate to second page on webpage

    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...
  8. T

    Detect webpage refreshed before proceeding

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

    Copy/Store cell data to be use post Hyperlink?

    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...
  10. S

    VBA code to click a link in a webpage (Two link with the same name)

    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...
  11. J

    Pasting Excel Data Into Multiple Cells of a Webpage

    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...
  12. C

    Automatic fill and submit web forms from Excel data

    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
  13. D

    Input Data From Excel to Webpage and submit.

    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.
  14. P

    VBA Navigation

    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...
  15. A

    Pivot Table as HTML/Single file webpage with expand/collapse functionality

    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...
  16. P

    Select all and paste (VBA/webpage)

    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 :(
  17. D

    browsing webpage using image tab

    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...
  18. K

    Auto Refresh .mht File??

    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...
  19. E

    Impoerting Data from a webpage

    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...
  20. S

    Macro to download pdf from a webpage

    Hi, i have list of hyperlink in my excel. Each hyperlink will open a webpage. I have to download the webpage as pdf format. Please help me how to run a macro to download all the pdf copy from the webpager after clicking the button.

Some videos you may like

This Week's Hot Topics

Top