import data from WebSite

[suzel404]

Hi all,

How can I import data from the Web site : Volatility Index | CryptoIndexes.com ?

Coins , % volatilatility

Thanks for your  help.

[suzel404]

Hi Frank,

Great work !!

I have to kill process MS Excel after reload app to see value updated.

Thanks

[suzel404]

Frank,

Could you please send me again the few line code to automatically reload update data every 2 hours.

I cannot open your last application "save pulldata every 2 hours" because it was your line path and application close with error.

Thanks for your help.

[Frank_Hartmann]

Script:

LET ReloadNo = ReloadNo + 1;

Module:

Sub ReloadDoc

ActiveDocument.Reload

ActiveDocument.Save

End sub

create 3 Variables:

ReloadTrigger = if( (Now() - ReloadTime())*1440 >= ReloadMinutes, Now(), 0)

ReloadNo

ReloadMinutes = 120 (with this variable you specify the minutes, in your case 120)

Settings --> DocProperties -->Triggers--> Variable Event Triggers --> Add action to "Reload Trigger"--> Add--> External--> Run Macro--> MacroName= ReloadDoc

Create an Inputbox with ReloadNo and ReloadMinutes

Create a textbox with this content: ='Time passed since last reload: ' & date(Now() - ReloadTime(), 'hh:mm:ss')

Create another textbox with this content: =ReloadTrigger

Thats it. See attached File