 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / November 2005How macro can do printscrn of other application and paste in word
I am trying to create a macro in word to do a printscreen in toad and paste it in word. Is it possible to get the events of toad application captured in word macro. Thanks I'm not sure if I can help you but ... It is possible (I think) with SendKeys to do an Alt+PrintScreen and then Paste the clipboard into Word but is that what you want? Or are you trying to drive Toad from Word? And then get records returned to Word (rather than just an image)? -- Enjoy, Tony > I am trying to create a macro in word to do a printscreen in toad and paste > it in word. Is it possible to get the events of toad application captured in > word macro. > > Thanks Tony, I think you have the answer to my question. Actually word should work as a background process, because whenever I do ALT+printscreen, it should automatically paste it in word. One more thing can you tell me how sendkeys can be worked. Thanks > I'm not sure if I can help you but ... > [quoted text clipped - 15 lines] > > > > Thanks Easiest way is to look at the help for SendKeys in the VBE, but .. You can't have Word as a background process - it won't respond to anything you do in Toad (or Windows). AFAIK there is no way to make a printscreen be automatically pasted anywhere in any application. -- Enjoy, Tony > Tony, I think you have the answer to my question. Actually word should work > as a background process, because whenever I do ALT+printscreen, it should [quoted text clipped - 23 lines] > > > > > > Thanks Hi Tony, Look at http://msdn.microsoft.com/library/en-us/script56/html/wsmthsendkeys.asp?frame=true In a note it says "Note You cannot send the PRINT SCREEN key {PRTSC} to an application." I interpret this as to say that it cannot be sent. I have tried it and it did not work, although I may have done something wrong. Jerry Bodoff > Easiest way is to look at the help for SendKeys in the VBE, but .. > [quoted text clipped - 36 lines] > > > > > > > > Thanks Sorry, Jerry, It is possible to get round this restriction. I can't remember where I picked this up from (and I have a feeling there is something odd about it) but you can use ... WordBasic.SendKeys "{prtsc}" -- Enjoy, Tony > Hi Tony, > > Look at http://msdn.microsoft.com/library/en-us/script56/html/wsmthsendkeys.asp?fram e=true > In a note it says "Note You cannot send the PRINT SCREEN key {PRTSC} to an > application." [quoted text clipped - 48 lines] > > > > > > > > > > Thanks Hi Tony, Thanks. I totally forgot about checking WordBasic. I wonder why Microsoft chose to eliminate from VBA functions that WordBasic could handle. When I did my test I did it under VBA. I am going to try it again with WordBasic. I have an application in which this would simplify things. Jerry Bodoff > Sorry, Jerry, > [quoted text clipped - 11 lines] > > > > Look at http://msdn.microsoft.com/library/en-us/script56/html/wsmthsendkeys.asp?fram > e=true > > [quoted text clipped - 52 lines] > > > > > > > > > > > > Thanks Hi Tony, Thanks. I totally forgot about WordBasic. I did my test under VBA. I tried doing this with the WordBasic version and it works great. I wonder why Microsoft eliminated some WordBasic functions in VBA. Jerry Bodoff > Sorry, Jerry, > [quoted text clipped - 11 lines] > > > > Look at http://msdn.microsoft.com/library/en-us/script56/html/wsmthsendkeys.asp?fram > e=true > > [quoted text clipped - 52 lines] > > > > > > > > > > > > Thanks Hi, I think being in toad if we do a printscreen or ALT+printscreen, it is copied and will be available in the clipboard, if we could trap whether the user has pressed ALT+printscreen on the keyboard being in toad application, then we can activate the word and do a selection.paste there and then again show the user the toad screen. is it possible like this. Thanks > Hi Tony, > [quoted text clipped - 88 lines] > > > > > > > > > > > > > > Thanks It has been some years since I used Toad but i do not believe it has that kind of capacity (does it have any kind of code interface at all?) and I'm pretty sure Word has no capacity to listen in the background. I have no doubt that some sort of Windows application could be written for this but don't have any idea how to go about it. The best I could come up with would be a one-click-in-Word solution so that instead of pressing printscreen you would have to switch to Word and press a button - and this would be on the lines already discused here just attached to a toolbar button in Word. -- Enjoy, Tony > Hi, > [quoted text clipped - 33 lines] > > > > > > > > Look at http://msdn.microsoft.com/library/en-us/script56/html/wsmthsendkeys.asp?fram > > > e=true > > > > [quoted text clipped - 61 lines] > > > > > > > > > > > > > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.