macro to ftp file

G

george_91

New Member
Joined
May 13, 2002
Messages
1
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
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
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
 
Upvote 0
Macro FTP Excel

Dear Colo,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
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:p></o:p>
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:p></o:p>
Your help will be much appreciated :)

Kind Regards,<o:p></o:p>
Wessam Kanj<o:p></o:p>
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question Question
Unable to Open or Copy Corrupted Excel Files on Network Drive
Replies
1
Views
158
Candyman8019
C
F
  • Question Question
Looking for help or guidance on a potential Macro project
Replies
1
Views
60
Rijnsent
Rijnsent
G
  • Question Question
Saving macro-enabled file to G-Drive
Replies
3
Views
245
GreenMan999
G
C
  • Question Question
Create upload file based on order form
Replies
2
Views
127
Christine4711
C
X
  • Solved
How To Consolidate Multiple CSV Files In A Single CSV File Automatically?
2
Replies
16
Views
1K
xlmaniac
X

Forum statistics

Threads
1,223,912
Messages
6,175,341
Members
452,638
Latest member
Oluwabukunmi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top