+ Reply to Thread
Results 1 to 5 of 5

Need to place the file in FTP location using macro script

  1. 01-03-2018, 06:08 AM #1
    nathan3
    nathan3 is offline
    Registered User
    Join Date
    02-09-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    11

    Need to place the file in FTP location using macro script

    Hi,

    I need to place the .txt file in FTP location using macro script.

    Please guide us how to proceed.

    Regards,
    Jaganathan D
    Reply With QuoteRegister To Reply
  2. 01-03-2018, 06:10 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,483

    Re: Need to place the file in FTP location using macro script

    Forgive the naive question, but why do you need Excel for this? Would it not be simpler to use an FTP client such as FileZilla?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-03-2018, 10:12 AM #3
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Need to place the file in FTP location using macro script

    Also is the txt file something that is created/saved from Excel (the file in which you have the macro) or is this a file external to Excel? If its external to Excel, why are we using Excel to move the file? How is the txt file related to Excel? Can you manually upload to the FTP site? Does the FTP site support sftp? What port are you using for FTP? Does uploading to ftp require credentials? Is the ftp always available or do you need to test for it before attempting to upload? We really need more information to go on.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me
    Reply With QuoteRegister To Reply
  4. 01-05-2018, 05:21 AM #4
    nathan3
    nathan3 is offline
    Registered User
    Join Date
    02-09-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Need to place the file in FTP location using macro script

    Hi,

    Thanks for your reply.

    We have a tool developed using Macro language. This tool will create a input file in my local desktop. Whereas, I want this macro to place the file in FTP location.

    Kindly help us how to proceed.

    Regards,
    Jagan
    Reply With QuoteRegister To Reply
  5. 01-05-2018, 05:48 AM #5
    nathan3
    nathan3 is offline
    Registered User
    Join Date
    02-09-2012
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Need to place the file in FTP location using macro script

    Hi,

    Thanks for your reply.

    We have a tool developed using Macro language. This tool will create a input file in my local desktop. Whereas, I want this macro to place the file in FTP location.

    Kindly help us how to proceed.

    Regards,
    Jagan
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. script to run the macro from Vb script with out opening the excel file
    By chandanp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2021, 03:33 AM
  2. [SOLVED] Macro to Save Excel File to a SharePoint location and then e-mail that location in Outlook
    By NickyHavey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2016, 09:27 AM
  3. HOW to Place chart at specific cell location with MACRO VBA
    By asmaasab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2015, 08:43 AM
  4. Script to open, search, and insert the hyperlinked location file as a new sheet
    By kurtman1859 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2013, 12:29 PM
  5. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  6. Macro that opens file from location, strips links and saves to new location
    By ahands in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2012, 11:19 AM
  7. insert a photo (any file type), resize it, and place it in a specific location.
    By jaganath in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2010, 08:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1