Excel VBA automation Windows API and Reflection for regis -


im trying use windows api enter password reflection window pops up. problem can step through code using f8, , see password being entered , ok button pressed.

however, when run code, stops @ point password prompt window pops , cursor blinking waiting input.

what need make work please? have tried adding loop wait pop , tried application.ontime add delay before entering password both dont work.

i dont have experience using windows api, seems way go according colleagues, im communicating application outside excel. there api quirk causing this?

all appreciated.

the api declaration @ top is:

declare function findwindow lib "user32" alias "findwindowa" ( _ byval lpclassname string, _ byval lpwindowname string) long declare function setforegroundwindow lib "user32" ( _ byval hwnd long) long  declare function sendmessage lib "user32" alias "sendmessagea" (byval hwnd long,                                               byval wmsg long, byval wparam long, lparam any) long declare function setactivewindow lib "user32.dll" (byval hwnd long) long  public declare function findwindowex lib "user32" alias "findwindowexa" _ (byval hwnd1 long, _ byval hwnd2 long, _ byval lpsz1 string, _ byval lpsz2 string) long

the password entered popup using function

function enterpassword()  dim hdialog long, htextbox long, hbutton long, hok long  dim hwnd long  const wm_settext = &hc const bm_click = &hf5  hwnd = findwindow(vbnullstring, "reflection secure shell client")  appactivate "reflection secure shell client" htextbox = findwindowex(hwnd, 0, "edit", "") sendmessage htextbox, wm_settext, byval 0, byval password  hok = findwindowex(hwnd, 0, "button", "ok")  setactivewindow hwnd  sendmessage hok, bm_click, byval clng(0), byval clng(0)  end function

in vba editor in excel, have added reference reflections object model, following vba code uses it.

sub changetype()  dim rtcis_session new reflection4.session, long  rtcis_session       .visible = true     .processdatacomm = false     .connectiontype = connect_type     .connectionsettings = "host " & connect_host     .connectionsettings = "username " & connect_username     .connect   'this loop not solve it!'         until findwindow(vbnullstring, "reflection secure shell client") > 0             .wait 2 'wait 2 seconds'         loop          enterpassword  'line below not solve either!'  application.ontime + timevalue("00:00:03"), "enterpassword"


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more