Upload & Download Excel files via FTP

W

windsurferLA

Physical diversification is now requiring others in my organization to
be able to share an Excel file that tracts action items from their home
computers. It has thousands of records and a multitude of custom macros
that enable the user to rapidly extract historical data, and so it would
be lots of work to reconfigure it for some web base host. My work
around is to store the file on my ROUTHOST.COM server, so each user can
download the file, access or modify, and then upload file with changes.
I realize there is danger of two people making modifications at the same
time, but as there are only four users, I think we can coordinate with
one another.

Myself and another are using Excel'97 under WinXP-pro. Two others are
using Excel from Office2002 under WinXP-pro.

I have found that by rolling down the SaveAs | SaveIn window to show the
Internet Locations, I can set up Excel to retrieve and store (via
replacement) my .xls workbook. Once it is set up, opening the file is
as simple selecting the file from among the recently used files in the
file list, and saving the file merely calls for Control-S. I have also
found that I can write a macro to automatically open a specific file on
the server, and to automatic save that file under another name.

What remains is to implement what I call a ripple-down-save through the
eight older copies. To facilitate recovery from mistakes with this Excel
implementation, using an Auto_Close() macro, I want to be able to throw
away the oldest copy, copy 8, rename copy 7 as copy 8, rename copy 6 as
7, and so on down. The process ends with saving of the current copy as
copy 1. I've used this technique successfully on files saved to C:\.

My current approach to implementing ripple down is to down load version
"N" and save it as version "N+1" . That means that when closing out the
file, the machine will need to down load and upload at least eight
copies of a 4 MByte file, a not insignificant task even with high speed
internet. DOES ANYONE HAVE A BETTER IDEA as to how to accomplish the
same objective?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top