how to gather docs from local network auto..

  • Thread starter Thread starter RompStar
  • Start date Start date
R

RompStar

I am here on a local win xp network, it's an internal network, using
internal IP numbers that don't resolve outside of our work space...


There are about 15 computer here, and each one has a excel spreadsheet
that people fill out, right now I collect that data manually at the end
of the week, but since I know where the excel file resides, always on
desktop and I have access to those local files over the lan, can't
there be a script written to poll that data ?

any examples of this ? on the internet ?
 
The anser is yes, you can write a script (right in the Excel VB editor) that
extracts data from any spreadsheet you have permissions to as long as the
data is in a known worksheet/cell range. For info on how to do this, check
out the microsoft.excel.programming NG.
 
so far I created a folder on each desktop and put the excel file in
there and marked that file as shared...

and I access each folder from my desktop and drag it over to my PC. I
heard that you can sync with a briefcase or something like that, will
have to look into that, writing an Excel VB for that is not an option
right now, no time....
 
Back
Top