Ftp an html file generated by an excel macro

J

-Jim

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
 
A

Al Bundy

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
 
Top