CVByrne Posted July 19, 2012 Share Posted July 19, 2012 Right, I'm a bit baffled by this legacy system. I'm reverse engineering a macro that has MyScreen.SendKeys "" works fine as does and but nothing else works, even using {} or <> I can't understand why only three commands work. As I said it's a legacy system I'm sending keys to using excel 2003 Link to comment Share on other sites More sharing options...
TheDon Posted July 19, 2012 Share Posted July 19, 2012 What keys are you trying to send? MyScreen.SendKeys "any string of text" should work if you just want to send plain text. Link to comment Share on other sites More sharing options...
CVByrne Posted July 19, 2012 Author Share Posted July 19, 2012 I was action keys. I was trying to send Shift+Tab to move back up fields to the beginning of the legacy system page and tried everything. I used putstring and row column references instead but I needed to manually map where each field was and it was a bit time consuming. But it got the job done. Link to comment Share on other sites More sharing options...
TheDon Posted July 19, 2012 Share Posted July 19, 2012 +{TAB} should have worked for that, but then you say works when it should have been {Enter}, so I dunno what's up there! At least you've got it working. I hate vba with a passion. Link to comment Share on other sites More sharing options...
CVByrne Posted July 20, 2012 Author Share Posted July 20, 2012 Yeah it was baffling, only <> worked for three commands and none of the {} or worked at all. Was doing my head in. Agree on hating vb. Unfortunately the financial addin we use is in excel and so we're stuck with it. Link to comment Share on other sites More sharing options...
leviramsey Posted July 20, 2012 VT Supporter Share Posted July 20, 2012 It absolutely boggles the mind that trading desks at banks use Excel. (though I suppose that it explains various events of recent years...) ((and it may also explain some of the alpha earned by hedge funds...)) Link to comment Share on other sites More sharing options...
limpid Posted July 20, 2012 Administrator Share Posted July 20, 2012 I'm a geek and I have no idea what the OP means. Should I move this to off topic? Link to comment Share on other sites More sharing options...
CVByrne Posted July 20, 2012 Author Share Posted July 20, 2012 Levi I'm currently consulting the the British taxpayers own RBS. Link to comment Share on other sites More sharing options...
cheltenham_villa Posted July 20, 2012 Share Posted July 20, 2012 as someone who makes a pretty reasonable living developing excel vba applications for a pretty major bank im not going to complain to greatly. Have you got anything you can send me, ill have a look for you if you're still struggling. Link to comment Share on other sites More sharing options...
cheltenham_villa Posted July 20, 2012 Share Posted July 20, 2012 just read rest of the post, realised its resolved. Personally avoid send keys anyway, either causes issues if the pc is locked, also becomes a problem if users decide to flick between applications while the macro is processing. Link to comment Share on other sites More sharing options...
Recommended Posts