I was enlighted by the following post and I was able to accomplish what I need
to get done.

http://www.webmasterworld.com/forum10/5090.htm

I would appreciate if you could also enlighten me on how to accomplish the FPT
in VBA and VBScript. I am familiar with FileObjectSystem but have little idea of
networking.

1. I just need to get Excel files from FPT address to local hard drive.
2. I don't have the "home" server mapped to a local drive.