ftp

  1. K

    Export list of FTP folders to Excel

    I want to export a list of all folders on our FTP server to Excel. Can I do this and, if so, how?
  2. O

    VBA Code to FTP files

    I have an excel spreadsheet that is currently running VBA and creating .pdf's from different spreadsheets. I would like for those .pdf's to then be FTP up to my webserver in the same VBA. Is that possible? Thanks in advance for any help!
  3. T

    Excel VBA to open a CSV file on an FTP server

    Sorry pretty much a newbie on VBA. Trying to use VBA to open a CSV file on a FTP server with username and password. Server is an IP address. I found the code below on another thread and am confused on the FilePath line and what I put in for "@ftp.XXXXXXX.com/MEMCARD1/FC_files/flow.csv"...
  4. C

    Excel VBA Upload with FTP

    Hello every one! Using Excel VBA I am trying to upload files to a server. In order to do so the macro creates a command-file called 'FTP_batch.txt' and when the subroutine finishes, it kills that file again. When I run the command prompt and copy/ paste the commands from the 'FTP_batch.txt'...
  5. M

    connect to ADODB on FTP server

    I am using a centralized data base on an FTP server that I need to form a connection to from excel to write, update, and pull data. Thus far I can get this to work when the data base in on my local computer, but once it's on the server I can't open the connection with a macro. The following is...
  6. S

    Help with connecting to a secure FTP

    We had a third party programmer which built us a macro that uploads photos to secure FTPS in a module in Excel VBA. He was using PSCP a putty protocol. When initiating the macro it seems as we are able to connect to the FTPS and we get a CMD window that indicates that the files are being pushed...
  7. korhan

    How can I copy a file from a network drive into an FTP location?

    Hi everyone, I am trying to copy all the Excel files in a folder into an FTP location. When I run a simple copy statement with the FTP path, it says "Permission Denied". Can somebody help me?
  8. H

    Downloading files fromftp server

    Dear All, I have to download all files from a ftp server and paste them in a folder in computer my ftp server is: ftp://user:pw@10.128.158.152 (user is user id and pw is password) my destination folder is c:\temp Can anyone tell me how to write a macro for this copy (cut) paste function in...
  9. H

    Opening of csv files from ftp server not working

    Dear All, I have multiple csv files in a local directory in my computer. Using following code, I am able to open each csv file and paste in master excel sheet. However, when I change location from my local directory to ftp server, I am getting this message: Run-time error '52' -Bad file name...
  10. H

    FTP Current Dir Call Crashes Excel

    Hi there, I am building an application that uses wininet ftp calls, all of which are working fine except from my request for the current directory. The following is my (cut down) code... Option Explicit Private Const MAX_PATH = 260 Private Const INTERNET_OPEN_TYPE_PRECONFIG =...
  11. O

    Download data from ftp server not updated

    hi, i am using below code to download data from ftp server , and it work fine , but data not updated , so when i download file if this file updated on the server and i download it again , it will update the file but without new data ( i saw date updated but new data not in the file when i...
  12. O

    ftpgetfile giving unreadable content

    Hi, i have macro to copy excel file from ftp server and save it in local folder and it's working fine but when I try to open the file i get error "Excel found unreadable content" , the file in the server working but when I copy it giving this message :( this is my code Const MAX_PATH = 260...
  13. M

    VBA Open FilePath from FTP location - Excel 2016 error

    Hi, I use Excel 2013 and have some VBA code to open up and copy data from an excel file on a FTP site. It works flawlessly in Excel 2013, however every time I try this on a computer with Excel 2016 the program closes and open a new sheet. I've identified the line of code which causes this to...
  14. M

    VBA - Download from FTP

    Hi I have the code below attached to a button in a macro. This is the code in complete and I have been using it to test taking the information from a file on my computer. This works fine, it all plugs in to the right place - no issue. Now that file is on my ftp server which is user and...
  15. S

    Download Files from FTP server Via Excel Macro

    Hi All, I want to download multiple files from FTP server. I have the log in Credentials of FTP server . Below is the VBA I am using to download files . VBA Code : Sub Get_File_From_FTP() 'Variable Declarion Section Dim FTP As Inet 'Assign Host URL, Source and...
  16. S

    Can I insert data to an excel worksheet stored on an ftp site?

    Hello, I currently have an excel 2010 workbook uploaded to a company ftp site. The goal is to be able to enter data on a locally sourced worksheet and have that data be dynamically referenced by the ftp sheet. I need to be able to transfer cell values from an offline worksheet into specific...
  17. C

    Wininet FTP Error with FTPFindFirstFile 64-Bit Excel

    I've written some code to use wininet to list and then later download a variety of files on an FTP site. When using Microsoft Office 2010 32-bit the code works fine; however, when using Office 2013 64-bit the program returns garbage info in the WIN32_FIND_DATA type. The correct results when...
  18. N

    Excel VBA SFTP without Putty or WinSCP (only standalone excel)

    Hello Members and MVPs, Good Day. I had this specific query that can we do an SFTP with stanalone excel (probably wininet) or other method without the need of external dlls ? I am successfully able to do FTP upload and download via wininte but not SFTP. I usually find almost all solutions...
  19. F

    Unable to use the "Dir" function for a FTP folder with Excel VBA

    Hi, I'm using the "Dir" function to determine if a specified folder exists on my pc locally and if not I create a new one with that name: If Len(Dir(Path, vbDirectory)) = 0 Then MkDir Path End If For example Path = "C:\list\doesthisfolderexist" It is working fine. But now I wanted to use...
  20. E

    Appending files on FTP site using VBA

    Hi, I currently have the following which creates a script and uploads a text file to an FTP site Set TextFile = CreateObject("Scripting.FileSystemObject").CreateTextFile(scriptfile, True) TextFile.writeline "user@mywebsite.co.uk" 'username TextFile.writeline "password!" 'password...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top