Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script for FTP used in excel
I need to send a txt file to a remote FTP site, what should be written in the
VB Script? I will create an icon for user to start the sending job. Please help Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script for FTP used in excel
you could use the Shell command to execute the FTP program from the VBA
code. The parameters for the external programme could also be supplied e.g. result = Shell("C:\windows\ftp .exe 'program commands here ", 0) -- Cheers Nigel "ak" wrote in message ... I need to send a txt file to a remote FTP site, what should be written in the VB Script? I will create an icon for user to start the sending job. Please help Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script for FTP used in excel
Thanks Nigel
Is there any FTP command/function in VB that can use? "Nigel" wrote: you could use the Shell command to execute the FTP program from the VBA code. The parameters for the external programme could also be supplied e.g. result = Shell("C:\windows\ftp .exe 'program commands here ", 0) -- Cheers Nigel "ak" wrote in message ... I need to send a txt file to a remote FTP site, what should be written in the VB Script? I will create an icon for user to start the sending job. Please help Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script for FTP used in excel
AFAIK you cannot do this from within VBA. Shell the external programme
would be my choice, especially if you can develop a log on / send script within the FTP programme, e.g. CuteFTP -- Cheers Nigel "ak" wrote in message ... Thanks Nigel Is there any FTP command/function in VB that can use? "Nigel" wrote: you could use the Shell command to execute the FTP program from the VBA code. The parameters for the external programme could also be supplied e.g. result = Shell("C:\windows\ftp .exe 'program commands here ", 0) -- Cheers Nigel "ak" wrote in message ... I need to send a txt file to a remote FTP site, what should be written in the VB Script? I will create an icon for user to start the sending job. Please help Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with EXCEL SCRIPT | Excel Discussion (Misc queries) | |||
help with EXCEL SCRIPT | Excel Discussion (Misc queries) | |||
help with EXCEL SCRIPT | Excel Discussion (Misc queries) | |||
Excel 2000/XP script to Excel97 script | Excel Programming | |||
VBA Script in Excel | Excel Programming |