Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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,

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File Directory Benz Excel Programming 6 May 19th 07 06:39 PM
file save error: the file or directory cannot be created dublg Excel Discussion (Misc queries) 1 September 25th 06 07:07 PM
Excel should let me sort the file directory when saving a file Beanee70 Excel Discussion (Misc queries) 0 March 14th 06 07:03 AM
Combine all text file in directory into one file. Rich[_19_] Excel Programming 8 January 21st 04 04:09 PM
get path - save new file - same sub-directory as existing file tegger Excel Programming 2 October 21st 03 10:45 AM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"