MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Client Access

Posted by Bob on November 16, 2001 2:18 PM

Anyone ever pass the contents of a cell to IBM's client access
programatically? Via VBA that is?


Posted by Jaime on November 16, 2001 7:41 PM

I have only benn able to come close to it using the sendkey command. It basically just sends keystrokes to an application. It's good for those application that dont offer automation.

This examples opens the notepad from excel, type a message and then saves it.

Sub Send_Keys_Ex()

tadk = Shell("notepad.exe", vbNormalFocus)
SendKeys "Hello. I will same myself.%fa" & Cells(1, 1) & "{ENTER}", True
End Sub

hope this helps