I would like my Excel 2003 macro to upload a file to an FTP site (ID & password required) after it saves the worksheet as a CSV file locally in my C:\Temp directory.
My XP computer does not have the MSINET.ocx control, so please do not post solutions with that.
From my research, it appears that I might have 2 options. But I am not a programmer, so I don't know how to test either option. Can anyone help?
OPTION # 1:
Start with the "WININET.DLL" This is referenced in an interesting website (URL below), but its FtpPutFile function has a Long Integer parameter for the FTP site. I only know the FTP address as a URL!
OPTION # 2:
Script the FTP commands from Excel 2003 VBA. I think this would use Scripting.FileSystemObject object. I think it requires the Microsoft Scripting Runtime control (not sure). But I don't know anything about this.
Any help would be appreciated.