ftp

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

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

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

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

Hello everyone, I have been using an Excel file with a VBA macro to save and upload multiple files to three different FTP sites daily. It has been working for a few months, but I recently hit a snag with 1 of my 3 FTP servers. It seems to be freezing after the "put" command. The prompt...

Hi All. I'm trying to create a macro that will upoad a .csv file to a folder on my website. I found loads of different version of code to do this and I can't get any of them to work. I admit right here that I am only as much of an expert in this as Googling for 4 hours can make you... so not...

Hello all. As always, thanks for this repository of knowledge and experience. I manage a growing retail firm that has recently expanded from a single-location to two locations and a separate warehouse. Initally I was tasked with developing a Point of Sale system that would track our inventory...

I need to build a macro to FTP and download some files on a site (I have userid and password) to my computer. Is there a way to do this? There are specific files that I want to download, for example, fileA, fileB, fileC, etc. These files will be placed in my c:\folder1\subfolder2\...

As a novice, I spent many days and searching to accomplish automating this process to run on a remote computer Monday through Friday using the Windows Task Scheduler and I want to share. The process involved the tasks below: <?xml:namespace prefix = o ns =...

I have made a user-form from where i can select a file. Now i want to move the file a remote location but when i put my ftp location i get an error of path not found whereas when i put a location of my machine the file gets transferred. Plz help.

Hi All, I want to export data from Excel 2007 worksheet to i Series. Can I build an ODBC connection? Is there an option for creating a macro which will FTP data to iSeries server? Please advise. Thanks in advance.

Hello, Panel. Does anybody have a line on where I could learn how to write code for an FTP upload in VBA? Thanks.

Hi, I want to connect to FTP server using macro and get the file in specified location which i am unable to do...can any1 in this forum help me out doing this.... Thanks Amar

Hello everyone, I am creating and saving an XML file on my hard drive and then having to move the file/s (or the folder) to my webserver by using Filezilla. Is there a way to move this as part of my VB code while creating and saving the xml file in my code? My hard drive (c:) folder ...

After reading the end of chapter 14 in the VBA and Macros for Microsoft Excel I found the article on using Ken Andersons WCL_FTP utility, however I am unable to find a download anywhere on the net to this as pacific internet site does not have it hosted anymore. I also found an update to the...

I have a table of inventory. Colors down the size, Sizes across the top. I'm trying to create a macro that "prepares" the table in a certain way; so I can then make a GIF or JPG out of it, and post it on my Ebay listings online to show a (perhaps even real-ish time) image of my inventory...