Looping Through Open Word Documents

Visual Studio Tools for Office

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

- Previous
  - 1
    - Smart tags Word 2007 VSTO 2005 SE Hi, I'm having a problem with smart tags in Word 2007. I just can't find how to add them. On the microsoft site their are lots of walkthroughs for VSTO 2005. But in the VSTO 2005 SE, you can't use me.VSTOSmartTags anymore Thanks in advance Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 2
    - vsto vb.net need table in table or wrap rows? I am building a table and am getting data for the table from sqlserver. The columns that are being returned need to be wrapped into a second row. I was thinking of the folloing logic. Create table 1, loop through data, create table with 2 rows, fill table 2 with data for the record, next. Is this the best approach or is their a method that would wrap the columns into the next column with out needint a table in a table. In either case can you point out an example of how to do this. Also a side note, when I search MSDN and get results like this they are in french, itialian, espanol, why will it not stay on US-EN My profile says USA. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 3
    - Outlook AddIn; Using Default Outlook screens in winform Hi, I'm developing an outlook addin that allows the users to browse data from our business application. I added some new functionalities, therefore I used formregions and winforms in Outlook. I want to add a button to lookup a contact person and fill in the contact person in a textbox. Is it possible to use the default outlook lookup form for contact persons, as you can find it in a new mail screen I'm using VSTO 2005 SE + VS2008 Beta 2 Thanks in advance, Kind regards Simon Bruynsteen Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 4
    - Excel Addin. Hi Kjell Certainly the most efficient way to dump a large amount of data into Excel, without first saving it as a file, is to 1. Convert it to an ADO (not ADO.NET) recordset 2. Use the CopyFromRecordset method in Excel to transfer the entire recordset to a Range of values Where is this text string coming from If you're picking it up from a database, try going directly to an ADO recordset, rather than a delimited string. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 5
    - Make excel workbook readonly Thanks for that clarification. I really appreciate all your help. Is there a way to strongly protect the sheets so no one can modify them instead of having sheets password protected Password protection is very basic (I know its not meant to make sheets unmodifiable) and is easy to break. Any pointers on this Thanks again, bullpit Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 6
    - Problem with Installer Hi Ji, Thank you very much for ur reply. I copied Caspol.exe to C:\ and then performed Caspol -m addpset newfile.xml on the targeted machine. Runtime error: Could not load file or assembly 'customPerm, Version=0.0.0.0, Culture=neutral, publikeytoken=64a8517d791b1a32' or one of its dependencies. The system cannot find the file specified. I tried in many ways. but no use. I could do it on my machine by using .net framework configuration tool. Ji, Is there any link which provides the sample along with the setup file which may make my work easy. I want to check that setup on targeting device and compare with my setup file. Can you please provide one sample proj with setup which will be useful for me and for many more people Thanks in advance Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 7
    - Publishing VSTO 2005 SE addin to a network location Rakesh, Because I specifically pass the process ID, it only killed the instance that was loaded, not all instances. It may be possible to do so if you can detect which ones are office instances. As long as you inititally installed the addin using a setup project, you shouldn't have to change any registry settings if you overwrite the files in the install directory with those from the publish directory. VSTO loads addins based upon the details in the manifest, so as long as the manifest is correct (which it should be), it should load the latest version. Denis Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 8
    - Converting Interoped Code to Managed Code It's VSTO 2005 SE. But, its a conversion from the original VB6 program. The conversion created a bunch of references to COM objects and I'm wanting to get away from that if I can. I'm having a lot of problems with keeping a machine that will run the COM relic. The references to Word & Tools are all added by me in an attempt to find the Range object. I'm now attempting to add the Inerop.Word but I'm having a devil of a time. I see it in the gac but don't find any file that I can point the references to. I wanted to see what references the project type created so I just tried to create a new Word Document project in VS2005 and get this message: "Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled. If Microsoft Office Word or Microsoft Office Excel is running, it can prevent programmatic access from being enabled. Exit Word or Excel before opening or creating your project." The only thing is that I don't have Word or Excel running, I've rebooted and then double checked the Task Manager processes to make sure. But I still get this message. My workstation is Vista with UAC disabled. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 9
    - VSTO 2005 SE Word 2003 addin won't load What is the exact error message Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 10
    - Create MergeField from string I know from VSTO that it is possible to create MergeFields, and although I have not tried the drag&drop idea, I have added mergefields to documents using C# add-ins. A suggestion would be for you to format the text-string in such a way that you can scan the document after it has been dropped and convert the text into a mergefield. For example, let's say you wish to add an Address_Line_1 mergefield. Drop the text **Address_Line_1** (something unique) and then search for it in ActiveDocument. Select it and then add the mergefield in the selected range, with the name of the text, minus the asterisks. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 11
    - Office add-ins not running on clients I'm having a similar problem. It started with the plugin not loading. After some searching I found the above example, and followed it. After building my install project, I attempted to install the new one (after removing the old one). It installed fine, except when I loaded Outlook, the button did not appear. I looked into the COM Ad-ins in Outlook, and it isn't showing up. To sum up: First builds didn't load - had the error loading COM message. Second builds with SetSecurity project - didn't even show up in the outlook com ad-ins list. Is there something I am missing Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 12
    - Customize Outlook View--use Custom Task/Form, or what? I am looking for how to implement the following: Modify Outlook UI (VSTO, I assume), so the Mailbox view, the navigation pane displays a list of folders, which are not mail folders. They would be folders which represent folders say on our document storage server. The user should be able to "move" items from say their inbox folder, DRAG AND DROP onto these custom folders mentioned above, then somehow implement code to copy the mail message to the other server. The requirements are asking to have these custom folders, hopefully inside the Outlook Navigation pane (or at least on left nav ). My question is what customization concept should I use My first research (reading only) suggests the usage of a custom task pane, maybe with a tree control. But not sure if I can drag and drop and not sure if I can get the custom task pane to appear in left nav. Any help would be appreciated. Thank you for your time. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 13
    - add-in not working through setup project Hi all, I have the following problem: I've made an PowerPoint managed add-in using C#, VS 2005 , VSTO SE and PowerPoint 2003. The problem is that when click F5 on VS the add-in strarts, installs commandbars, buttons etc. and works fine. If stop debug mode of VS and strat PowerPoint manually the add-in still works, BUT if after it start the Setup and install the add-in via the standart setup project which VS generates the add-in no more works. I've made it a strong name, use RegAsm.exe with parameter /codebase , everything as is described everywhere. Also there is oneother thing: When I install the add-in with the Installer it registers successfuly. strat PowerPoint manually the add-in not works Thank you in advance Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 14
    - MS Word COM object problem hi, i used the Com object of (MS Office word 11) i added as a reference changed the web config and dcomcnfg i did everything and i used it. but suddenly my application started not to work. Can anybody help me about this issue i think the changes that i have made could affect the application start up. My application start after i get login it locks. thanks so much utku selamoglu Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 15
    - Shortcut Key for excel addin Hi Ji, That's a wonderful piece of example and I converted it to vb.net code and it works fine. I have also got another post which helped me in converting to vb code. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1934426&SiteID=1 Also, I have few things to clarify. 1) I am involved in migrating 2000 templates to 2007 templates using VSTO. So there are already "Alt" combination shortcut keys in existing templates. Is there any way to assign "Alt" combination shortcut keys 2) Here we have created a macro enabled addin to assign shortcut keys. So while deployment this macro enabled workbook should also accompany this solution right 3) Is there anyway other than this method to assign shortcut key for excel addin created using VSTO SE and Office 2007. Sorry for putting forward too many questions. Thanks a lot for your support till now. Regards, Mohan Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 16
    - Change Outlook email address "to" in BeforeCheckNames() Hi all, I'm developing an MS Outlook Add-in with VSTO (VB.NET). I've to change an email address before sending it, but here is a problem that the field "to" is ReadOnly. So I've to turn off the email address verification or change that field in BeforeCheckNames() somehow. Any ideas Best Regards Alexander Olekhnovich Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
