website

Hi All, I'm practicing VBA for a while now as a hobby and I want it to take a stepfurther. I want to extractdata from a website but the first step is login. Do you know howI’m able to login with username and password on the website below? https://login.transporeon.com/login/ Thanks...

Hey there! So im trying to watch for a price drop on a specific phone on a specific website. I want to continue to scrape this page every 30 minutes, and paste the price into a excel sheet or google sheet. Here is the page...

Hi All! I am trying to come up with some code that will 'scrape' a couple of values from a website and save those values into a couple of Excel cells, and possibly autoupdate those cells whenever the website updates those values that were scraped. The site that I am trying to scrape from is...

So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...

Hello all! I want to say thanks in advance, I am a new user of VBA and have exhausted my searching to arrive to this forum board. I am downloading a CSV file with raw data that includes a column with a website in it. My goals are to have a VBA do the following: Turn the text website address...

I have 7 sheets. On each sheet the user can select an item from a list and write a description in the column next to it. The item can be selected multiple times on the same sheet with a different description written in the column next to it. I need a summary page where it lists the entered...

Hello, I want to create a hyperlink to a website from a button in Sheet 1, the address for the website with the required filter details is in Sheet 4, range A14. I have copied the address and it loads the correct details, I cant however find an option to create a hyperlink referencing a cell...

Hi Community Members Is it possible to do a excel vba to automate the following? Initially, I was intending to record a mouse & keyboard movement macro, please advise :) Step1: Open a website URL and login using credentials (Username and Password) daily Step2: Navigate the website via a few...

I am attempting to log into a website in efforts to pull data. The Code I have pasted below, does not work for my application. If I am to change the website to gmail it will run without error. This code will open the log in page, and then errors out at: "Loop Unti oBrowser.readyState =...

Hey Guys and Gals, I am trying to do a bulk upload of products to my website, the suppliers have sent me the entire product range as a CSV, but I only stock a fraction of the products. What I want to do is to copy and paste all the information from them in to my workbook which I have exported...

Hi Everyone, Anybody help me to get a simple VBA code that do the following *Navigate a specified URL *Copy a specified text from the website and paste it into a cell Thank you in advance.

Hi all, i want to read a link to a mp4 file from this website: http://www.4players.de/4players.php/...aming_GPU.html Here is a screenshot where you can see the mp4 File. I use the Firefox inspector, and he show the link? How can i get this link? https://share-your-photo.com/e62e9e98cf I am...

Hi There, I'm doing a project where I regularly have to access www.debtbombshell.com. I would like to cut and paste on to an Excel spreadsheet but the website won't let me highlight. Help!! regards JerryH09

Hi all, i cannot debug this code, i suspect it's not pushing the postcodes into the website but it's giving me precious little feedback as to whats wrong - any ideas? Sub Postcode_Distances() Dim URL As String Dim count As Integer Dim waitCounter As Integer Dim fromCheck As String Dim toCheck...

This is the website: mwatch.boursakuwait.com.kw I uploaded my Excel spreadsheet here: https://ufile.io/gokit it's a stock market portfolio (I'm getting destroyed). I'd like to update the "curr. price" column automatically. The macro should look up each "Code" (Col J:J), retrieve it's...

I have a list of about 8,000 part numbers and I need to search by each part number on a website and then copy and paste over a manufacture part no, manufacturer name, and the description. Here is a short list the part numbers, and the website is...

I am trying to pull the following HTML information from the following webpage (and would hope to duplicate this effort to pull all of the prices on the page): https://www.ebay.com/sch/i.html?_from=R40&_nkw=ralph+lauren&_sacat=1059&LH_TitleDesc=0&_dmd=1&rt=nc How would I do this? I have the...

I'm having an issue attempting to manipulate a website with vba. It is a secure website so I cant post it. I need suggestions i can test or if someone can explain what i'm missing. so far i can open the website & login, no issue & i can click the button to navigate to the search screen, here i...

I amhoping to get some suggestions for what I am trying to accomplish. I amcreating a worksheet for all users in my department. I am looking to create ato-do list section in my worksheet that will include a list of tasks that willbe copied from a website. The user will copy data from this...

Hi All, I'm quite a beginner for VBA coding. But I want to use VBA for getting data from website where my steps are as follows 1. entering website 2. paste username and password 3. change the date to query data 4. click "download excel" 5. copy data from downloaded excel to my worksheet Can...