website

I have a macro that scrapes football results from a website called BetExplorer. It has worked fine for several years, however now the macro gets stuck with the message "Run time error '91' : object variable or with block variable not set" when i press debug, it takes me to this line highlighted...

Hi Is there any way to pull tables from the following website into a google sheet? https://stats.europeantour.com/widgets-v2/stats.html?season=2018&widgetNo=0#tableSGoffTee Have tried IMPORTHTML but with no luck. Thanks

Becoming a regular on here lately! Okay, so I have cell D15 that a user selects a web address from a dropdown list, and clicks the Command button to be taken to that website. I need the selection to go back to default after the the button is clicked and the user is taken to the website. D15 has...

Hi I'm looking for some advice/ help. I'd like to import data (betting odds) from a website into Excel - admittedly I have no idea where to start as I've never attempted anything like this before. Here's what I'm trying to achieve... Source of odds; Oddsportal (http://www.oddsportal.com/)...

I’ve been trying to find a way to change location and date from import web page and wondered if somebody could help please? http://www.realtimetrains.co.uk/search/advanced/RAM/2018/09/26/0000-2359?stp=WVS&show=all&order=wtt The two areas are highlighted in bold and “RAM” I was going to use a...

Hi guys I'm new here and struggling with online form automation. My task is to use this website to generate IBAN codes: https://iban-generator.appspot.com/#/make I have all the necessary data listed in a Database. Done a lot of research and managed to fill the form, but, even though correct, the...

The VBA code I am using is below and it runs without any errors BUT the button to log in doesn't actually get clicked. The HTML Code on the website is here: <form action="/Account/Login" id="loginForm" method="post" role="form"><input name="__RequestVerificationToken" type="hidden"...

Good Morning, I’m hoping that some kind soul out there can help me with a roadblock I’ve encountered in my quest to manipulate a website with VBA. I am using MS Excel 2010 and Internet Explorer 11.0.56. I’m somewhat comfortable with VBA but have never used it to navigate to a website, enter...

Hello guys, i don't know what is happening here. I am working with a vba code in my work and it works fine, but when i try at home some things just don't execute. for example, i go to the website https://www.sew-eurodrive.de/os/dud/?tab=productdata&country=DE&language=en_US I use the...

Hello guys, i really need your help!! I want to get a value from excel and paste inside a website and click a button to get information about this value from excel. I managed to copy value from excel and paste on the website, but i can't click on "Find" button, there is inside a form on this...

I found this macro: https://stackoverflow.com/questions/39222082/vba-to-find-text-from-webpages I did not understand if it is possible to extract all the links of a web page or if it is possible to extract all the links of a website. I would like to extract all the links of the pages of a...

Hey! Google sheets has a function called ImportXML, basically you give a URL and an Xpath and it automatically return that part of the website. It is a great feature however you can only use it for a few cells. My question is that is there a way to achieve this in excel 2016? I know about...

hi all, i want to load some table data from a java script website. i use excel query connection and open the excel browser (think it is a old IE) and answer some scripts error message with "no, do not continue the script" and then the website loading and i close the excel browser and the macro...

HI Guys, I am looking for a VBA solution that will allow me to extract product names, BSR Rank and etc off Amazon website onto a spreadsheet. Any guidance will be appreciated and if you need any specifics of what I require then I will be happy to elaborate. Any help will really be grateful...

Hi Im trying to Scrape data from website using vba. i dont know how to get the element: data-position-num="2" in this html: <a title="Google Docs Resume, Google Docs Resume Template Professional, Creative Google Docs Resume Template, Professional Resume Template Google Docs" class="prolist...

Hi, I am trying to create a programme that will (I) access a website/intranet (noted in cell A1 Sheet1), then download a .pdf file from that website/intranet, (ii) save this pdf to a dedicated folder (C:\Users\Desktop\Files ) with a specific file name then (iii) loop down to the next website...

Hi there, Im inquiring about someway I can have excel scan data in a website one at a time. I may need a program to do do this but here is the premise. I would like Column A full of data such as phone numbers. Then proceed to an external website and have excel send each cell of data as text...

Simple Question. Can I set up a web query to log me onto a website before extracting the information? The issue is every time you go to the website i want to get information from, regardless if you're logged in on another tab it asks me to log in again. So i simply need to web query to...

Hi! I got a question with VBA (bit of a novice) I've written the following code: Sub test() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("secure website") While .Busy Or .readyState <> 4...

Hi All, i need your help... i dont know anything abt macro..but i try to learn. i need a macro script in a way which communicate with a website and do the actions which i want. for example take a gmail webiste. i want the actions like this with the help of excel macro step 1: open the...