The following describes how I move members involving
multiple directories to my web sites, when I could use FTP
that is.

-----------------
This is a text file
http://www.mvps.org/dmcritchie/excel/ftpsite.txt
referred to from
http://www.mvps.org/dmcritchie/excel/excel.htm

The following describes how I move members involving
multiple directories to my web sites.  Normally for my Excel
files which does not involve renaming any members I simply copy
them in using WS_FTP LE without the webcopy directory. Use of the
batch file does involve changing the date after use for the next time.

Obtain  WS_FTP LE   (lite version)
   available at  "TUCOWS Download Page
   http://www.tucows.org

UPDATE: download at 
   http://www.ipswitch.com/Support/Versions/index.html 

Select system (Win3x, Win95/98, WinNT)
  I have to use Win3x to use WinNT on AOL dialup
Network Tools
WS-FTP LE  (freeware for individual use)

Full featured version available at  www.ipswitch.com
The full featured version has some automatic things that
can be done, mainly I think, it has drag and drop features.

If simply copying in a few members that do not require substitutions,
WS_FTP LE allows me to sort by RClick on a column.  So by sorting on the
change date I can see which members have been updated recently and copy
them over.

I use a batch file which resides in website named
    kludge.bat as follows:
Some redudant entries are to help prevent accidentally
wiping out all the files on my hard disk when the del is issued.
Look up each switch in DOS help (help del,  help xcopy).

@echo off
d:
cd \
rd webcopy /s /q
md webcopy
md temp
cd \temp
cd \webcopy
del d:\webcopy\*.*  /s  /q
xcopy d:\website\*.*    d:\webcopy\*.* /s /d:04-15-99
xcopy d:\another1\*.*   d:\webcopy\another1\*.*  /s /d:04-15-99

In reality my batch file is a lot more complicated because I have
multiple sources for files and have to change filename to substitute
@, #, and $  in filenames and withinHTML code for members that have
been copied for uploading to website.  UNIX does not allow those characters.

David McRitchie
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
The REXX Macros Toolbox:  http://www.mvps.org/dmcritchie/nclist.htm


Since writing this there are two pages that may be of 
   http://www.mvps.org/dmcritchie/excel/webnofee.htm
   http://www.mvps.org/dmcritchie/excel/backup.htm

------
------

Sender: "Al Bundy" <anonymous@discussions.microsoft.com>
Subject: Ftp an html file generated by an excel macro
Date: Fri, 7 May 2004 13:47:47 -0700
Lines: 42
Message-ID: <a08b01c43474$8e3587a0$a501280a@phx.gbl>
http://groups.google.com/groups?threadm=a08b01c43474%248e3587a0%24a501280a@phx.gbl

Here's an example of what I use to FTP.

---------------------------------------
Sub Shell_FTP()

Dim ff As Integer
ff = FreeFile
Open "C:\login.bat" For Output As #ff
Print #ff, "open fiji"
Print #ff, "userid"
Print #ff, "password"
Print #ff, "put C:\TransferFile" & " /orcl03/admin/data/"
Print #ff, "quit"
Close #ff

Shell "cmd /c ftp -s:C:\login.bat & del C:\login.bat", 
vbHide

MsgBox [E5] & " has been transferred",, "Transfer Complete"
Unload frmLogin

End Sub
--------------------

Hope this helps.... Al
----------
----------