macro to ftp file

[george_91]

I need a macro to be able to upload an .xls file via FTP to a Unix server. I have created a .bat file that is able to upload the file via DOS command line using standard FTP commands.

The question I have is how do I call my .bat file from an Excel macro?

Thanks,
George

 

[Colo]

Hi,

Assuming the code of bat file is like this...

acb.ftp
open ftp.tripod.co.jp
apple
000000
cd /
prompt
mput "C:aaaacb*.*"
close�@
quit


Please try following code.
If it will not work, try change last 1 to 0.

Shell("FTP.EXE -s:FullPath&abc.ftp",1)


If you want to upload excel file, please check the following link.

Using Microsoft Excel to Save a File to an FTP Site (Q172034)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q172034

 

[wessam kanj]

Macro FTP Excel

Dear Colo,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I've got 7 files on a server(having an IP address,Username & Password) at work that I need to transfer through Macro using FTP all into one Excel file (Each file/Data should be listed on different Tabs in excel).<o></o>
Where if any changes made to the files on the server will be updated by a press of a button on the Excel spread sheet.
Can you please help me out with the way it should be done specifically with the code?<o></o>
Your help will be much appreciated

Kind Regards,<o></o>
Wessam Kanj<o></o>

 

[eakinasila]

How do I set up and use a FTP feed for a online business?I own a small skateboard shop and one of my distributors set me up with their FTP program and I have no clue on how integrate it into a online store and have it work.