Excel automation : formating dissapears

Visual Studio Tools for Office

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

- Previous
  - 1
    - Creating a Reply from an Outlook 2003 MSG file I'm looking for a way to programmatically create a MailItem reply from an existing .MSG file using Outlook 2003. I can open/extract information from the MSG using .CreateItemFromTemplate, but the .Reply method will not work on that mailitem, ostensibly since it is not in Outlook. I saw another posting from Sue Mosher on the Namespace.OpenSharedItem method in Outlook 2007 that apparently can be used to add an existing MSG back into Outlook. However, I have not found anything equivalent for Outlook 2003. The primary problem with creating a new mailitem and populating the to/from/subject and body is the body itself. Outlook will automatically add the To/From/Subject and item break line when creating a reply, which is what Im trying to accomplish by using Outlook to create the reply vs manually populating a new mailitem. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 2
    - getting content from excel in Visual Studio Hi, I'm creating a software applicaition in Visual Studio using C#. I need to read/write to an excel spreadsheet. Can I get some ideas on how best to do that without opening the excel file. Thanks, austxcara Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 3
    - Strange export to Excel Hi, I am using Access 2003. I have created report in my application. On preview I see the all data and the summary rows. I do the save as Excel 2003 and I got that summery rows through partically. The column where I sum data is passed to excel but other columns (that is data from rows group) didn't pass. How can I solve it Thank's Alexei Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 4
    - Setup has detected that the file vstor.exe' has changed since it was initially published? Hi, Actually I have prepared installer along with prerequisites (VSTOR, Office PIA). but its giving the following error while installing on target machine. Setup has detected that the file 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\vstor\vstor.exe' has changed since it was initially published. Can any one plz guide me Here is my log: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.2.1 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\dotnetfx\dotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer' Read string value '7.0.5730.11' Setting value '7.0.5730.11 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 7.0.5730.11 {string} Running checks for command 'dotnetfx\instmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass' Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'dotnetfx\dotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Visual Studio Tools for Office Runtime Redistributable', phase BuildList Attempting to find 'Microsoft.Office.Tools.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Common.Installed' Attempting to find 'Microsoft.Office.Tools.Outlook, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Outlook, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Outlook.Installed' Attempting to find 'Microsoft.Office.Tools.Word, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Word, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Word.Installed' Attempting to find 'Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Excel.Installed' The following properties have been set for package 'Microsoft Visual Studio Tools for Office Runtime Redistributable': Running checks for command 'vstor\vstor.exe' Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Common.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Outlook.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Word.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Excel.Installed': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of checks for command 'vstor\vstor.exe' is 'Install' 'Microsoft Visual Studio Tools for Office Runtime Redistributable' RunCheck result: Install Needed Running checks for package 'Microsoft Office 2003 PIA Redistributable', phase BuildList Attempting to find 'Microsoft.Office.Interop.Outlook, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' in the Global Assembly Cache Assembly found at 'C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Outlook\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll' Setting value '11.0.5530.0 {version}' for property 'Microsoft.Office.Interop.Outlook.Installed' Attempting to find 'Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' in the Global Assembly Cache Assembly found at 'C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Excel\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll' Setting value '11.0.5530.0 {version}' for property 'Microsoft.Office.Interop.Excel.Installed' Attempting to find 'Microsoft.Office.Interop.Word, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' in the Global Assembly Cache Assembly found at 'C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Word\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Word.dll' Setting value '11.0.5530.0 {version}' for property 'Microsoft.Office.Interop.Word.Installed' The following properties have been set for package 'Microsoft Office 2003 PIA Redistributable': Property: [Microsoft.Office.Interop.Excel.Installed] = 11.0.5530.0 {version} Property: [Microsoft.Office.Interop.Outlook.Installed] = 11.0.5530.0 {version} Property: [Microsoft.Office.Interop.Word.Installed] = 11.0.5530.0 {version} Running checks for command 'Office2003PIA\O2003PIA.exe' Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Common.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Interop.Outlook.Installed': true Result of checks for command 'Office2003PIA\O2003PIA.exe' is 'Bypass' 'Microsoft Office 2003 PIA Redistributable' RunCheck result: No Install Needed Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Installation of components 'Microsoft Visual Studio Tools for Office Runtime Redistributable' was accepted. Copying files to temporary directory "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\" Downloading files to "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\" (8/9/2007 6:47:10 PM) Downloading 'vstor\vstor.exe' from 'http://go.microsoft.com/fwlink/ LinkID=49612' to 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\' Download completed at 8/9/2007 6:47:14 PM Verifying file integrity of C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\vstor\vstor.exe WinVerifyTrust returned -2146762749 Subject form unknown Running checks for package 'Microsoft Visual Studio Tools for Office Runtime Redistributable', phase BeforePackage Attempting to find 'Microsoft.Office.Tools.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Common.Installed' Attempting to find 'Microsoft.Office.Tools.Outlook, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Outlook, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Outlook.Installed' Attempting to find 'Microsoft.Office.Tools.Word, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Word, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Word.Installed' Attempting to find 'Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Attempting to find 'Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil' in the Global Assembly Cache AssemblyCheck: Error querying assembly info: -2147024894 Unable to find assembly in GAC Not setting value for property 'Microsoft.Office.Tools.Excel.Installed' The following properties have been set for package 'Microsoft Visual Studio Tools for Office Runtime Redistributable': Running checks for command 'vstor\vstor.exe' Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Common.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Outlook.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Word.Installed': false Result of running operator 'ValueExists' on property 'Microsoft.Office.Tools.Excel.Installed': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of checks for command 'vstor\vstor.exe' is 'Install' 'Microsoft Visual Studio Tools for Office Runtime Redistributable' RunCheck result: Install Needed Verifying file integrity of C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\vstor\vstor.exe WinVerifyTrust returned -2146762749 Subject form unknown Error: Setup has detected that the file 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\VSD146.tmp\vstor\vstor.exe' has changed since it was initially published. Thanks in Advance Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 5
    - Outlook Synchronization with Redemption (was: How to schedule the retrieval Outlook Items in the background?) I have a VSTO SE Outlook 2003 add-in. Periodically, I would like to retrieve appointment items that will occur (any time in the next six months) from different mailboxes on an Exchange server and store them in a file. This can involve hundreds or even thousands of appointments. If I can somehow limit the retrieval to information that has changed since the last time the data was retrieved for a particular mailbox, then the exchange admin s , network admin s and users will be happier. My questions are: - Does Outlook w/ Exchange offer any way of optimizing synchronization so that only items which have been created, updated or deleted since the last synchronization event are retrieved I know that the Outlook Object Model (OOM) Find and Restrict methods allow you to filter on [LastModificationTime] but a problem appears to be that this doesn't help identify a) deleted items or b) items marked as private by others. (The reason I want items marked as private is to get start/end/busystatus information.) - To invoke a periodic retrieval I appear to have a range of options including a) a Windows service with a server timer instance that calls a method associated with a background thread in my add-in on a specified interval, b) a background thread-based timer that operates within the add-in and c) an entirely separate Windows app that uses one of these two timer approaches without the add-in being loaded. What might work the best here - I know there are a range of commercial synchronization tools available but they all appear to be costly, propietary and requiring a database and/or web server. I'm not sure how they would be more efficient to run than the options I suggested above. Any insight on any aspect of this issue would be appreciated. Thanks, Tad Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 6
    - Outlook 2007 BeforeFolderMove event Hi there, I'm trying to programatically from my add-in attach to BeforeFolderMove Outlook event. I noticed, that when we have a lot of folders (20-30), on some folders this event is not fired during the folder move/delete action. The reason should not be garbage collection, because we do keep in-memory list with all folder objects. Any idea or suggestion will help. Thanks, Sasa Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 7
    - ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Hi, I have upgraded a Excel VSTO 2003 solution to VSTO 2005. Now, I am about to deploy this to my end-users. However, I need to automatically migrate the existing Excel workbooks created which refer to the 2003 Solution (via _AssemblyName0 and _AssemblyLocation0 custom properties) to use the new 2005 solution. I realize this involves embedding a Runtime Storage Control activeX component within the Excel document. Therefore, I employed a technique provided by MS as part of a solution called ApplicationManifestEditor. Essentially, it tries to add the Runtime Storgage Control to a document by using the ServerDocument.AddCustomization(...) method. Unfortunately, when I try this methodology I get an COMException as shown below. The parameters I am passing to the AddCustomization method are: documentPath = "C:\MyDirectory\OldExcelWorkbook.xls" assemblyName = "C:\MyVSTO2005Solution\MyAssembly.dll" manifestPath = "" applicationVersion = "1.0.0.0" makePathsRelative = true / false (tried both). Could you please assist me in resolving this issue Thanks, Tim System.Runtime.InteropServices.COMException (0x80040407): Exception from HRESULT: 0x80040407\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.IAppInfoDocument.SetDocument(String fileName, Byte[] bytes, FileAccess access)\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.GetOfficeDocument()\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.EnsureDocument()\r\n at Microsoft.Office.Tools.OfficeAppInfoDocument.WriteItem(String element, String id, Byte[] item)\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.AppInfo.WriteManifest(IAppInfo appInfo, String manifest)\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.Customizer.CustomizeDocument()\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.Customizer.Customize()\r\n at Microsoft.VisualStudio.Tools.Applications.Runtime.ServerDocument.AddCustomization(String documentPath, String assemblyName, String deploymentManifestPath, String applicationVersion, Boolean makePathsRelative)\r\n at ApplicationManifestEditor.ApplicationManifestEditor.AddCustomization(String fileName) in D:\\Data\\Visual Studio Projects\\ApplicationManifestViewer\\CS\\ApplicationManifestEditor\\ApplicationManifestEditor.cs:line 504" string Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 8
    - Outlook 2003 - Appointment's label information The setup: Visual Studio 2005 VSTO 2005 SE .NET 2.0 Windows XP, SP 2 - 32-bit. Outlook 2003 (Office 2003). Exchange Server 2003. The problem: I am developing an addin for Outlook 2003 to capture user's data. The question is how can I get the value of the appointment's "Label" drop down list. To be more specific, in Outlook 2003 do the following: 1. Click on the File menu -> New -> Appointment. 2. See the "Label" drop down list with the values: - None. - Important. - Business. - Personal. - Vacation. - Etc. If it is possible to get the selected value, is it also possible to add custom values to the list as well Thank you in advance. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 9
    - Visual Studio 2005, display in secondary monitor help. Hi all, I have a form that is a playlist control for powerpoint slides that I would like to run as a control panel on the primary display monitor, but have the form display and run the powerpoint slides on the secondary display monitor. I am using a dual monitor video card. Could someone be kind enough to point me in the right direction as to how to accomplish this. Thanks in advance. Thase Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 10
    - COM Exception in CommandBars["Task Pane"].Visible = true I am getting this occasional COM error when trying to ensure that Document Task pane is visible: This code: Globals.ThisWorkbook.Application.CommandBars["Task Pane"].Visible = true; Causes this exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at Microsoft.Office.Core.CommandBar.set_Visible(Boolean pvarfVisible) Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 11
    - Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Has anyone tried to follow along with the new article on "Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2)" The article is here: url:http://msdn2.microsoft.com/en-us/library/bb332051.aspx About half-way through Part 1, the following instructions appear, leaving me perplexed: Preparing the Office Component Check Compile the Office component checker sample for the primary interop assemblies redistributable packages Important: If you are using VSTO 2005 SE in conjunction with VSTO 2005, ensure that you have installed both the .NET Framework 2.0 software development kit (SDK) and the Windows SDK. Here's my question: Which Windows SDK should I install I'm running VSTO 2005 SE with VSTO 2005 on WinXPSP2. I assume that I should install a Windows SDK specific to WinXPSP2, but I can't figure out what file that would be I can find Platform SDKs for Vista and WinServer 2003. Should I be looking for a "Platform SDK" for WinXPSP2 Or should I be looking for a "Windows SDK" as listed in the article Where can I find the SDK -- Bill Coan billcoan@wordsite.com Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 12
    - Can't get Wordeditor property from the Inspector.Activate event in the Outlook07 Hi! I created an outlook-addin for the Outlook 2007, and I tried to get the word editor property from the Inspector.Activate event, it works well in the normal cases. But if I open a new outlook, then double click an email under the "Draft" or the "Inbox" folder, I found I can't get the Wordeditor property in the Inspector.Activate event! And I have searched in the MSDN, it just says "In Outlook 2007, the Inspector.WordEditor property does not work in the NewInspector event. To work around this issue, implement the Inspector.Activate event, and then use the Inspector.WordEditor property in the Inspector.Activate event. " Why we can't get the WordEditor property in the Inspector.Activate event in this case Any work around My outlook version is 12.0.4518.1014. TIA!!! Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 13
    - Mdac i am trying to add to my vs2005 the vstools (to add a new pane to a office word) amazingly no metter what i try. the installation failed something about Mdac...... i do not want to uninstall my vs2005 but it seems that all the roads send me there.... how do I know what is my mdac and how can i downgarde it Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 14
    - beforeSave or.... Hi! What should I use in order to trigger some actions after a user saves an xls file Is beforeSave ok or should I use something else Thanks! Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 15
    - How to add words to MS Word custom dictionary I am trying to use the MS Word spell check in my application. It is fine for words witch are in the main dictionary. For my functionality to be complete I need to add the option of adding words to the custom dictionary so that they are not constantly shown as mistakes. I am opening the .CustomDictionaries.ActiveCustomDictionary file and adding the new word but at that moment MS Word deselects that dictionary for use. It is possible to reselect it again by going in the Options menu in MS Word but that is annoying. So how am I supposed to add words to the MS Word Custom dictionary Best regards Stoil Pankov Private Function AddToCustomDictionary(ByVal wordToAdd As String) As Boolean Try Dim customDictionaryFile As System.IO.FileStream Dim filePath As String = "" Dim byteArray As Byte() Dim encoding As System.Text.Encoding encoding = System.Text.Encoding.GetEncoding(1251) If Not wordApp.CustomDictionaries.ActiveCustomDictionary Is Nothing Then With wordApp.CustomDictionaries.ActiveCustomDictionary filePath = .Path & "\" & .Name End With customDictionaryFile = System.IO.File.Open(filePath, IO.FileMode.OpenOrCreate) customDictionaryFile.Position = customDictionaryFile.Length byteArray = encoding.GetBytes(vbNewLine & wordToAdd) customDictionaryFile.Write(byteArray, 0, byteArray.Length) customDictionaryFile.Flush() customDictionaryFile = Nothing End If Return True Catch ex As Exception Throw ex End Try End Function Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 16
    - Newly Added Document is NOT the Active Window Hi everyone, I created a add-in for Word using vsto. I got a form that show to the user and when a buttoon on that for was clicked, the add will add a new document using this.Documents.Add(<params>). The new document was successfully created but it was not the active window. The first document when I opened word was still the active window. I'm using Document.Activate() to make the new document active but its not working. I'm using C#. Button_Click() { frm.Hide() Application.DoEvents(); CreateDoc(); } void CreateDoc { docNew = this.Documents.Add(<params>); docNew.Activate(); } I hope you can help me with this. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
