Why do MS Word Automation return different values with and without Debugger?

Visual Studio Tools for Office

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

- Previous
  - 1
    - How to process a Office document which is encrypted by RMS PS: i programme it with C# Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 2
    - Using Balloon ToolTips in Excel VSTO project I'm trying to display status messages in a VSTO document level customization using balloon tooltips. Ideally they'd popup from Excel's status bar. But for now it doesn't matter. However, I'm getting null exceptions when I try to use the ToolTip class to do this. ToolTip tip = new ToolTip (); tip.IsBalloon = true ; tip.Show("testing", excelWindow , 3000); excelWindow is an instance of a class that implements IWin32Window that returns Globals.ThisWorkbook.Application.Hwnd for the handle, and its not null. Why isn't this working Is there an alternative way to get this done Thanks Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 3
    - HRESULT 800ac472 from set operations in Excel Hi everyone! I have an interesting problem that I hope someone can give me an idea on how to handle: If I try any set operations to for example an Excel.Range when I have start to mark a range of cells and havent finished by releaseing the mouse button, I get a COMException HRESULT 800AC472. It seems that when the mouse is used to select a range, the workbook is set to some particular un-editable state, allthough I can't find any indication of this in either the application, workbook, worksheet or range instance. What I have done is to put a thread on a form which sleeps and does Control.Invoke on a method UpdateCell that will update a value in A1. Using Invoke rather than calling the method directly would ensure that it is actually the main thread that performs the task. I can fetch the range A1 fine, and I can read the value, it just won't allow me to set either Value2 or Formula. To give you the background: What I want to do is to figure out what a full product performing long running tasks outputting data to Excel would look like. I soon realized that if an operation induced by a mouse click takes one minute to finish, Excel would be locked down for one minute, which is not acceptable. Spawning a thread to perform the background work would be ideal, but now it turns out that I can't output data particularly when the user is selecting a range. It seems there are several more operations that I can't perform either, like Worksheet.Activate. Any "set" operation really. I use .NET2.0, Excel 2003 SP2 (11.8134.8132) and IDTExtensibility2. Any ideas on how to solve this problem are GREATLY appreciated!!! Cheers! ./Fred Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 4
    - Outlook ActiveInspector Changed event Hello I am developing Outlook Add-In using VSTO 2005 SE. Lets imagine the following situation: The user has opened two mail windows (inspectors). And he clicks on them switching the active ones. Is there any event that I can subscribe to in order to handle those active inspectors switchings. I need something like DocumentChangedEvent in word. Thanks, Kostadin Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 5
    - How to check OS version from an Outlook Addin? Hi, I have two applications. (a) A Window App on which the code is working fine to give the OS Version as intended. The OS is 64 bit and it rightly displays (b) An Outlook VSTO Addin (A plugin which gets added in Outlook 2007) but the same code says that the OS is 32 bit. Both of the above applications have been developed on a 32 bit machine. Actually, the Outlook is running as a 32 bit process and the OS is 64 bit Windows and the code is always giving the reply as 32 bit when i used IntPt3.Size and it gave me as "4" instead of 8. Any ideas Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 6
    - Create excel files dinamically with dinamic columns? Hello, this is my scenario. I have a person table, but I also have some demographic variables for the person, so a client can configure its application to have for example the following variables, Genre, Number of children, Salary, etc. I will have a form for the user to enter that data, but I need also to have a way for the user to import too many rows from an excel file. As the user wont know the structure of the excel file, I want to create an xls file at runtime, and according to the variables the user configured, it must show dinamically generated columns. The idea is that the excel file can be downloaded and the user starts filling the excel file and then uploads it to process the data. How can I achieve this Any ideas Thanks Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 7
    - help with the outlook add-in in vs2005 hi i have problem i start new project outlookAddIn Private WithEvents _Explorers As Outlook.Explorers Private WithEvents _Explorer As Outlook.Explorer Private _contactFolder As Outlook.Explorer Private _mapiContact As Outlook.MAPIFolder Private _helpMenuIdex As Object Private _menuBar As Office.CommandBar Private WithEvents _Email As Outlook.MailItem Private Const COMMAND_BAR As String = "EDC" Private Const BUTTON_NAME As String = "Send_EDC" Private WithEvents myButton As Office.CommandBarButton Private Sub ThisAddIn_Startup( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Startup _menuBar = applicationObject.ActiveExplorer().CommandBars.Add(COMMAND_BAR, Office.MsoBarPosition.msoBarTop, False , True ) _menuBar.Visible = True End Sub when i run the add-in and the outlook start i get this msg An unhandled exception occurred in your application. Contact your administrator or the author of this document for further assistance. please some ine can help me Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 8
    - Protect individual Worksheets from deletions Using ThisWorkbook.Protect() protects the workbook structure from changing so that no Worksheets can be added or deleted. I would like to protect certain Worksheets from being deleted but not others. That is, I create some Worksheets dynamically that I want users to be able to delete if necessary. However, the five basic Worksheets need to be protected from deletion. Is this possbile If so, how Thanks, John Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 9
    - IPictureDisp and Icon! Again Hi, I need to put a icon in my outlook 2003 plugins. I try several approch without success with transparency. My Icon have a transparency set to 255,255,255 but all the transparancy appear pink on the menu! I try to add a mask to my command button like the KB said with the same result! Help! Someone have a good sample in vb.net for that Thanks Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 10
    - How to check whether specific bookmark is inside the table Hi ~ I programming using Microsoft Office 9.0 object library Microsoft Word 9.0 object library For insert the text into bookmark, i know the name of bookmark and can find the range of bookmark. How can i know whether the bookmark is inside a table. And if it inside the table, how to get the immediate table that nesting the bookmark and which table cell is nesting this bookmark. Thank you very much ~ Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 11
    - How to add items in the context menu in the mailitem? I use outlook 2003 I found a lot of references But can't find how to access the context menu in the mailitem(inspectors) I want to add some items in the right click menu after a known email address in the To/From field is recognized Could anybody help me Thank you in advanced Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 12
    - "Failed to grant permission to execute" error calling 2nd assembly, Outlook add-in (installs fine and runs up to error) I have a VSTO solution developed using VSTO and VS2K5. I've followed all the steps in previous articles regarding this kind of deployment (prerequisites, CAS, etc.) and it's been successful up to a point. I've integrated the SetSecurity project in order to give my assembly Full Trust, but I have another assembly which is in my solution, and it is called from the primary assembly. When assemblyA (given full trust via SetSecurity project) tries to instantiate something from AssemblyB, I get the "Could not load file or assembly.....Failed to grant permission to execute" How can I also grant AssemblyB Full Trust and avoid this error Thanks for any help you can provide. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 13
    - Excel.Interop Not Retaining Column Width On Save Hi, I need to open an Excel file using Interop, resize a column and then save the file, insuring that the worksheet retains the newly resized column width. As I step through the code all is working fine. But when I reopen the file the new column width has not been saved. If I open the file manually, resize the column, then save, the file retains the new column width. Any suggestions I should add that I also tried reading the column width after the AutoFit was called and then explicitly set the column width to that value, then I saved the file This also did not work. Here is the code I used. I have done this in Winforms. Thanks for your help. Mark using Excel=Microsoft.Office.Interop.Excel; namespace ExcelWindowsTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, System.EventArgs e) { Excel.Application excel; Excel.Workbook book; Excel.Worksheet sheet; Excel.Range range; try { excel = new Excel.Application(); excel.Visible = true; book = (Excel.Workbook)(excel.Workbooks.Add(@"C:\Documents and Settings\Mark\My Documents\Visual Studio 2005\Projects\ExcelWindowsTest\ExcelWindowsTest\PortDeliveryWorkBook.xls")); excel.DisplayAlerts = false; sheet = (Excel.Worksheet)book.ActiveSheet; range = (Excel.Range)sheet.Columns["A", Type.Missing]; range.AutoFit(); book.Save(); excel.Quit(); } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error"); } } Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 14
    - Microsoft.Office.Interop.Outlook.MailItem Hello there. I am trying to attach a document to an email using the following code. Private Sub AddAttachment() Dim Outlook As New Otl.Application Dim mail As Otl.MailItem = CType (Outlook.CreateItem(OlItemType.olMailItem), MailItem) 'Dim oNS As Microsoft.Office.Interop.Outlook.NameSpace = Outlook.Session.GetNamespace("mapi") mail.Subject = "An attachment for you!" Dim attachment As OpenFileDialog = _ New OpenFileDialog() attachment.Title = "Select a file to send" attachment.ShowDialog() If attachment.FileName.Length > 0 Then mail.Attachments.Add( _ attachment.FileName, _ Outlook.OlAttachmentType.olByValue, _ 1, _ attachment.FileName) 'Error on this line' mail.Send() End If End Sub I get error Public member 'OlAttachmentType' on type 'ApplicationClass' not found. Help me. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 15
    - Cannot cast interface: 0002096B-0000-0000-C000-000000000046 I have an application that needs to extracted emvedded office files from Word and Excel files. I have the extraction working for Word documents with the current code snippet: private int extractFromWord(string fileName, DataTable docTable, string explodedDirectory) { FileInfo fi = new FileInfo(fileName); int fileID = Utilities.GetIDFromFileName(fi.Name); object verbIndex = 1; int docCount = 0; try { object fn = (object)fileName; Word.Application app = new Microsoft.Office.Interop.Word.Application(); Word.Document doc = app.Documents.Open(ref fn, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing); object saveChanges = false; object originalFormat = null; object routeChanges = null; try { foreach (Word.InlineShape inlineShape in doc.InlineShapes) { if (inlineShape.OLEFormat != null && inlineShape.OLEFormat.ProgID != null) { string pid = inlineShape.OLEFormat.ProgID.ToLower(); if (pid.StartsWith("powerpoint.show.")) { //inlineShape.OLEFormat.DoVerb(ref VerbIndex); //PowerPoint.Application ppt = Marshal.GetActiveObject("PowerPoint.Application") as PowerPoint.Application; //ppt.ActivePresentation.SaveAs(@"C:\testPPT.pptx", Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsPresentation, Microsoft.Office.Core.MsoTriState.msoTrue); //ppt.Quit(); } else if (pid.StartsWith("excel.sheet.")) { inlineShape.OLEFormat.DoVerb(ref verbIndex); Excel.Application excel = Marshal.GetActiveObject("Excel.Application") as Excel.Application; excel.Visible = false; FileInfo xfi = new FileInfo(fileName); object xfileName = (object)(explodedDirectory + xfi.Name + "." + docCount.ToString() + ".xls"); //object xfileFormat = Excel.XlFileFormat.xlExcel9795; excel.ActiveWorkbook.SaveAs(xfileName, _missing, _missing, _missing, _missing, _missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, _missing, _missing, _missing, _missing, _missing); excel.Workbooks.Close(); excel.Quit(); } else if (pid.StartsWith("word.document.")) { Word.Document document = inlineShape.OLEFormat.Object as Word.Document; FileInfo wfi = new FileInfo(fileName); object wfileName = (object)(explodedDirectory + wfi.Name + "." + docCount.ToString() + ".doc"); object fileFormat = Word.WdSaveFormat.wdFormatDocument; document.SaveAs(ref wfileName, ref fileFormat, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing); document.Close(ref saveChanges, ref originalFormat, ref routeChanges); document = null; } docCount++; } } } catch (System.Exception ex) { docCount = 0; } doc.Close(ref saveChanges, ref originalFormat, ref routeChanges); doc = null; app.Quit(ref saveChanges, ref originalFormat, ref routeChanges); app = null; } catch (System.Exception ex) { } return docCount; } However, when I tried similar code with Excel files, the cast to a word document returns a null. Here is the code for Excel documents (Cast is in bold) : private int extractFromExcel(string fileName, DataTable docTable, string explodedDirectory) { FileInfo fi = new FileInfo(fileName); int fileID = Utilities.GetIDFromFileName(fi.Name); int docCount = 0; try { Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); Excel.Workbook doc = app.Workbooks.Open(fileName, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing, _missing); app.Visible = false; object saveChanges = false; object originalFormat = null; object routeChanges = null; try { foreach (Excel.Worksheet workSheet in doc.Worksheets) { foreach (Excel.Shape inlineShape in workSheet.Shapes) { if (inlineShape.OLEFormat != null && inlineShape.OLEFormat.progID != null) { string pid = inlineShape.OLEFormat.progID.ToLower(); if (pid.StartsWith("powerpoint.show.")) { //inlineShape.OLEFormat.DoVerb(ref VerbIndex); //PowerPoint.Application ppt = Marshal.GetActiveObject("PowerPoint.Application") as PowerPoint.Application; //ppt.ActivePresentation.SaveAs(@"C:\testPPT.pptx", Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsPresentation, Microsoft.Office.Core.MsoTriState.msoTrue); //ppt.Quit(); } else if (pid.StartsWith("excel.sheet.")) { inlineShape.OLEFormat.Activate(); Excel.Application excel = Marshal.GetActiveObject("Excel.Application") as Excel.Application; excel.Visible = false; FileInfo xfi = new FileInfo(fileName); object xfileName = (object)(explodedDirectory + xfi.Name + "." + docCount.ToString() + ".xls"); //object xfileFormat = Excel.XlFileFormat.xlExcel9795; excel.ActiveWorkbook.SaveAs(xfileName, _missing, _missing, _missing, _missing, _missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, _missing, _missing, _missing, _missing, _missing); excel.Workbooks.Close(); excel.Quit(); } else if (pid.StartsWith("word.document.")) { inlineShape.OLEFormat.Activate(); Word.Document document = inlineShape.OLEFormat.Object as Word.Document; FileInfo wfi = new FileInfo(fileName); object wfileName = (object)(explodedDirectory + wfi.Name + "." + docCount.ToString() + ".doc"); object fileFormat = Word.WdSaveFormat.wdFormatDocument; document.SaveAs(ref wfileName, ref fileFormat, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing, ref _missing); document.Close(ref saveChanges, ref originalFormat, ref routeChanges); document = null; } docCount++; } } } } catch (System.Exception ex) { docCount = 0; } doc.Close(saveChanges, originalFormat, routeChanges); doc = null; app.Quit(); app = null; } catch (System.Exception ex) { } return docCount; } From stepping through the code, the prodID is "Word.Document.8" but the cast does not work. Do the Excel PIA's operated differently then the ones for Word, or is there a container that I am not catching Thanks Martin Reich Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 16
    - Outlook Exchange server address Hi, I need to get the exchange server address(name), user name, email id, password from the outlook programmatically using C#. Outlook is already configured. I need to get the details. I was able to get the AD user name using the following code Application objOutlook = new Application (); // Get items in my inbox. NameSpace outlookNS = objOutlook.GetNamespace( "MAPI" ); outlookNS.CurrentUser.Address give me the username. How to find the other details like email id, server address, password. Thanks in advance Srinivasan Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
- Next
  - 1
    - Adding list box to ribbon in outlook 2007 Not sure if this is the right forum. I have created an outlook 2007 add in. I want to add a listbox on the ribbon. I'll have ti do it by editing the xml file. I have written following code. < customUI xmlns = " http://schemas.microsoft.com/office/2006/01/customui " onLoad = " OnLoad " > < ribbon startFromScratch = " false " > < tabs > < tab id = " SampleTab " label = " Sample Tab " visible = " true " > < group id = " MyGroup1 " label = " My Group1 " > < editBox id = " textBoxName " label = " Enter name " /> < button id = " buttonSearch " size = " normal " label = " Search " onAction = " StartSearch " /> < listBox id = " listBoxEmails " /> </ group > </ tab > </ tabs > </ ribbon > </ customUI > When I delete the line < listBox id = " listBoxEmails " />, the code works fine, and I can see "Sample tab" when I compose a new message in outlook with text box and a button. But when I add the line < listBox id = " listBoxEmails " />, I cant see the "Sample tab". How do I add the list box on my ribbon. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 2
    - VSTO as COM? Hello Everyone, Is it possible to allow a VSTO .dll to be used as a COM object in the same was as a Class Library project I'm able to create a standard Class Library to expose to Visual FoxPro as I'm able to use ProgId to expose the object as a given name, but I don't seem to be able to do the same with a VSTO project. The main difference seems to be the "Output type" value from the Application page of the project's properties. I am able to set the "Make assembly COM-Visible" checkbox from the Assembly Information form though. Thanks, Andy Crawshaw Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 3
    - LoadBehavior changes from 3 to 2 in excel addin Hi, I have created an Addin for Excel 2007 using VSTOSE and trying to deploy. I tried to deploy using the automatically generated Setup project and everything works fine for the first instance. When I close the excel application and open again the Addin is loaded but doesn't show the custom ribbon. When I checked "Office Button --> Excel Options --> Add-ins --> COM Add-ins --> MyExcelAddin" the addin is loaded but in unchecked state. I checked the registry and the Loadbehaviour is changed from initial 3 to 2. (HKCU--S/w-->MS-->Office-->Excel --> Addins--> MyExcelAddin) I have added setsecurity project mentioned in the walkthrough and added custom actions. Do I need to do anything more on this security options I have downloaded and installed the fix also from the below mentioned location but of no use. http://support.microsoft.com/kb/908002 Any help would be appreciated. Thanks, Mohan Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 4
    - convert vba to excel addin I have this macro which queries ms sql and returns results to excel. I also have a macro which updates sql from excel. example Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Sub get_data() cn.Open "Driver={SQL Server};" & "Server=127.0.0.1;" & "Database=demo;" & "Uid=User_Name;" & "Pwd=Password;" Sql = "Select distinct product, long_description " _ & "from stock" rs.Open Sql, cn r = 2 Do Until rs.EOF Range("A" & r).Value = rs(0) Range("B" & r).Value = rs(1) r = r + 1 rs.movenext Loop Range("A1").Select rs.Close cn.Close End Sub Has anyone got an idea on how this can be changed to a .net com addin Thanks Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 5
    - Runtime error when loading VSTO outlook add in on client machine Dear Sirs/Madams, I am trying to create an outlook 2007 addin using vsto 2005 se. However, when installing on the client the installation process completes normaly, but when i start outlook my add in does not function. Checking the addins page, i see that my add in generated a runtime error: " Load Behavior: Not loaded. A runtime error occurred during the loading of the COM Add-in. " Within the installer i used the set security project. And even tried to add CAS with caspol.exe and through the control panel => administrative tools => .NET framework configuration. But it still isn't working, i installed all requires apps. And tried to figure out what to do for days now. Allready tried to use the CMD set VSTO_display.. thing but that didn't give me any additional error messages. I hope you can help me, Kind regards, Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 6
    - Terminate process when it uses less system memory Hi! I'm trying to create an application which starts a powerpointpresentation in the powerpoint viewer 2007. and then when the presentation end, returns to the application interface. My problem is the black screen appering after the presentations has ended. I can't find any settings for this so my idea was to terminate the pptviwer.exe process when it's own memory usage has decreased. By monitoring it i found that when the black screen appears the memory usage decreases to approx 5000kb. Is there a way to either disable the black screen att the end of every presentation shown in powerpoint viewer or a way to monitor the power point viewers memory usage until it goes under 5000kb and then terminate the process /Sebastian Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 7
    - How to set the Background image to the background of the Document. Hi, I tried to place a Background image to the background of the Document I have created. When I run this, the error is repored as "Command only available in print layout view." The code is given below. (Sorry .. It may be completely wrong) (I need to place it as the background of the body of the document, NOT at the Header of Document.) Thanks Tomy WordApp.Visible = true; NewDoc.Activate(); // THE PATH OF THE LOGO FILE TO BE EMBEDDED IN THE HEADER object missing = System.Reflection.Missing.Value; String logoPath = "C:\\Document and Settings\\MyLogo.jpg"; WordApp.ActiveWindow.ActivePane.View.SeekView = WdSeekView.wdSeekMainDocument; Shape logoCustom = null; object oFalse = false; object oTrue = true; WordApp.Selection.HeaderFooter.Shapes.AddPicture(logoPath, ref oFalse, ref oTrue, ref missing, ref missing, ref missing, ref missing, ref missing).Select(ref missing); logoCustom.Select(ref missing); logoCustom.Name = "CustomLogo"; logoCustom.Left = (float)WdShapePosition.wdShapeLeft; Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 8
    - How to show my C# VSTO Add-In in the Insert Ribbon Hi I have some VSTO Add-In, wich I want to show in my Insert part of the Office Word 2007 Ribbon. I searched in Google and msdn, but I didn' find some usefull help for Word 2007. Here a Picture http://image-upload.biz/files/756e9aa9c429bf2c9ead07e05.jpg I hope someone can help me Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 9
    - Security Warnings Hi , I have installed VSTS 2005 having the VSTO 2005 RTM on my machine along with Office 2003. I am encountering a problem , whenever I open any office product , a security warning dialog box appears that show mein the Visual studio path and shows the following message , the macros mein contain virus and thus i have the options for enabling and disabling a macro. Are there any certificate issues with this or something else. Is there a solution to overcome this , intead of enabling or disabling the macros as I am developing an addin for my organization and they cant give a green signal if such warnings are coming. Thanks a lot in advance. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 10
    - Context menu customisation for the outlook word editor I am writing an add-in to Outlook 2007 using VSTO 2005 SE for which I need to add a context menu item that appears in a new mail inspector window when I right click over the body of the email. I was able to do the same back when winword.exe was run as the default editor in outlook 2003, but now it seems that the editor is run in-proc (I tried accessing the object model through the wordeditor object of the inpector but it looks like the object model and access to the corresponding commandbars object is blocked when the document is open as an email). The command bar needs to be added to the word-editor��s context menu and nowhere else in Outlook. Could anyone help me out on how this can be done or point me to some resource that��ll help me Thanks in advance, Rishab Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 11
    - A lot of pain with Word automation I'm having a lot of difficulty trying to do simple things with Word 12.0 Object Library. 1) When I try to create a new document... Microsoft.Office.Interop.Word.ApplicationClass oWordApp = new Microsoft.Office.Interop.Word.ApplicationClass(); Microsoft.Office.Interop.Word.Document oDoc = oWordApp.Documents.Add(ref missing, ref missing, ref missing, ref missing); Documents.Add returns null, and Documents.Count is still 0. 2) When I try to open an existing document.... oDoc = oWordApp.Documents.Open(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); it hangs at this statement and I have to stop it (I waited like 15 minutes). Can anyone help Please!! And thank you. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 12
    - Change Sent Time Hi , Is it possible to change the sent time when I open the mail using Outlook 2003 and VSTO 2005 Thanks in advance Abhi Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 13
    - How do _you_ develop for OL2003 and OL2007 with VSTO SE? Having read various threads and blogs on the subject of developing for Outlook 2003 and 2007, I am interested in how others are setting up their development environments. My add-in doesn't require OL2007 functionality but I want to deploy to OL2007 clients with the OL2007 PIAs. Because I cannot reliably build my add-in with both OL2003 and OL2007 PIAs on the same machine I am currently installating a VM with VS 2005, VSTO SE, OL2007 (including the PIAs). What I would like to do is link my VM project (which references the OL2007 PIAs) to the OL2003 source code files on the host via a network share. That way I only have to maintain one code base. Is this possible Thanks, Tad Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 14
    - Create a VSTO solution that works in Word, Excel, PPT? Hey everyone! I hope you're well and in high spirits. Here's a quick question: What's the best way to create one VSTO project that installs in Word, Excel, and PPT 2007 The old Shared-Add-In Wizard made this easy--I just checked the apps I wanted. That was pretty neat. Any suggestions for how to acheive this with VSTO 2005 SE Thanks!!! -Savraj Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 15
    - excel currency format hi All, from an web service i will be getting currency (e.g.: USD 35.45) as string . i need to convert this to a currency format and also manipulation should be possible (i.e it should be string anymore when pasted in the cell). what is possible way to do this Thanks in advance Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office
  - 16
    - OleDbPermission error accessing assembly I have just installed the .Net Framework security update and started getting the following error when testing on my development PC: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Cluture= neutral, PublicKeyToken=... ' failed. I am receiving the error in a VSTO Add-in for Word 2007 - this add-in accesses another VB.net assembly that uses oledb to lookup information in an Access db. Why would this suddenly appear following the yesterday's security update I am thinking I must need to set some OleDB permission parameters or machine-level security policy in Caspol.exe (or both). Could someone point me in the right direction Thanks. Tag: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger? Office

Eugene S.B.

range.Select(); //line 1

float X = (float) ((Microsoft.Office.Interop.Word.ApplicationClass) _application).Selection.get_Information(WdInformation.wdHorizontalPositionRelativeToPage); //line 2

If I set breakpoint at line 1 and stop in debugger, I get another value in line 2. Selected range is located in table cell. May be I have to invoke some refresh function or something else before line 2. I don't really understand why I get different values for the same file and the same range in Debugger and without debugger.

Re: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger?

Eugene S.B.

I want to declare what I found. If I add some delay between loading of word document and processing the objects - all works fine. I think MS Word do some loading asynchronously, so I have to wait for ending of initialization.

Re: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger?

Cindy Meister

Hi Eugene

Your thoughts are on the right track, I think :-) When loading a document, what takes time is the pagination and layout of the page. Tables are notoriously slow. So if you're are querying this immediately after opening, or perhaps even editing table content, it makes sense that the value being returned might not be stabile.

Perhaps a loop that compares the value two or three times and only ends when the value is the same two or three times running

Re: Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger?

Eugene S.B.

Cindy Meister wrote:

Perhaps a loop that compares the value two or three times and only ends when the value is the same two or three times running

I think loop that compares the value two or three times is not reliable solution because we can get wrong value several times.

I solve the problem by adding:

Thread.Sleep(1000);//Waiting for 1 second

after opening the document.