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...;en-us;Q172034

[wessam kanj]

Dear Colo,
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).
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?
Your help will be much appreciated

Kind Regards,
Wessam Kanj

[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.