-
- C# COM server visible in Excel "Insert Object..."
by DAS1108
- 9 Replies
- Last post
by DAS1108
- Hi,
I want to create an C# COM server which will be visible at "Insert Object" in Excel. I found many examples how to create an C# class and use it from VBA. But what I have to do that I can insert such a C# class within an Excel sheet directly without VBA
Of course I need to implement some additional interfaces, but which ones and how in C#.
Thanks.
Daniel
-
- F5 -> "File already exists"
by Victor Hadianto
- 14 Replies
- Last post
by Mike Walker
- Hi,
I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then.
Strange tha
-
- Formatting Currency value in a particular cell of an Excel
by Bharanee
- 3 Replies
- Last post
by Dennis Wallentin
- Hi,
I need to format a currency value in a selected cell of an excel. In which i am getting the currency value as string,for this when i give precision, its not giving the exact result. Let me know the solution.
Getting Value : $10
When i give Decimal Places as 2 its not formatting the value as $10.00. Its format as 10.00 only. I need the currency symbol too in the formatting.
-
- Read only protection of VSTO document crashes Word when reloaded.
by Adrian Leeming
- 12 Replies
- Last post
by Adrian Leeming
- I have a document Template project in VSTO 2005 SE using Word 2003 SP2 11.8125.8122 and Visual Studio 2005 Professional with SP1 installed.
The document template has some cached data and code for a task pane connected to it.
Basically when the user creates or edits a document from the template I need the document to be read only and when items are picked from the task pane I then add new sec
-
- Force ContextLeave Event
by blindi
- 6 Replies
- Last post
by blindi
- If I use TransformDocument(..) in a VSTO2005 Word-solution, and the insertion mark is currently in a XML-Node with an attached ContextLeave-Eventhandler, the event won't fire, but after the transformation the insertion mark is outside of the node. I moved the insertion mark programatically out of the node with Application.Selection.GoTo(..) which worked, but also doesn't fired the event. Is there
-
- VSTO SE Soft disable
by Janni Kajbrink
- 14 Replies
- Last post
by AllTec
- Hi,
I'm having the exakt same problem as described in the following article http://blogs.msdn.com/pcreehan/archive/2006/07/06/vsto-add-ins-and-the-newinspector-event.aspx . I've written an empty VSTO SE add in which is "soft disabled" as soon as Outlook is started without any user interface.
Is there any solution to this problem As most of the users who will be using my add
-
- Can we add an image to CommandBarPopup control?
by Job Lot
- 4 Replies
- Last post
by Job Lot
- Can we add an image to CommandBarPopup control
Thanks
-
- how to deal with each Recurring AppointmentItem?
by fahad11
- 7 Replies
- Last post
by Sue Mosher - Outlook MVP
- hey everyone...
I want to retrieve all the appointments in a week by displaying their information
so the problem that iam facing is when i have a recurring appointment
how can i deal with each appointment in it
for example i got the same meeting in a week lets say (sat,mon,wed) so i want to display each ones data
this is what I've done (outlook 2007 C#)
Outlook. Applicati
-
- Project references confusion - unable to edit while debugging
by wordyone
- 2 Replies
- Last post
by wordyone
- I recently restructured a few of my projects, and now am seeing strange behavior with debugging. I think there may be a problem with my project references but I'm not sure how to fix it.
When I set a breakpoint, it stops there as it should. However, I can no longer edit the code while the project is running. I have checked the project references and re-set them several times within the sol
-
- Using Performance Counter breaks Addressbook and other message windows
by Nick Randolph
- 7 Replies
- Last post
by miodrag.markovic
- In order to optimise the perfomance/usability of our application we have recently introduced a cpu performance counter. Using this counter prevents some of Outlook's windows from displaying properly. The easiest steps to reproduce this error are as follows: Repro 1 - Add the following code to an Addin (perhaps in the event handler of a button): Dim mProcessorPerformance As New System.Diagno
-
- VSTO 2003 Security is a nightmare
by JocularJoe
- 3 Replies
- Last post
by Joe2
- I have a VSTO 2003 Excel Workbook that I want to deploy to a network share.
I¡¯m fairly sure I have the basics right: I have used CASPOL to add a machine-level code group that gives FullTrust to the directory on the network share that contains both my Excel Workbook and the codebehind code (using the url file://server/share/directoryname/* as evidence).
I realize that the elements that need t
-
- R
by mobigital
- 4 Replies
- Last post
by Geoff Darst - MSFT
- When I change Excel zoom from 100% and try to click any winforms controls on the spreadsheet I get this dialog:
Windows Forms controls have been disabled because the document has been scaled. When zoom is returned to 100%, controls will reactivate.
I imagine many users scale their documents due to various screen resolution preferences. Is document scaling other than 100% going to be supporte
-
- Using the Find object to replace with formatted text in Word 2007
by dirty-shirt
- 6 Replies
- Last post
by dirty-shirt
- I'm using VSTO for Word 2007 and I want to implement a function that will find and change text to "dirty#shirt" however the # needs to be superscripted.. I tried using the Find object but I can't figure out the replacement string to enable Word to superscript only the hash character. Any ideas Tim.
-
- Office Service Pack 3 (SP3) and VSTO
by davidMartin
- 9 Replies
- Last post
by AvengingManatee
- Hi, I just heard about the new Office Service Pack 3. http://www.microsoft.com/downloads/details.aspx displaylang=en&FamilyID=e25b7049-3e13-433b-b9d2-5e3c1132f206 As I didn't found any information on this forum about it. I suppose that this new Service pack will not affect addin developped with VSTO 2005 SE, right thanks, David
-
- Hijacking Short cut Keys
by SpoonmanUK
- 3 Replies
- Last post
by Cindy Meister
- Hi, I am writing a C# add-in for Office 2003, and I have managed to capture the Short cuts keys and disable them as a work around, but I would like to know if it is possible to rebind the shortcut keys to call into my Com Addin and not use a macro in Word VBA (for example).
Each time I try, I get the error
'Word cannot change the function of the specified key' which I am led to believe m
-
- VSTO & Outlook custom regions
by Jan Kučera
- 6 Replies
- Last post
by Sue Mosher - Outlook MVP
- Hi,
Is there any support for Outlook Custom Regions in VSTO 2005 SE I mean sample FormRegionStartup class like with Ribbon.... (and perhaps without needing to modify registry manually)
I have tried to follow a couple of walkthroughs (both MSDN and from Outlook blogs) but I have a little successs.
System.ArgumentException: The value entered for the DesignMode property is not valid. En
-
- Programmatically freezing the rows in Excel
by Basani
- 1 Replies
- Last post
by Dennis Wallentin
- I am generating an excel report from a C# WinForm application. Is there a way to programmatically freeze top n rows so that they will be displayed all the time when a user scrolls down through the data
Thanks Basani
-
- Updating Fields in Textbox in Word 2007
by dirty-shirt
- 2 Replies
- Last post
by dirty-shirt
- Hi all,
I've implemented a function in VSTO to update all the fields within a document with the following code:
Code Snippet
Dim fields As Word.Fields
fields = Globals.ThisAddIn.Application.ActiveDocument.Fields
fields.Update()
Everything works except for the fields in textboxes which don't seem to update, instead I have to update them manually. Eve
-
- Two MeetingItem questions
by fahad11
- 8 Replies
- Last post
by fahad11
- hi guys...
i am doing an addin on outlook 2007 using vsto se (c#)
so i want when i recieve a new meeting ...to add it to database
but the problem is that i couldn't deal with the MeetingItem ...to be more detailed i didn't know how to access the subject , date & other stuffs of the Meeting...
so could some one kindly explain to me how to achieve this
my other question is
-
- VBA or .NET?
by Peter Caisse
- 3 Replies
- Last post
by Peter Caisse
- Hi, I'm planning on creating a customized toolbar for Powerpoint 2003 which would have a custom color palette, custom icons, create new slides based on a table of contents, etc. I'm weighing my options trying to decide between VBA and .NET with VSTO 2005. I talked to Microsoft MVP Jonathan West concerning this choice, and his gave me some pretty compelling reasons for choosing VBA, namely: VSTO 2
-
- add-in doesn't load when launching using new excel.application
by Denis Pitcher
- 5 Replies
- Last post
by Denis BDA
- When launching excel via interop, I've noted that the addins don't appear to load.
Dim xlsApp As Microsoft.Office.Interop.Excel.Application
xlsApp = New Microsoft.Office.Interop.Excel.Application
xlsApp.Visible = True
Does anyone have any idea why and how to solve it Otherwise, I need to figure out how to load excel via System.Diagnositics.Process.Start() where I can pass it
-
- Can I Retrieve EntryIDs in bulk
by Waqar Azeem
- 4 Replies
- Last post
by Waqar Azeem
- Can i retrive all the EntryIDs from contact-folder at once, instead of looping through each contact.
currently i am doing this... but it's taking too much time to process large number of contacts.
Outlook. Items olContactFolderItems = olContactFolder.Items;
...
foreach ( object contactItem in olContactFolderItems)
...
string temp = olContactItem.EntryID;
...
-
- Issue opening Excel File w/ Solver.xla add-in in VB6
by whttiger25
- 1 Replies
- Last post
by Dennis Wallentin
- Here is the code the causes the problem:
Private Sub Command1_Click() Dim XL As New Excel.Application, wb As Excel.Workbook, ws As Excel.Worksheet XL.Visible = True Set wb = XL.Workbooks.Open("pxadjcalc.xls", , True) Set ws = wb.Worksheets.Item("parspread")
XL.Run ("SOLVER.XLA!Auto_Open") End Sub
This used to work fine. Then, one day, it st
-
- Embedding PowerPoint, Word, Excel Documents into Visual Basic
by Riceroman
- 1 Replies
- Last post
by Cindy Meister
- All-
Although I figured out how to embed pictures and videos, I know just enough to be dangerous. I'm looking to embed Powerpoint, Word, or Excel files into a Visual Basic form. How does this work and what are the basic instructions
Also, are there are two different call up methods
If the Appication is already open, just retrieve the file
It the Application is closed, open it then r
-
- How to take two more copies for a chart within a worksheet?
by Michael Zh.
- 1 Replies
- Last post
by Michael Zh.
- I wants to make two copies for one of a chart in the same worksheet in my Excel automation tool.
I wrote the code as following:
Excel.ChartObjects mChartObjects = (Excel.ChartObjects)mWorkSheet.ChartObjects(missing); Excel.ChartObject mChartObject = mChartObjects.Add(1,1, 250, 250);
mChartObject.Chart.ChartWizard(mRange, missing, missing, missing, missing, missing, true, missing, miss