Syncing two different spreadsheets on two different computers

[rolando]

Hey All,

I was wondering how i'd be able to sync two spreadsheets residing in to different computers. I think I would only edit 1 of the spreadsheets but I need the other spreadsheet in the other computer to get the updated cell numbers in a relatively short period of time. I'd say max 1 min but would consider slower systems too. Anyone know the best way to achieve this. Both running Excel 2007.

Thanks in advance.

 

[kdggt1]

Connect thru the Local Area Network. MySheetPath = "\\lan1\Users\user1\path\file.xlsm"
Workbooks.Open (MySheetPath)

 

[rolando]

Hi that's a good idea.But I forgot to mention the two computers are not on a LAN. They would have different IP's.

 

[rolando]

I forgot to mention as maybe it wasn't clear that I cannot close and then reopon the spreadsheet in order to get the updated numbers. So it must sync while the spreadsheet is open.