I have looked all through tek-tips and all over the web and am having problems creating a simple solution to upload a file to my website. I have VB code inside an Excel module that does multiple things. Saves, prints Adobe files, imports data to Access, e-mails, etc... Now I want to upload a .pdf to my website automatically through FTP.
The directory I want to put everything at is ftp://truthbenefits.com/public_html/Forms. I can obviously fill in my User ID & Password.
Below is a simple Sub routine. Can anyone add the appropriate code to upload the file?
________________________________________________
Sub Upload()
Dim PDF1 As String
PDF1 = "C:\Whatever.pdf"
End Sub
_________________________________________________
The directory I want to put everything at is ftp://truthbenefits.com/public_html/Forms. I can obviously fill in my User ID & Password.
Below is a simple Sub routine. Can anyone add the appropriate code to upload the file?
________________________________________________
Sub Upload()
Dim PDF1 As String
PDF1 = "C:\Whatever.pdf"
End Sub
_________________________________________________
