Synchronising an Excel Document?

[aprisa]

Probably being really dumb, but what is the easiest way to get a document to automatically update to match another on the local network, this is so that a document on another computer will synch with my PDA which is connected to my computer.

I have tried but auto-synch seems unable to read a docoment on a different PC to the one it is connected to.

Nick

[plotloss]

Have a script, thats executed every hour or so that copies the remote file to your PC...

Could easily be done with a batch file thats executed from Windows Task Scheduler...

[slinky]

plotloss said:

Have a script, thats executed every hour or so that copies the remote file to your PC... Could easily be done with a batch file thats executed from Windows Task Scheduler...

batch file like this said:

@echo off copy computerspreadsheet.xls c:somewheretokeepstuffspreadsheet.xls grrrrrrr, can't get proper syntax within forum... but you should kinda get the jist from that, drop me a line if you need to...

Then use scheduled tasks to run the batch file at the regularity which you wish to use...
Then Autosync with your machine..

I'm not sure if there is anyway of directly accessing the PDA (whether it shows up as a removable drive or anything.. if it does you could simply use the batch file to copy it straight to the removable media)..

HTH,

slinky

>> Edited by slinky on Wednesday 1st September 12:40

>> Edited by slinky on Wednesday 1st September 12:41

[Aprisa]

I sort of understand! will try and decipher and tell you if it works, thanks.

Nick

[aprisa]

Nope, too thick!
What do I use to run a batch file? tried command prompt but get message "could not start"

[plotloss]

Yeah get the command prompt up if you can. It could have been disabled by your Admin, if it has search for:

cmd.exe
command.com

and try running one of them.

Then edit myfile.bat

This should give you a dos text editor.

Then enter the text from slink with your path names and file names and then exit.