ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FTP CSV file to Lunix Directory (https://www.excelbanter.com/excel-programming/399424-ftp-csv-file-lunix-directory.html)

Dean P.

FTP CSV file to Lunix Directory
 

I have put together a VBA macro that will create CSV file from the contents
of Sheet1 worksheet. I would like to send this CSV file to a Lunix mount
point directory. Please help me with the process to complete this task.

Thanks,


arno[_2_]

FTP CSV file to Lunix Directory
 
I have put together a VBA macro that will create CSV file from the
contents
of Sheet1 worksheet.


have a macro using saveas.


I would like to send this CSV file to a Lunix mount


if you have a drive letter you can use a path together with the above
mentioned saveas. otherwise you can use ftp to transfer the file wherever
you want (internet...).

in this case you will need a shell command that will start an ftp command.

this ftp-command will require a configuration file for ftp including
username, passwords etc. see ftp-help on every windows pc to solve this.

arno




All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com