Ftp an html file generated by an excel macro
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
-----Original Message-----
I have an excel macro that i'm using with excel 2002.
What it does is
takes all highlighted cells and creates an html file with
a table with
all the selected data and saves it into a specified
location on my
harddrive. Instead of saving it to my harddrive i would
like to send
it to an ftp site I have set up on a linux box. I'm sure
its a simple
process but unfortunatly i can't find the answer.
any input would be appreciated!
-Jim
.
|