FTP CSV file to Lunix Directory

G

Guest

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,
 
A

arno

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top