excel file 24/7

[eran3185]

Hi
I have an excel filewith web query.
This query refresh every minute.
If my pc is on - the file is refresh every minute.
I want to know ,if there is a way to put this file on a server (maybe free server) or another way. My goal: The file will be regularly updated 24/7 (Not from my pc)

 

[Rijnsent]

Hi Eran,
are you trying to save results from that website e.g. every minute? If so, you'd probably be better off with Google Spreadsheets, https://developers.google.com/apps-script/guides/sheets or https://ctrlq.org/code/19600-reddit-scraper-script
Cheers,
Koen

 

[eran3185]

Tnx.
And if i want to refresh every day, is there a way with ms excel ?

 

[mole999]

as you said you machine, or at least a open excel copy has to be running, if you install it on the server machine that would run when set up, most tend not to have server access. Maybe the google route would be best

 

[Rijnsent]

Hi Eran,
if you want to have the information locally:
-use Google spreadsheets to store the information online, you can use the google spreadsheet scraper code to get that running and create your archive online
-as soon as you open your excel, use VBA to connect to your google spreadsheet (make sure it's shared) and pull in the data: Get Data From Google Docs - Desktop Liberation
In that way you have your data stored (every minute) and have it available if you open your file. Is that what you are looking for?

Koen