Printing Range of Pages prints in a 20 page document, prints it 20 times

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - SharePoint
  - Game
  - VS 2008
  - Smart Device
  - Windows Live
  - Visual C#
  - VS Express
  - Windows Vista
  - Visual Studio
  - Dotnet
  - VB
  - Windows Forms
  - VFP
  - Architecture
  - SQL Server
  - Office
  - ISV
  - IE
  - VC++

- Previous
  - 1
    - How to Import a .msg and .pst file into Outlook 2007 with C# code? A .pst file and an Exchange mailbox are two completely separate types of data stores. Thus, there is no concept of storing a pst in a mailbox folder. Maybe you could provide more information on just what you're trying to do with this .pst file. Are you trying to move the data that the .pst file contains into corresponding folders in the Exchange mailbox Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 2
    - Error - InfoPath cannot open the selected form Same error occurred in my VSTO SE environment, what's wrong with it thanks a lot. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 3
    - Multiple windows I've got an odd issue that I'm uncertain how to resolve. I'm running VSTO 2005SE with Office 2K3. I've added buttons to the toolbars that open windows. The odd thing is that when I click the button, it opens as many windows as there are powerpoint instances. I have no idea why a click in one instance causes the event to be run in all. I've tried setting it so that it checks to see if the window already exists but because they're being opened by separate instances, this does not work. Any recommendations would be appreciated. Thanks Denis --- www.21square.com Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 4
    - NamedRanges in Excel 2007 with VSTO SE Thank you both! Here is the C# code in case it is helpful for someone else: Code Snippet private Worksheet _sheet = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet; //create a named range Range myRg = _sheet.get_Range("A1", "C3"); Name myName = _sheet.Names.Add("MyNameRange", myRg,true,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing); MessageBox.Show(myName.Name+": "+myName.RefersTo.ToString()); //enumerate sheet names string names = "There are "+_sheet.Names.Count+ " names: "; IEnumerator en = _sheet.Names.GetEnumerator(); while (en.MoveNext()){ object nameObj = en.Current; Name name = nameObj as Name; if (name != null) names += name.Name; } MessageBox.Show(names); //get a range for a given name Name rgName = _sheet.Names.Item("MyNameRange", Type.Missing, Type.Missing); Range hr = rgName.RefersToRange; hr.Value2 = 1; //another way of getting the named range hr = _sheet.get_Range("MyNameRange", Type.Missing); hr.Value2 = 2; Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 5
    - MAPI.SessionClass in Outlook 2007 Hi, Previously, I work with Outlook 2003 and install CDO in my machine. This code snippet was work in Outlook 2003. MAPI.SessionClass session = new MAPI.SessionClass(); session.Logon("", "", false, false, Type.Missing, Type.Missing, Type.Missing); session.Logoff(); Recently, I upgrade to Outlook 2007 and found out that MAPI was not in Outlook 2007 anymore, may I know how to replace the code snippet above using Outllok 2007 API. Regards Kendy Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 6
    - Outlook Appointments In that case, use the Namespace.GetSharedDefaultFolder method to return the other user's folder, then use the MAPIFolder.Items.Add method to create the appointment in that folder. See http://www.outlookcode.com/codedetail.aspx id=405 for a code sample. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 7
    - Add TaskPanes in Office 2003 Hi, I spend last day trying to find a solution to add customs taskpanes in office 2003, Is this possible I'm using vsto 2005. I founded that office 2007 has the CustomTaskPane property....but for office 2003 didn't find nothing. Bye, Pedro Rocha Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 8
    - Support for multiple columns in Form Region controls Well, for Orcas Beta 2 you can expect support for managed form regions based on OFS files, so that would bring back olk* controls (but no Windows Forms + olk controls in the same region though). If question is strictly referring to VSTO 2005 SE then yes, no support for Windows Forms controls in Outlook Form Regions. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 9
    - WindowActivate not being called Hi Jennifer, I test it in Word 2007 Add-in developed by Visual Studio SE, no problem exists. If I open document from Website in a new instance of Word, the WindowActive event will be raised. It seems you are working on Word 2003, right I will try to find some test machine with Office 2003 to do another test. By the way, I think the Startup event will always be triggered. We can add our custom button both in Startup and WindowActive event. However every time we add the button, we should have a test if the button is already existed. My codes are like these: Code Snippet Office. CommandBar cb = null ; Office. CommandBarButton btn = null ; int btnID = -1; private void ThisAddIn_Startup( object sender, System. EventArgs e) { AddMenu(); this .Application.WindowActivate += new Microsoft.Office.Interop.Word. ApplicationEvents4_WindowActivateEventHandler (Application_WindowActivate); } void Application_WindowActivate(Microsoft.Office.Interop.Word. Document Doc, Microsoft.Office.Interop.Word. Window Wn) { AddMenu(); } bool AddMenu() { foreach (Office. CommandBar cmb in this .Application.CommandBars) { if (cmb.Name == "Test" ) { foreach (Office. CommandBarControl control in cmb.Controls) { if (control.Id == btnID) return false ; } } } cb = this .Application.CommandBars.Add( "Test" , Office. MsoBarPosition .msoBarTop, false , true ); cb.Visible = true ; btn = cb.Controls.Add(Office. MsoControlType .msoControlButton, missing, missing, missing, true ) as Office. CommandBarButton ; btn.Caption = "Test" ; btn.Tag = "Test" ; btn.Style = Microsoft.Office.Core. MsoButtonStyle .msoButtonCaption; btn.Click += new Microsoft.Office.Core. _CommandBarButtonEvents_ClickEventHandler (btn_Click); btnID = btn.Id; return true ; } void btn_Click(Microsoft.Office.Core. CommandBarButton Ctrl, ref bool CancelDefault) { MessageBox .Show( "Hello World" ); } Thanks Ji Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 10
    - building outlook toolbar in contacts No, a toolbar added to the Explorer window appears on the main Outlook window. The Inspector holds all toolbars for individual item windows. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 11
    - Before an Appointment item is saved, how can I get the occurrences specified by the recurrence pattern? Here's one idea: Your dt variable's value is built from just the date, not the date plus the time. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 12
    - Outlook 2007 RTM FormRegion & InfoPath control Thanks for your reply (sorry I didn't see it sooner). The basic form region is made up of the standard to, cc, subject, and message fields and then an InfoPath control at the bottom. The form region is a "replacement" form as opposed to a partial region that exists in another form. Using the simplest repro method, have the add-in cause the InfoPath control to create a new form using a template (we open a File Open dialog to get the template but you can hard-code it for your tests). Once the form region (as its own form since it is a replacement form region) is open, you can tab to all of the controls except the InfoPath control. You can click (with a mouse) into a field in the InfoPath control, but if you press tab, you will leave the control and go to the next Outlook field. I believe you should be able to tab into the InfoPath control and then remain there until you click out of it (in other words, the InfoPath control should process all keys while it has focus). Let me know if you need more information. Pete Loveall Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 13
    - Conditionally create multiple MS Word documents based on a single, master MS Word doc? I want to conditionally create multiple MS Word documents based on the same master MS Word document. Example: I have a single MS Word document with say 100 sections. I want to create 4 different MS Word documents, which include a different subset of the sections from the master document. I know I can do this today by manually copying and pasting, but this is error prone and time consuming. I am looking for a solution where I can somehow tag the different sections in the master document and then somehow provide a parameter value which indicates which sections (based on their associated tags) should be stripped and which should be kept in the resultant document. I experimented with the MS WORD mail merge feature - but it's insuffience to archieve the above result. Please let me know if the above can be achieved with the vanilla MS WORD product, and if not what commerical Word add-ons do you recommend Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 14
    - VSTO 2005 and VS 2005 Pro - how to get all features of both Sorry if the answer is already out there and obvious but I can't find it and need to make a purchasing decision: I'm using VS 2005 Team Suite Trial Edition. I don't need all that this version has to offer. Basically I want VS 2005 Pro with full VSTO capabilities. I understand that VSTO SE will help but doesn't offer full capabilities. I also need the capabilities in VS 2005 Pro that aren't in the VSTO version. From a purchasing standpoint the most cost effective way to go seems to be to buy VS Pro with MSDN Pro subscription to get both. Does this make sense Thanks in advance for your information. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 15
    - outlook toolbar in sent messages Hi all, i have created a toolbar that loads a commandbar into outlook when it loads, using Code Snippet Office.CommandBar newToolBar; Office.CommandBars cBars =this.Application.ActiveExplorer().CommandBars; newToolBar = cBars.Add("myBar", Office.MsoBarPosition.msoBarTop, false, true); (with some other stuff), and it loads into the main outlook screen fine.... However, I would like to have these buttons in the toolbar when I open up a message. i.e. open outlook, open a message, press toolbar button. HOw do I install the button/toolbar into that screen thanks michal Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 16
    - Creating a formatted Microsoft excel file. VSTO is not an API for creating Office files. VSTO is a tool to build applications targeting Office 2007, creating add-ins or document customiztions. It's is not a means of automating Office applications. For discussions relating to automating office applications and documents via .NET see http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.officedev&lang=en&cr=US Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
- Next
  - 1
    - Disable VSTO toolbar when cell is being edited It's not possible to track when Excel goes into edit mode and it's not possible to execute any code when Excel is in edit mode, I believe that the closest solution is to use the Worksheet_Change event where You check if the active cell is within the Target address, If so the code should disable the wanted buttons. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 2
    - Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Bill, Yes I agree, they really need to clear that up, and/or provide direct links to the appropriate download locations. Since I do a lot of C++ development, that is the only reason I knew the answer to the question ... but even still, I had to read that section a couple times to even understand what it was they were trying to get us to do, exactly. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 3
    - How to store meta-data in Outlook 2007 I am developing an Outlook plug in where I have to store meta-data in Outlook for the customizations user does. How to store meta-data in Outlook without persisting to the user (and) without storing in different file(like xml file) I did research on table object. But, I think it doesn't help me out because it is read only object. Please let me know if u have any ideas I am using VSTO SE/ Outlook2007 /VS 2005/C# Thanks, Rama Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 4
    - A strange problem in retrieving a file path and creating a button in Word Good news!! I finally managed to to it!!! thanks! Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 5
    - Word automation from a Web Service I am working now on a project to automate Word report generation from a web service using VSTO and .NET remoting. There doesn't seem to be any reason why you can't automate this right now using VSTO 2005 since you can generate word docs on the server without having to start an instance of word or even having office installed. Though I'm still finalizing the proof of concept for this, what I'm doing is using a web service to invoke a remote VSTO object, passing in some report criteria, and then having the server hosting my VSTO project generate my word docs. These docs are regular, backward-compatible word doc files populated with data from SQL on the fly. HTH Brian Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 6
    - Deployment path setting Hello, I've developed an addin for Word 2007 using VSTO 2005 SE. For the setup file, I'm using the default setup file when I created the project. My question is, how can I set a default installation folder for my addin For example:- When the setup file launched, I want to make the *.msi file to automatically install the addin to a predefined folder. It means that no user interaction required, no need to choose an installation path and no clicking needed. Just a direct installation like the MS Office 2007 PIA msi setup file. Can it be done Hope someone can help me about this. Regards, Westman Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 7
    - Adding images to home-made context menus By the way, how can I deal with transparency My images have been created with Photoshop, and they have a transparent backgroup. I've saved them as a .png. When I affect them to a button in a ribbon, the transparency works, but when I affect them to a context menu item, I've got an awfull blue background instead of a transparent one. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 8
    - Adding a large amount of contacts I've hit a road block. I am writing a .NET Outlook (2003) plugin to update my users contacts from a database that our clients update. I have managed to get the plugin button up, and clicking on the button gets the contacts and starts adding them. However, the code has added the 249th contact item, I start getting First Chance exceptions. Is there some kind of restriction that stops me from adding more contacts This is a huge issue for new users in the group, becuase we have over 5000 email address that need to be pushed out to the Contacts Folder. Here is my code for adding the contacts. Please tell me if I am doing something wrong or if there is a restriction: foreach ( DataRow dr in dt.Rows) { try { Outlook. ContactItem ci = (Outlook. ContactItem )newcontacts.Items.Add( Outlook. OlItemType .olContactItem); ci.CompanyName = dr[ "CustomerName" ].ToString(); ci.FullName = dr[ "ContactName" ].ToString(); ci.CustomerID = dr[ "CustomerNumber" ].ToString(); if (dr[ "ContactNumber" ].ToString() != "" ) ci.BusinessTelephoneNumber = dr[ "ContactNumber" ].ToString(); ci.Email1Address = dr[ "ContactEmail" ].ToString(); ci.Save(); } catch ( Exception ex) { Console .WriteLine(ex.ToString()); } Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 9
    - Attaching custom actions Pane to all documents !!! Hi All, After reading quite a few posts and trying out various shortcuts or hacks to acheive an " Application Level Task Pane " for Word 2003, i have really come to a grinding halt !! few of the paths that i followed were 1. Tried to modify the XML of a WORD document by adding the _AssembleName=* and _AssemblyLocation custom document properties.... I am now trying to acheive this by Attaching Managed Code Extensions to Documents...still work in progress i guess my question would be that in one of these posts Misha Shneerson did point out that it was possible to attach a task pane at an Application level but could only be acheived by someone like her who knows the internals of ActionsPane and VSTO and that it wasnt for the *****Faint Hearted***** .... still trying to locate that post... so if any one could point me in the right direction or suggest an alternative, that would be great !!! I know that Custom Task panes are possible in word 12/ 2007... but i def. require to achieve this with word 2003 / Office Pro edition... as our target audience is not likely to move to office 2007 for quite some time !!! If i haven't been clear please do ask for clarifications !!! tha, koms Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 10
    - Convert a selection and convert it to rtf You might check whether AltSoft has one. They do for WordML to PDF, for example. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 11
    - ComboBox on an Outlook PropertyPage doesn't seem to get DrawItem events Hi Ben, Strange! In my side, both in Winform application and Outlook PropertyPage , the callback function of DrawItem can be reached. I just test using a MessageBox.Show() in the comboBox1_DrawItem() method. Once I manipulate the ComboBox in runtime, a MessageBox pops up for several times according to the Items�� Count of ComboBox. The only difference is I add the Items in design time, not set its DataSource in runtime. So I think problem may exists in where we set DataSource. Can you post more codes about that Also, there is a good example to show how to create comboBox with Image, refer this link please: http://www.codeproject.com/cs/miscctrl/ImageComboBoxControl.asp Hope this information can help! Thanks Ji Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 12
    - ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Richard / Douglas, Thank you both very much for your help. I re-installed VSTO Runtime (and .NET 2.0 Fx) on my machine and this seemed to fix the problem (magically) :-) I apologize for the late reply - I had expected that I would be "alerted" when someone responded to my post but that never happened. Lesson Learned - keep checking the post. Okay, now I have the ApplicationManifestEditor working. However, I am trying to find a more "transparent" way of migrating the older document (created with the VSTO 2003 solution). Here's what I envision 1. User opens the Older Document 2. *Somehow* I intercept the document before the OTKLOADR checks it for customization 3. Once intercepted, I check to see if it is referencing the VSTO 2003 solution, 4. If true (i.e. it is using VSTO 2003 solution) --- I modify the custom properties of the document to point to the VSTO 2005 solution (using the ApplicationManifestEditor methodology) 4a I close the document, and re-open it. (This time the VSTOLoader instead of the OTKLOADR will link the document to the automation assembly) 5. Else - Do Nothing. The fuzzy part is step 2. To do this, I thought I could potentially use a Excel Add-In which loads when EXCEL.EXE Starts up. (I.e. - an XLA that is loaded into the XLSTART folder). Do you think this would work Or am I way off, and simply clueless I really appreciate your guidance. Thanks, Tim Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 13
    - Support for multiple columns in Form Region controls Well, for Orcas Beta 2 you can expect support for managed form regions based on OFS files, so that would bring back olk* controls (but no Windows Forms + olk controls in the same region though). If question is strictly referring to VSTO 2005 SE then yes, no support for Windows Forms controls in Outlook Form Regions. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 14
    - Error when trying to install ClickOnce Application Oops! My bad, sorry... Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 15
    - Unlocking a project... with the exception of the microsoft.public.excel.programming websites). [/quoute] What's wrong with that forum ...use in Excel, I thought this might be the place to ask that question because this is 'Tools for Office'... right Wrong About your opinion: Regardles of the fact that I agree with you on the 'code of ethics', I didn't ask for your opinion It's free I am a certified CCNA & MCSA and I know the reprocussions of reverse engineering so for you to go and state that I am trying to break someone elses protection code is down right preposterous and rude. OK so You can perhaps handle it but what about other who take part of the solution. Or do You believe we have a private conversation in a public thread. Thanks for being informative, Dennis You're welcome and enjoy Your day Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office
  - 16
    - Properties on outlook2003 folders Thank you for your reply. It was really helpful. Redemption and HiddenItems solved my problem. Tag: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times Office

