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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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:eek:ffice:eek:ffice" /><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

X
  • Solved
How To Consolidate Multiple CSV Files In A Single CSV File Automatically?
2
Replies
16
Views
736
xlmaniac
X
J
  • Question
VBS Script to Cross Reference Txt File and Output New Txt File
Replies
7
Views
376
rpaulson
rpaulson
N
  • Question
Unable to receive the file from FTP
Replies
0
Views
299
nasserho
N
Z
  • Question
I need VBA code to upload to FTP in Mac OS
Replies
0
Views
518
Zubair2icy
Z
C
  • Question
Download multiple files from FTP server with VBA/Macros in Excel
Replies
1
Views
2K
John_w
J

Forum statistics

Threads
1,215,388
Messages
6,124,658
Members
449,177
Latest member
Sousanna Aristiadou

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