- Next
  - 1
    - Performance/Display issues with Windows Forms Thank you for the info. What I meant to say is that it was happening for one person (a tester), but she has experienced it on a couple of different Word 2007 workstations (one a laptop, one a desktop). She experienced this with several of the forms in my application - not just a single form. The strange thing about this is that on other PCs, and for other users, the forms all close as expected. Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 2
    - PowerPoint 2007 Close Event ??? Hi, I am working on a project which requires me to create an Add-in to work with PowerPoint 2007 . Now here we dont have any event as BeforeClose in PowerPoint like in Word. I want to close PowerPoint on conditional bases from the application. I am using VS 2005, .Net 3.0, Office 2007. Can any one please show me any solution for the same.. Thanks in Advance... Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 3
    - Outlook Explorer Close event Thanks for replay, I created new Outlook AddIn and just subscribed to explorer's FodlerSwitch and Close. I launch the Outlook, and without open any window when outlook is opened i click the 'x' (close outlook). The CLOSE never fired (FolderSwitch works properly). Anu ideas Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 4
    - VSTO 2005 SE I installed MS Office 2007 including PIA 2007 Visual Studio 2005 VSTO 2005 SE on my computer. When i create Outlook Addin project in Visual Studio 2005 i get the following message. "Microsoft Office Outlook 2003 SP1 or newer is not installed on this computer. You must install a version of Microsoft Office Outlook 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System projects." Would i still have to install MS Office 2003 in order to start my outlook 2007 add-in development Thanks & Regards Danish Tehseen Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 5
    - Giving Cell Reference for String Hi, in my application i'm using string to be enter in a textbox. I've to use the cell reference for that textbox too. The scenario as follows, There will be a text in any one of the cell in sheet. The user will open a form and there is a text box.In next to that i've to give the cell reference icon, when the user clicks the icon, it should open a separate window and cell reference should appear in the wndow. Once user hits enter, the cell nmber alone should display in the text box. Let me get solution for the above. The function need is same as in the norma Excel -->Insert-->Formula. I need the code for this. If the solution reaches me in short,it ll be more helpful. Thanks Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 6
    - SerializationException: Type is not resolved for member ... Hi, I'm currently at loss with this current problem. This is the scenario: I have several c# libraries (all strongly named) in my solution. This solution processes data and serialised the result into a MS SQL Server database. From my VSTO project (using VB.NET) I tried to access the database and deserialise the result back into my object. Everything works until the moment of deserialisation where I get the SerializationException: Type is not resolved for member ... I have a test project that accesses the database and deserialise my object and it is working perfectly fine, so I'm certain that the serialisation/deserialisation code is working, but just not within VSTO framework. Any ideas Cheers, Victor Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 7
    - Outlook.AppointmentItem.Conflicts - Problem Hi, I get Null for this filter although I should get an appointment. The filter is a bit complicated because I need to find overlapping appointments ( do you have more efficient filter ) , and because I try to find it inside the event method I should ignore the cuurent item so I should add the ('" + ap.GlobalAppointmentID + "' <> [GlobalAppointmentID]). But the I have problem with including this statement, maybe I can't include the GlobalAppointmentID property in the filter, so I think I add UserProperty and add it to the filter. Iram Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 8
    - Addin fails to load a DLL which had its version updated. Hi, Sorry, I still cannot reproduce your scenario. This time I create two projects into one solution. And set VSTO project��s dependency as ClassLibrary. But once I rebuild the solution. My vsto project will get the right version of ClassLibrary and copied it to Local place. Everything works fine. I do not think this caused by manifest in excel file. The error message states that exception throws when your customization codes load the ClassLibrary, but not when your document loads your customization codes. Thanks Ji Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 9
    - Reading Excel From C# If you are using a dynamically generated excel file then you can use the following: Excel.Sheets sheets = m_Excel.Worksheets; Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1); System.Array myvalues; Excel.Range range = worksheet.get_Range("A1", "E1".ToString()); myvalues = (System.Array)range.Cells.Value; Thanks Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 10
    - Outlook Addin (VSTO) not starting when "outlook.exe" is running with no UI Hi, it seems that this issue has been the topic of many threads (e.g. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=576370&SiteID=1 ). However, I couldn't find any hint on how to solve this problem. How to reproduce: 1. Put a "MessageBox.Show()" or a "File.WriteAllText()" in the startup event handler method. 2. Run any application that starts Outlook in the background. The message or the file won't show up. However, the addin's LoadBehavior is set to two. 3. Fire up Outlook (UI) and check the addin state (Tools > Options > Other ...). It's not loaded due to some error. 4. Close Outlook (UI) and close the application that initially started Outlook in the background. The process "outlook.exe" won't shut down and has to be killed manually. Conclusion: The addin loader seems to cause the error when Outlook is launched with no UI because the addin code never seems to get called. Moreover, it seems to hold some resources that prevents "outlook.exe" from being terminated. Question: Could the conclusion be correct If not, is there any reasonable explanation for this behavior Is there a workaround or a fix for it Please let me know! Current Setup: Windows XP SP2 Outlook 2003 VSTO 2005 SE Many thanks! Florian Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 11
    - Can't get most basic VSTO 2005 SE Outlook Add-In to load Hi Geoff, I tried the steps you outlined in your linked post. AddinLoader.dll *is* being loaded, however the fuslogvw viewer doesn't give me any information after hitting Refresh. Managed and native debugging is enabled, and all exceptions are enabled. Am I using the Fusion viewer incorrectly, or does this help narrow it down Pete Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 12
    - Working With the Outlook.NK2 file OK, thanks for the feedback. I just wanted to make sure there wasn't already something in place that could be used. Roman Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 13
    - Excel shapes - editing / creating mixed format Hi Jan From the looks of things, you want to work with the new Office 2007 graphics. These don't have a very good object model - no idea whether they may acquire one in a future version of Office. But for the moment, you need to use the Office Open XML file format to work with the full spectrum of functionality offered by the new graphics engine. You might try looking around and asking at the OpenXMLDeveloper.org website. Jan Ku era wrote: Hi, I have a shape in Excel 2007, which looks like this: Code Snippet My Project cool sheet Project Number Now, I would like by C# (Orcas), eventually VBA modify the individual paragraphs, like Project Number without loosing the formating. I also need to create such formatted shapes. How The Excel macro recording does not capture operations with shapes. I have also found the Sheet.Shape.TextFrame2 object, but I don't know how to get/modify individual paragraphs, since I see only Text property of "My Project cool sheet Project Number" in the VBA watch window. If this can't be done, what workaround do you suggest Three text boxes in layers Thank you, Jan Kucera Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 14
    - using VSTO w/ ASP.Net 2.0 Thanks for info Cindy. You mentioned I could use the xml approach, would I be able to fill dialog box or command bar to have drag down list of database columns and drop it to the word document. Is this possible or need VSTO to do that Do I need VSTO when using SmartDocument SDK and how exactly I would use in this sdk to accomplish this task Thanks. Dennis Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 15
    - Collect information using the EntryId ? OK ! Thank you for all ! Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office
  - 16
    - Adding pages to document based on the same template Wow thanks for the quick reply Now the problem i'm having is that my code always uses the same bookmarks of my template so the first page contains the data and the other pages contains the empty templates... ' creation of a new page from the template Dim rng As Word.Range rng = w_doc.Range rng.Collapse(Word.WdCollapseDirection.wdCollapseEnd) rng.InsertFile(My.Settings.optPathModelesWord & "wd_template_LettreRegroupement.dot") ' data insertion in the word document With w_doc .Bookmarks("bmkNom").Range.Text = M_Database.getValue(Nothing, 0, "String") .Bookmarks("bmkNom2").Range.Text = M_Database.getValue(Nothing, 1, "String") [ ... ] End With ' table insertion in the word document w_doc.Tables.Add(w_doc.Bookmarks("bmkLots").Range, 2, 4) Dim tableLots As Word.Table = w_doc.Tables(1) With tableLots .PreferredWidth = w_app.InchesToPoints(6.2) .Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle .Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle .Rows(1).Range.Font.Bold = 1 .Cell(1, 1).Range.Text = "Numero de lot projete" .Cell(1, 2).Range.Text = "Numero de lot actuel" .Cell(1, 3).Range.Text = "Designation secondaire" .Cell(1, 4).Range.Text = "Cadastre" End With [ ... ] Any ideas Thank you edit: I guess i need to tell w_doc what template to use... Tag: Visual Studio Tools for Office Looping Through Open Word Documents Office

Roman Benko

I am working with Orcas and VSTO Beta 1. I created a new Word document project called TestWord that contains a custom ribbon. If a user has multiple Word documents open at any given time, how can I loop through them and determine which ones, if any, are my custom type containing the ribbon Thanks.

Top

Re: Visual Studio Tools for Office Looping Through Open Word Documents

Cindy Meister

It might be better to ask this in the Orcas VSTO forum, but in a VSTO 2005 for Word 2003 document-level project there's an OLE Control belonging to the Shapes collection of the OLE Class

ActiveDocument.Shapes(1).OLEFormat.ClassType
VSTO.RuntimeStorage.1

Assuming the VSTO team has kept the same approach for 2007, you can loop through the Shapes collection of a document, testing the OLEFormat.ClassType whether it's VSTO.RuntimeStorage.1 (or perhaps better, check whether this value "Contains" VSTO.RuntimeStorage in case the application version has changed).

Top