Shrini

It is a 20 page document.

object pageRange = "1,3,5,7,9,11,13,15,17,19"

object PrintRangeOfPages = Microsoft.Office.Interop.Word.WdPrintOutRange.wdPrintRangeOfPages;

object PrintDocumentContent = Microsoft.Office.Interop.Word.WdPrintOutItem.wdPrintDocumentContent;

object PrintAllPages = Microsoft.Office.Interop.Word.WdPrintOutPages.wdPrintAllPages;

Document.PrintOut(ref BooleanTrue, ref MissingValue,

ref PrintRangeOfPages, ref MissingValue, ref MissingValue, ref MissingValue,

ref PrintDocumentContent, ref pageRange, ref PrintAllPages, ref BooleanFalse,

ref MissingValue, ref MissingValue, ref BooleanFalse, ref MissingValue,

ref MissingValue, ref MissingValue, ref MissingValue);

Please advise if I am doing something wrong.

shrini

Top

Re: Visual Studio Tools for Office Printing Range of Pages prints in a 20 page document, prints it 20 times

Maarten van Stam

Hi Shrini,

Your question here is not really a VSTO related issue and you are most likely better served in a forum dedicated to the Word object model.

I did however check to see if I could find a solution to your issue and came up with the next document.

http://support.microsoft.com/kb/826218/en-us

If your document to print contained sections it may be required to add section and page definitions in the pages parameter.

The best place to ask questions concerning how to automate an Office application's object model would be the office.developer.automation newsgroup. For a full list, see the "Please Read First" posting at the top of this forum.

Hope it helped,

-= Maarten =-

Top