Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How do I start a Process I can then communicate with from VBA

I have an application in Excel where I execute FTP Commands in a CMD in a
Shell. This requires re-establishing the connection every time I want to
issue a new command.

Is there a way I could start a stand-alone FTP process from Excel/VBA, then
send it commands to be executed from Excel, and finally close it?

Thanks,
Mac
Berkeley, CA


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default How do I start a Process I can then communicate with from VBA

Use VBA to create a .bat file and then exectue the .bat file
--
Gary''s Student - gsnu2007b


"Mac Lingo" wrote:

I have an application in Excel where I execute FTP Commands in a CMD in a
Shell. This requires re-establishing the connection every time I want to
issue a new command.

Is there a way I could start a stand-alone FTP process from Excel/VBA, then
send it commands to be executed from Excel, and finally close it?

Thanks,
Mac
Berkeley, CA



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 735
Default How do I start a Process I can then communicate with from VBA

I am no expert but I would investigate adding a reference to the FTP package
in the VBE and use the exposed objects for the package? I guess it depends
on the FTP package used as to what you can do.



--

Regards,
Nigel




"Mac Lingo" wrote in message
et...
I have an application in Excel where I execute FTP Commands in a CMD in a
Shell. This requires re-establishing the connection every time I want to
issue a new command.

Is there a way I could start a stand-alone FTP process from Excel/VBA,
then send it commands to be executed from Excel, and finally close it?

Thanks,
Mac
Berkeley, CA


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
Shell and Process.Start do not work Philosophaie Excel Programming 1 July 14th 07 10:54 AM
internet connection process at exel start tim Biedermann Setting up and Configuration of Excel 1 October 14th 06 03:53 PM
How to count process running time ( process not finished) miao jie Excel Programming 0 January 13th 05 09:23 AM
How to count process running time ( process not finished) miao jie Excel Programming 2 January 12th 05 06:01 AM
How to communicate between Excel and VB6 ? PM Excel Programming 3 October 28th 04 09:09 PM


All times are GMT +1. The time now is 07:52 AM.

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

About Us

"It's about Microsoft Excel"