Using SendMessage or PostMessage

[azizrasul]

I want to press the keys ALT+R on a Password dialog box of another Excel file either using SendMessage or PostMessage. I have the library functions.
Also any help in entering keystrokes to enter the password in the text box of the Password dialog box would also be useful.

 

[azizrasul]

To add information, I have a Password dialog box with a Password: textbox, a visible 'Read Only' button, an invisible 'OK' button and a visible 'Cancel' button. I want to press the 'Read Only' button.

I have worked out how to get the window handle which gives me a value i.e.

hWnd = FindWindow(vbNullString, "Password")

I guess I need to use the FindWindowEx function to somehow obtain the handle of the 'Read Only' button but I don't know how to do this. I've tried this but it isn't giving me a value.

iHwndChild = FindWindowEx(hWnd, 0&, "Button", vbNullString)

I know I may have to use

Call SendMessage(iHwndChild, BM_CLICK, 0, 0)

When I run these lines of code nothing happens. Any ideas anyone?