an*****@station5.net wrote:
Thanks for the reply,
My problem is Telnet, How do I telnet from VBA so that I can execute a
command on a UNIX box.
AJS
pi********@hotmail.com wrote:
Your description of the problem is unclear. Do you mean you can't get
the FTP to work? There's code at Randy Birch's site for that, I'm
sure. www.mvps.org/vbnet just search around. there's TONS of code
there, and I'm positive there's code for doing FTP. As for getting the
server to process the file - not a clue.
Putty is preferrable to telnet if security is an issue. '69 Camaro
provided the following link:
http://www.chiark.greenend.org.uk/~s.../download.html
I'm not sure about the best way to use it from VBA. Adapt the source
code into a DLL? Write an interface that VBA can use to automate
putty? Shell to putty in combination with a command script created by
VBA? Maybe FTP up a file that unix will run later (cron?):
http://groups.google.com/group/comp....776898abd92477
James A. Fortune
CD********@FortuneJames.com
Access Tip:
Use the default property name for a control explicitly instead of
relying on the default for the control implicitly. It's good practice
to put, e.g., .Value in so that if the default for the control changes
in a future version of Access the code will survive the conversion
process providing .Value still exists. Also, note the following
example from "Dao Object Model - The Definitive Reference" by Helen
Feddema (ISBN: 1-56592-435-5 O'Reilly 2000):
"For example, the following two statements appear to be more or less
identical:
strCustomer = rst.Fields("ContactName")
Set fld = rst.Fields("ContactName")
However, the first line uses the default Value property to retrieve the
value of the ContactName field for the current record. The second
line, on the other hand, uses the default Item property to retrieve the
Field object that represents the ContactName column. Changing the
first line of code to:
strCustomer = rst.Fields("ContactName").Value
would remove the ambiguity.
....
For example, the following two statements appear to be more or less
identical:
blnSpecialCustomer = tdf.Properties("Special")
Set prp = tdf.Properties("Special")
However, the first line uses the default Value property to retrieve the
value of the Special user-defined Boolean property. The second line,
on the other hand, uses the default Item property to retrieve the
Property object itself. Changing the first line of code to:
blnSpecialCustomer = tdf.Properties("Special").Value
would remove the ambiguity."