Pass Text into other application at current cursor position...?

[TWELVE]

Hello,

i'm wondering if it would be possible to insert a text at the current cursor position on the mobile device.Let's say, the user has opened a Pocket Excel and the cursor is on a certain area, e.g. a cell.

Can i then pass text to the cursor input that's not coming from the keyboard..? Or in other word, my application want's to send some text into the text input, to the current cursor position.

If so, how can this be achieved..?

kind regards

TWELVE

 

[Erel]

Maybe you can achieve it by sending keyboard messages to Pocket Excel.
dzt's library should help you: http://www.b4x.com/forum/showthread.php?t=384

 

[dzt]

I confirm, it can be done. Look at post #8

 

[Softselect]

Hi Dzt,
I am trying to send some info to Excel on a desktop aplication, but it does not seem to work. It works for the calculator, but no other program.
can u please have a look and see why the code doesn't work
I think it may have something to do with the name, I have tried "Microsoft Excel" also no go.
I looked in Taskmanager for the application name, is there a better method
Even in the test program the second Desktop Demo button does nothing
I would like to transfer somthing like 12.005 plus a carrage return CHR(13)
taking the cursor to the next cell in Excel
Please note that this is for a desktop application.
I am using dzHW-3 Dll's copied into the samples directory and the library directory, i even tried remove and add object to make sure i am using the correct LIB.
Thanks Friedrich

 

[Softselect]

Hi Dzt
How would i use the following command and analize the result, or am I going the wrong way
r = FindWindowLike(hWnds(), 0, "Microsoft Excel*", "XLMAIN", Null)
Returns: All the windows having window text that begins with "Microsoft Excel" and that contains class name "XLMAIN"
Thanks Friedrich

 

[Softselect]

hi Everyone
I have found that it is directly related to the name
if i use dz.BringWindowToFront("Microsoft Excel - Book1")
then it works
so
how would i use
r = FindWindowLike(hWnds(), 0, "Microsoft Excel*", "XLMAIN", Null)
to find the correct name for the window, when the file name Book1 changes
and
how do I pass enter (chr(13)) i get an error when i try
error= input string was not in correct format
thanks Friedrich

 

[francisco cobos]

I have tried with this and it works:

'(Send WM_SYSKEYDOWN message (260) and ASCII code of Return as wParam)

dz.PostMessageToWindow("Microsoft Excel - Book1", 260, 13, 0)

 

[Softselect]

I have tried with this and it works:

'(Send WM_SYSKEYDOWN message (260) and ASCII code of Return as wParam)

dz.PostMessageToWindow("Microsoft Excel - Book1", 260, 13, 0)

Thank you Francisco,
I have found that if i replace the 13 with a 9 it tabs to the next cell
:sign0060:
greatly apppreciated
Friedrich

 

[Softselect]

Hi Everyone
Here is a commented version of my test program for those who may be interested in passing a string to excel using dzHW-3 library
http://www.b4x.com/forum/additional-libraries/384-useful-library.html
thanks for the help so far
Friedrich

 

[francisco cobos]

Thank you Francisco,
I have found that if i replace the 13 with a 9 it tabs to the next cell
:sign0060:
greatly apppreciated
Friedrich

Hi Friedrich end everyone,
I'm very interested in manage an excel book form a basic4 application too. I would like to send not only characters, but Function keys and combination of keys like-"Ctrl-B" in order to find a text into a book of excel. Someon knows how to preform that?

Thanks in advance