View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Al Bundy Al Bundy is offline
external usenet poster
 
Posts: 5
Default 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
.