web

Hello Friends, I know that i can excel export the web page, But I'm wondering if i can add a slicer (list) and activeX (button) excel export the web page? Work on slicer (list) and activeX (button)? my excel export the web page, But did not work -- slicer (list) and activeX (button) in...

Hi, I have been attempting to automate a web scraping process and I am needing to click a button on the web page; however, my object is constantly empty. Here is the html code: <div class="pull-right"> <button class="btn btn-primary js-export-customer"><span...

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

Sometimes I get an error when getting data from the web. (Either due to lost internet connection or slow internet connections.) The error occurs on Send. if, for example, the website can not be reached, lost internet, or slow internet, I would like to give a message to each scenario. How can I...

Hello I want to implement an online calculator from a webside into an excel document. https://icmphilly.com/ortho-applications/prosthetic-joint-infection-pji-risk-calculator/ I want to be able to set those parameters in the excel document and get the points and the risk from the calculator...

I have built a report in Excel. The report includes a set of web links. I used the following formula to create a link and the link works perfectly in Excel. However, when I convert the Excel report to PDF, the link doesn't work. Any suggestions? =IF(OR(O204="Blind Spot", I204<4)...

Hi, I am looking for below. I want to extract reports from web which is having to username and password. How I can start with? Let me know. Nee

I've a button on a web page that I am trying to click using vba. The button exports the table to excel; it does not have any text but only the excel logo. Below is the html of the button retrieved using the 'inspect element' property of the web page. < a class="x1" tab index="0"...

I have a spreadsheet that imports a web page that I extract data from. Being its a daily refresh the page has older yet duplicate information farther down the page that also imports. I am trying to run a macro that will search for the previous day on the page (=today()-1) in Wed, Apr 10, 2019...

Hi All, I am trying to login to a web page with the help of VBA. But the code isnt working. It take me to the web page but after that it doesnt enters the login credentials. Kindly help Thanks in Advance Dim HTMLDoc As HTMLDocument Dim MyBrowser As InternetExplorer Sub MyGmail() Dim...

I have hyperlinks down column A If I click on any one of them, they work. I would like a macro to select any one of those cells and open the web page. Is this possible?

I have got to be missing something simple here. I have the following code where "1" appears 3 times and "5" appears 1 time in Range("A1:A25")... =COUNTIF(A1:A25,OR(1,5)) Which I would think should return "4", but it is returning "0"... Does anyone have any input? (web searching isn't really...

Hello, I want to get the table containing currency rates from the following web site: www.cbar.az/currency/rates Though Power Query does not return a table, but HTML parts. Is there a way to get the table from the mentioned web site? Best, AH

Hello all, I'm getting "Invalid Query" on .Refresh BackgroundQuery:=False when stepping through the code. Is there a way to import .xls files from the web using querytables? I've seen it done for .csv and I'm trying to adapt that code to xls. Thank you for helping! Sub XLSImport()...

I have done many google searches for trying to change macro web site scraping code from using Internet Explorer as the default web browser to an alternative web browser for scraping data. Unfortunately, all I have found is changing the web browser for hyperlinks in an excel cell. Is there a way...

What is happening when I try to type WP(R) in to a cell and how do I stop this please? Excel WorkbookA1WPSheet1

I have an always open MsExcel file that updates automatically I would need a macro or VB command that publishes an area of this MsExcel sheet on a WEB page (with USER ID and PASSWORD to access) with an interval of 1 minute. Thank you for your precious help. Roberto Giussani

Hi Team, I have the following code that returns data from the web (via Power Query): Application.ScreenUpdating = False If CheckBox1.Value = True Then Sheet3.Range("B4").ListObject.QueryTable.RefreshPeriod = 1 Else...

Hi, I have links in column A in my excel file. They are web addresses and are highlighted blue. When I click them they don't open. Nothing seems to happen. If I right click the link and select "Open Hyperlink" still nothing happens So appreciate anyone's help with this :-D