 |
 | 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 / October 2006Exit "Here" From Print Preview
One thing I really miss like crazy from my last job was what we called an "Exit Here" Macro If you were in Print Preview viewing page x and you closed Print Preview you wound up on page x This was extremely helpful when working on very long docs If anyone wants to share with me I would really appreciate it Thanks Joan, Here's a message thread that talks about it. http://snipurl.com/10pnr > One thing I really miss like crazy from my last job was what we called an > "Exit Here" Macro [quoted text clipped - 7 lines] > > Thanks  SignatureRuss drsmN0SPAMikleAThotmailD0Tcom.INVALID Thanks Russ I am going to take a look > Joan, > Here's a message thread that talks about it. [quoted text clipped - 11 lines] > > > > Thanks Dim pPageNumber As Long pPageNumber = ActiveDocument.ActiveWindow.ActivePane.Selection.Information(wdActiveEndPageNumber) ActiveDocument.ClosePrintPreview Selection.GoTo What:=wdGoToPage, Which:=wdGoToNext, Name:=pPageNumber > One thing I really miss like crazy from my last job was what we called an > "Exit Here" Macro [quoted text clipped - 8 lines] > > Thanks Thanks I will try it > Dim pPageNumber As Long > [quoted text clipped - 15 lines] > > > > Thanks Got a compile error when it got to this pPageNumber = Thanks > Dim pPageNumber As Long > [quoted text clipped - 15 lines] > > > > Thanks That line and code all the way to the closing parenthesis must be on the same line in the editor. > Got a compile error when it got to this > [quoted text clipped - 22 lines] >>> >>> Thanks SignatureRuss drsmN0SPAMikleAThotmailD0Tcom.INVALID Aha I made some attempts to learn this but couldn't get it at all Thanks > That line and code all the way to the closing parenthesis must be on the > same line in the editor. [quoted text clipped - 25 lines] > >>> > >>> Thanks Code often gets line wrapped in the Newsgroup forums, thereby causing a mistake if taken literally in the VBA editor. Two ways to make learning easier are to hit the F1 function key when the cursor is in a word in the VBA Editor to bring up contextual VBA Help; and to single-step Run through the code using the F8 function key and pausing every once in a while during single-step Run mode to hover the cursor over different words in the code to see if any tooltip info pops up. You can also use Debug windows to watch variables as they change, etc. As you may have noticed when you manually type in code, the VBA Editor will prompt you with choices to make things faster each time you type the full stop or period between words. > Aha > [quoted text clipped - 32 lines] >>>>> >>>>> Thanks SignatureRuss drsmN0SPAMikleAThotmailD0Tcom.INVALID Yes, I did notice how the VBA editor works However, it is like learning a language which is why I have been unsuccessful As a former Word MVP one of the perks was free software and I have a copy of Visual Basic here as well as several books. I get to a certain point and get stuck! > Code often gets line wrapped in the Newsgroup forums, thereby causing a > mistake if taken literally in the VBA editor. [quoted text clipped - 47 lines] > >>>>> > >>>>> Thanks Here's another place with free online learning. http://h30187.www3.hp.com/?mcID=hpsbso1 They will soon reopen a course in basic programming this month. If you sign up and give them your email address they will notify you when a particular course will reopen, if not already available. > Yes, I did notice how the VBA editor works > [quoted text clipped - 57 lines] >>>>>>> >>>>>>> Thanks SignatureRuss drsmN0SPAMikleAThotmailD0Tcom.INVALID |
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.