Need someone's help with this issue...much apprecaited!!

[Shaka215]

Hello fellow programmers!!! Is it possiable to have Excel upload a
workbook to a FTP location (using a username and password) instead of
having to drop and drag to a network drive? I have a request to have
information centralized on a server that can be reached by multiple
locations (using normal webbased FTP is what is planned)...I have
figured out how to pull the information using a macro but I haven't
been so lucky in trying to have the information resubmitted. Thanks and
any advice / suggestions are much appreciated!

 

[Guest]

Have you looked into Excel Services yet? Here is a link:
http://msdn2.microsoft.com/en-us/library/ms519581.aspx and here is a link to
a Microsoft Excel Services blogger: http://blogs.msdn.com/cumgranosalis/

Excel Services still in Beta, but it sounds like it might work for you. I
just going off of things I've read, but no point doing a lot of work if
Microsoft is close to providing you a solution.

Good luck,

Kim Greenlee