Auto update function in VBA?
 

Hello experts,


Can someone advice me how to write an auto-update routine in Excel VBA?
The purpose is that when a button is pressed, the Excel app looks for
updates in a given URL, compares version numbers and downloads the file if a
newer version is found.


Thanks for your help!

Ed van Wijngaarden

Auto update function in VBA?
 

It sounds as if you want to Shell out to an external app.

From VBA help, do a search for the Shell function

As for the external app: I quite like wget
http://www.gnu.org/software/wget/wget.html

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"E.J. van Wijngaarden" wrote in message
...
Hello experts,


Can someone advice me how to write an auto-update routine in Excel VBA?
The purpose is that when a button is pressed, the Excel app looks for
updates in a given URL, compares version numbers and downloads the file if
a
newer version is found.


Thanks for your help!

Ed van Wijngaarden