PDA

View Full Version : Live data output



nbrown6
01-20-2020, 11:38 AM
Hi all,

I have a little project that i would like some pointers on.

I need to be able to make the data within my spreadsheet available live to anther spreadsheet. The other spreadheet will be in a remote location, so access over the internet.

I was thinking something like an FTP server, but setting this up may be a bit too much. I dont mind using VBA to schedule a regular update, like every minute.

Could someone point me in the right direction of the best way to go about this.

Cheers

SamT
01-20-2020, 01:16 PM
Drop Box, at al

Get two permanent IPs and set up a VPN

Use the WAN at your corporation and shared folders

Office 365 and the Cloud

Upload to a web page each minute

+ 10,000 other ways

The best way requires a budget of several thousand Pounds