website

Hi guys Is there a way to link an excel spreadsheet to a website? Each case I work on has different dates. This tells me how many reports I need to download from a company internal website. When I go on the company website, I select the report and use cute pdf to save this file on the hard...

Hi all, im attempting to use the website https://www.doogal.co.uk/BatchGeocoding.php to take a list of postcodes in column A and either take the results straight from the website and paste into B and C. Or download the csv File and import into the correct columns. Sub geoCode() Dim IE As...

I wonder if there is a way to extract a website address from within a text. noting that : 1- text field contains mix of email addresses and website address 2- email address can be before the website address or after it 3-some cells contain more than a mail address and a website address 4- there...

Hi there, I am trying to export data from a website example: https://www.flashscore.com/baseball/usa/mlb/ When I do, the data pasted from excel is shown vertically and not horizontally as on the website. Is there an easy alternative to get this data from the website to excel in a similar...

Dear All, Kindly need your help. I have a task to extract some data for multiple websites. I found out that it's possible to do with ImportXML in Google Docs. That would be superb but I'm a bit lost how to write the formula. An example, I need to extract the ranking number from the following...

Hi All, I have a VBA code which will open a website. Now i want an information to be copied from the website to the excel sheet. In the website at the top right corner there will be a text with name "Last Refresh" followed by that it will have date and time. I want this to be pasted in the...

Hi I'm trying to automate a log in for a website to put live pricing into excel. I can get it to fill in the username and password but the coding to click the 'Go' button doesn't work. The script for the buttin under 'inspect element' is: <input class="weebutton" type="submit" value="GO!" />...

Hello everyone. Is there a way a macro can scan the websites in column A to see if their website has a blog using "Find on this page" type of function found on browsers? Not by checking the source code. Then in column B next to the corresponding website write "Yes" or "No" Tried to add an...

I have spreadsheet with the following columns: 1. Vendor name 2.website link 3.user 4.password How to write a vba code to log in website and get user/password from cells. Any sample Please. Thank you

Hi, I am really new in htlm coding, how can I ghe ID tag of loging boxes for website when there's no id= and the name is hidden. some the websites are easier to find them as will have like id=username etc but some them no how can find those, much appreciated your help. thank you.

Hi Guys, Tried a lot but I can't figure out how to login on this website. Could someone please help me out ? I want to scrape some data from a website but I couldn't even login with VBA code because it's keep saying "Object doens't support this property or Method" with this code: Sub...

I am using a macro to link data (18,000 rows) to a website for automatic input. I've figured out how to call one line "A3" and it will go to the website, log in, input data and hit submit. I am at a loss how to get it to then input the next row of cells "B3" then hit submit, then C3... etc, I...

Hello I have a spreadsheet which has the URLs, User Ids and Passwords mentioned in columns A, B and C. I wish to put a button against each row, which when clicked, takes me to the URL and logs me into the website using the login Id and password. I searched through various threads but did not...

Hi Guys, i am a newbie on VBA ... so apologies in advance if this is a stupid question I have the following Column A == FEdEX AWB #s Coulum B == Delivery date (Empty) I woul dlike to write a function where it reads the tracking number on Column A and extracts the delivery date from the...

With power query or macro you can extract data from this site: https://www.scholaro.com/ed/Countries I would like to import in a file for each state the following data to be inserted on each sheet with the name of the data type (education system etc.) the following data: 1) the table on the...

Hi all, I'm not very good at Marcos or VBA (I'm sure many say that!) I trying to pull specific data from a website. I would like to do the following: I need to extract data from a website (name of aplace and address) and import it into an excel sheet. The data on the website is not under...

Hi guys, Can I please request your help creating a macro/solution for the following situation: - Column A: list of urls -> for example: website1, website 2, website 3, ... - Column B: ="http://www."&A1 -> http://www.website1.com http://www.website2.com http://www.website3.com - Column C...

Hi, I have a ready csv file to be upload it to the website. I want to upload this file to https://login.xero.com i have the login id and password. can anybody help me how can i do this ? Kind regards, Shaikhstonevilla

My formula in cell A1 says: =HYPERLINK(A2,A3) Cell A2 has the URL Cell A3 has the name of the website. And it works, if I click on cell A1 it opens the internet and my target website appears (-: But my test macro to do that doesn't )-: Sub SelectHyperlinkCell() ' ' SelectHyperlinkCell Macro '...

Hi all! This is my first post on here so go easy on me! I've searched all over the web and in this forum for a solution but I can't seem to find anything explaining what I'm really trying to do. Been stuck on this for a few days so now I'm coming to ask for help! So I have a spreadsheet full of...