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

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