- Next
  - 1
    - Undo and Redo in Office automation in .Net 1.1--Urgent Help needed I am using a window based application in .Net1.1(C#), where I am using Office 2003 PIA. In this application I am caputuring Ctrl-V and doing pastespecial functionality of Excel. But after pasting I am not able to Undo or Redo to previous state. Below are my code after capturing CTRL-V below code function I am executing public void ExcelPaste() { try { IDataObject objPresumablyExcel = Clipboard.GetDataObject(); if (!(objPresumablyExcel == null)) { if ((objPresumablyExcel.GetDataPresent(DataFormats.CommaSeparatedValue))) { Microsoft.Office.Interop.Excel.Worksheet TheSheet = null; TheSheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.ActiveSheet; object omissing=Missing.Value; TheSheet.PasteSpecial("XML Spreadsheet", false,false,omissing,omissing,omissing,omissing); } } else { MessageBox.Show("Clipboard is empty!"); } } catch (Exception exp) { MessageBox.Show(exp.Message); } } Please help me how can I handle the undo and redo functionality. I tried with Application.Undo(). but it didn't help me. I need the same functionality as in Excel. Thanks in advance. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 2
    - VBA SDK for Office 2007 Add-in Hi All, Which version of VBA SDK should be used to build Add-in for Office 2007 developed in VC6. regards Priyanka Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 3
    - Excel worksheet ActivateEvent Converting some VBA to VSTO. Trying to wire up worksheet event handler at run time - using VB. Works fine for most events (Deactivate, BeforeDoubleClick, etc) but can't assign ActivateEvent handler. What am I missing Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 4
    - Outlook addin stops responding Hi, We have built a VSTO-SE add in for Outlook 2003. Our add-in functionality can be be initiated in 2 ways, manually or can be set to initiate after given period of time, something like "auto send/receive mail" functionality. But sometimes when our add-in initiates a process (e.g. auto initiate process) outlook stops responding and crashes. We have to forcefully kill the Outlook process. This is happening more frequently now. Some possible reasons that we came across are: When we are switching between mail folders sometimes outlook freezes. User is checking for new mails when outlook freezes. We have not been able to replicate this issue with debug mode on. Is there any explanation for this behavior. Regards Sid Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 5
    - Exchange Server, Outlook and VSTO The setup: Exchange Server 2003, Outlook 2003, VSTO 2005 SE, Visual Studio 2005, .NET 2.0, Windows XP SP2. The problem: When composing a new email Outlook resolves the email address with the user's full name (if it is known). For example, if I write the email: jsmith@company.com , the it would be resolved to "John Smith" and shown as an underlined link in the "To" text box. I have searched the web and found that it is possible to use some external libraries to get the address from the name (eg: CDO, Redemption, etc.. ). My question is whether there is a way to stop Outlook from doing this name-email resolution in the first place. In other words, is there a way to stop converting jsmith@company.com to "John Smith" Thank you in advance. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 6
    - Access controls in different document instance (VSTO 2005) Hi, I have two different documents (A and B) and both have the same VSTO customization attached to them. [Actually I first create A and later open B and attach through the ServerDocument classe the VSTO solution]. How can I access a control instance (RichTextBox) of document A from B I got as far as this: // from document B, I try to find A // iterate over the open documents foreach (Word. Document parentDoc in Application.Documents) { if (parentDoc.Name.Equals(��A��)){ // iterate of controls in document A System.Collections. IEnumerator en = this .Controls.GetEnumerator(); while (en.MoveNext()) { MessageBox .Show( String .Format( "Field: {0}" , en.Current.ToString())); } } } Thanks for any hint! Claudia Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 7
    - Replacing entire folder view with custom user control. (Outlook 2007) In Outlook 2007, I'm trying to replace an entire folder pane / folder view when you select a folder to have a custom user control instead. The closest I can get is using a custom task pane, however, that is limited to how big it can be. I keep running into an advertisement from add-in-express which their product is able to do, but I was hoping for a less expensive solution to this. Replacing a web view with a customer user form / control would work too. The solution to this would be greatly appreciated. Thanks! Note: I've taken a look at the 2003 CRM sample, but it doesnt' work with Outlook 2007. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 8
    - Fixing Bad Office.Core Refernce in xl2003 Application Add-In Hope I'm nearing the end of questions here, and thanks again for reading. I have a Excel2003 Applcation Level Add-In made using VSTO with SE download. Deployment package is made, I can see that registry entries are being made, that CAS policy has full trust and that prereqs are loaded. I have set the suppressdisplayalerts environ variable =0 to see why the add-in is not loading and i have the following: Could not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. Could not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. ************** Exception Text ************** System.IO.FileNotFoundException: Could not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at SEI_IMU_xl2003_AddIn.XLAddIn.DeleteMenuBarIfExists() at SEI_IMU_xl2003_AddIn.XLAddIn.ThisAddIn_Startup(Object sender, EventArgs e) at Microsoft.Office.Tools.AddIn.OnStartup() at SEI_IMU_xl2003_AddIn.XLAddIn.FinishInitialization() at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.ExecutePhase(String methodName) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.ExecuteEntryPointsHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Microsoft.VisualStudio.Tools.Applications.Runtime Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.891 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll ---------------------------------------- Microsoft.Office.Tools.Common Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.891 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- Excel_AddIn Assembly Version: 1.0.0.0 Win32 Version: 1.0.0 CodeBase: ____ (stuff omitted here intentionally) ---------------------------------------- Microsoft.Office.Interop.Excel Assembly Version: 11.0.0.0 Win32 Version: 11.0.5530 CodeBase: file:///C:/WINNT/assembly/GAC/Microsoft.Office.Interop.Excel/11.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll ---------------------------------------- Microsoft.Office.Tools.Excel Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.891 CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll ---------------------------------------- office Assembly Version: 11.0.0.0 Win32 Version: 11.0.5530 CodeBase: file:///C:/WINNT/assembly/GAC/office/11.0.0.0__71e9bce111e9429c/office.dll ---------------------------------------- Now, I started this as an Excel2003 Add-in, and obviously it's pointing to the version 12.0 assembly for Excel 11 object model. When i look at the properties in the references to microsoft.office.core i see that gac/office/12.0.0.0 reference when the test machine wants 11.0.0.0 So, really simple question here (and i'm excited to be near then end of this)....How exactly do I manually remove that reference and add the right one I'm generally familar with adding references but i don't know how to find the specific one i need here. Thanks in advance, Greg Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 9
    - How to use XP visual Styles on an Office (Excel) Add-in Hello, I'm using Visual Studio .NET 2005 and I was wondering if nice XP Visual Styles can be applied to the windows and dialogs that i use on my office add-in. since it's a library i cannot check the checkbox "Enable Applicaiton Framework" neither "Enable XP Visual Styles". I've found this article but i'm using VB.NET and don't know how to translate the "using" statement. Can anyone help me or explain to me at least general steps to get this to work on VB.NET thank you Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 10
    - Creating Add-ins I am using Excel quite well, but I want to make something more on Excel. I want to prepare a custom menu, which includes some special statistical functions for special purposes. Which is the appropriate environment to develop an installable add-in in Excel Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 11
    - A Toolbar for MS Word 2003 Hi, I made a program with visual basic.I want that people can access my program while writing a word document.In fact i want to make a toolbar for MS Word 2003 and with this toolbar people can able to run my program. If you help me i will be very happy. Thanks. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 12
    - Excel Edit Delete Disabled I created an Excel Workbook project using Visual Studio and VSTO. This project uses the ListObject control bound to a DataTable to display and update data in SQL Server 2000 database. When deployed to the user's workstation, this application has an annoying habit of disabling the Delete item on the Edit menu, preventing the user from deleting columns, rows or cells. Actually this is more than annoying - it's a show stopper. Researching the problem online produced very little in the way of amswers. Are other people seeing this behavior I did find a reference in this forum article: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=309265&SiteID=1 which suggests deleting Application Data\Microsoft\Excel\Excel11.xlb. This works, but its not acceptable to require the user to delete this file every time their Edit menu goes wonky. Does anyone know how to create and deploy a VSTO Excel Workbook application in such a way that prevents this problem from occuring Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 13
    - Assigning values to Custom Text boxes on a new e-mail form in Outlook 2007 I use the following code to assign values to already defined fileds Dim theStringBuilder As New Text.StringBuilder() ' String of characters theStringBuilder.Append( mailto:MYWORKPLACE@ DOMAIN ) theStringBuilder.Append( "&subject=PhoneCall" ) theStringBuilder.Append( "&body=my body message" ) However, when I want to assign a value to one of my Custom Text boxes like 'Caller' which is just a textbox and have it displayed on the form using a line like; theStringBuilder.Append( "&Caller=NAME" ) I do not see any values displayed in the textbox on the form! Stringbuilder does not seem to recognise the Custom textboxes. For some reason I can only get this to work by adding code in the VBScript window in the design view of the e-mail form, but I need this to work in Visual Basic, not VBA. Could someone tell me how to do this Thanks. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 14
    - Target either Excel 2003 or 2007 I want to develop a routine in c# 2.0 to make some simple modifications to an existing Excel document. The target machines may have either Excel 2003 or 2007. I have 2007 on my machine but could add 2003 if necessary. What do I load in to VS2005 to develop such an application Thanks, Nigel Stratton Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 15
    - OUTLOOK 2003 Resource Booking ?????? Using VSTO 2005 So, my is ... At what point is the Resource Booked I have code that I would like to "hold" from processing until I know for sure that the resource has been booked! Is there anyway to do something like this Thnks Bill Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office
  - 16
    - Executing default SmartTag Action Menu Item programatically... Hi all, From the available default action menu items, how can we execute 'Remove This Smart Tag' action item programatically in c# If we check the doc.SmartTags.get_Item( ref index).SmartTagActions.Count property, it returns the custom action items count. Not includes the default action items. Looking for a way to execute the first default action item. Thanks in advance. Tag: Visual Studio Tools for Office Excel automation : formating dissapears Office

r3c

Hello,

I need to format a formula in a cell on an excel sheet. I'm generating the sheet completely from code that I wrote in VB.

So I figured out a way to express my formulas in such a way that I can create them programatically and interpret them later on to make them show correctly on the sheet.

I need to put some parts of text in subscript. I tried it several ways:
cell.Characters(st, ln).Font.Subscript = True directly in vb code will at best put everything in subscript.

Another option I ended up implementing was a simple macro piloted by the two integer values that works on the active cell. It works as far as I could see but the formating dissapears once I change the active cell and it is very slow!

Can anyone please help me, I need a solution for this problem before I continue coding some more of my industrial plant.

Top