Scrape specific text from a website, and fill it into a cell?

[BrandonBerner]

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: https://www.telus.com/en/bc/mobility/phones/iphone-xs-max?INTCMP=VAN_phones

• Im looking to scrape the Platinum tiered pricing.

I already created a little macro program (not using nerd-code), to automatically go to the link, move the mouse to scroll down to platinum pricing, copy the price, open excel, paste it, and repeat on a 30 min timer. I even added a little bonus so it will send me a text reminder once a change is made in my sheet. All thats left is for the cells to auto-fill after scraping the website. But....I CANT USE MY COMPUTER WHILE ITS WORKING LOL.

Please keep in mind, im still a beginner with random bits of excel knowledge

 

[daverunt]

You could try launching the macro every 30 minutes using Task scheduler. it will still irritate - but only every 30 minutes.



1. A Workbook Open event which calls your macro when the containing workbook is opened.
- This is copied into the ThisWorkbook of the Project

Private Sub Workbook_Open()

Run "MyMacro"

End Sub

2. A BAT File to launch the Workbook.
- content example : start excel "C:\USER\Fred Bloggs\Documents\My_dodgy_Macros.xlsm"

3. Task Scheduler set up to run the BAT file every 30 minutes
- you'll have to work through this one yourself.

4. The workbook needs to be in a 'Trusted Location' so that you won't get the macro enable dialog.
- File->Options->Trust Center->Trust Center Settings->Add New Location

5. Add code to close the workbook at the end of your macro

 

[daverunt]

To set up scheduler Win7 example:

Start/Programs/Accessories/System Tools/Task Scheduler

Create a Task
General Tab - give it a name. Can set to run with highest privileges but shouldn't be necessary.

Triggers Tab -> New
- On a Schedule
- Daily, recur every: 1 days
- Repeat task every 30 minutes, for duration of: indefinitely

Actions Tab - >New
- Start a Program
- Browse to BAT file location

That should do it.
If you set it for every 5 minutes just to see if it works then edit it when you are satisfied.