VSTO | Excel Add-in samples and using macro in add-in | Reflection library

by tugrulkarakaya C# Version: Current License: GPL-3.0

X-Ray Key Features Code Snippets Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | VSTO Summary

VSTO is a C# library typically used in Programming Style, Reflection applications. VSTO has no bugs, it has no vulnerabilities, it has a Strong Copyleft License and it has low support. You can download it from GitHub.

Excel Add-in samples and using macro in add-in. There are more than one Excel Add In project under the solution. to debug each of them do not forget changing startup proıject in the solution by right clicking the solution and changing start up solution. To run Macros from Add-In You nned to change trust center settings. Go to File and Options in the Excel app and select Trust Center. Go to Macro Settings and Enable developer Macro Settings.

Support

Quality

Security

License

Reuse

Support

VSTO has a low active ecosystem.

It has 3 star(s) with 3 fork(s). There are 1 watchers for this library.

It had no major release in the last 6 months.

VSTO has no issues reported. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of VSTO is current.

Quality

VSTO has 0 bugs and 0 code smells.

Security

VSTO has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

VSTO code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

VSTO is licensed under the GPL-3.0 License. This license is Strong Copyleft.

Strong Copyleft licenses enforce sharing, and you can use them when creating open source projects.

Reuse

VSTO releases are not available. You will need to build from source code and install.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of VSTO

Get all kandi verified functions for this library.

VSTO Key Features

No Key Features are available at this moment for VSTO.

VSTO Examples and Code Snippets

No Code Snippets are available at this moment for VSTO.

Community Discussions

Trending Discussions on VSTO

Is there any way to prevent outlook from disabling addins?

How do I create an Outlook add-in that alerts the user when they attempt to reply to senders that are outside of their domain?

Closed excel workbooks remain in VBA IDE

Outlook Node addin: store emails locally / in outlook data file

Excel VSTO refuses to load on particular machine

Catch VBA Errors in VB.Net/VSTO

C# VSTO word AddIn Throws value does not fall within expected error

WebView2Loader.dll not found is Outlook VSTO addin

Can we debug .NET desktop apps in Docker container

Visual Studio Pre-build action to embed external xml file

QUESTION

Is there any way to prevent outlook from disabling addins?

Asked 2022-Apr-15 at 13:47

i developed an addin for outlook 365 with c# .net45 vsto. Users complain that outlook disables the plugin because it slows down its launch. The plugin at outlook startup does nothing, not even in the ribbon load. Reading the Microsoft documentation https://docs.microsoft.com/en-us/office/vba/outlook/concepts/getting-started/support-for-keeping-add-ins-enabled to avoid disabling the plugin you need to create two registry keys below

...

ANSWER

Answered 2022-Apr-15 at 13:47

There are multiple reasons why your add-in could be disabled. One of them is exceptions at runtime. In that case (if it throws exceptions at runtime) your add-in will be disabled anyway. So, I'd suggest excluding most-spreaded factors first.

Typically you need to add a new key with a ProgID of the add-in set to 1 which stands to always enabled. For example, I've found this image while searching over the internet:

But anyway I'd recommend optimizing your add-in as the Preventing add-ins from being disabled section states.

Source https://stackoverflow.com/questions/71872892

QUESTION

How do I create an Outlook add-in that alerts the user when they attempt to reply to senders that are outside of their domain?

Asked 2022-Apr-03 at 16:43

I am new to coding in c#. I am currently trying to create an Outlook add-in to prompt and alert users if they are to attempt to reply to anyone that is not from "@abc.com". For example if 'ben@abc.com' is to trying to reply to 'jack@def.com', a window to alert Ben will be prompted warning him "You are about to reply to someone that is not from '@abc.com'." with the options of 'ok' and 'cancel'.

I referred online for the code below but this add-in only allows me to edit the field values of the email I am trying to send. I am unable to even figure out how to address and implement the code to deal with replying. I have tried researching online and have seen methods like .reply() but I am confused as to how to apply them.

...

ANSWER

Answered 2022-Apr-03 at 16:43

Firstly, you are only tracking Inspectors.NewInspector event. But in most cases replies will be inline - you also need Explorer.InlineResponse event (where Explorer comes from Application.ActiveExplorer, which can be null on startup, so you'd also need Application.Explorers.NewExplorer event).

Secondly, you will need to loop through all recipients in the mailItem.Recipients collection, and for each Recipient, check the Recipient.Address property (which you can test for the match).

Source https://stackoverflow.com/questions/71685995

QUESTION

Closed excel workbooks remain in VBA IDE

Asked 2022-Apr-03 at 08:53

Summary

My dead simple Excel workbook myTestBook.xlsb has a single empty table and a single code module with the routine test_openclose() inside. This routine just opens another Excel workbook (Mappe3.xlsx), then closes that workbook again.
When the routine is run (Alt-F8) with the VBA IDE closed, everything is fine.
When the routine is run (Alt-F8) with the VBA IDE opened, the intermittently opened workbooks keep getting listed in the IDE's project explorer. Each repetitive run leads to another entry in the IDE's project explorer.
Why is that and what can I do against this effect?

View after 6 runs with closed IDE (no entries) and 3 runs with IDE open (3 entries):

You can also see that the Workbook Mappe3.xlsx which is getting imported, is very simple too: just a single (empty) table, no named ranges, no internal or external references, no modules.

Code

I am using
° MS Windows 10 Pro x64, 10.0.19042
° Excel365 (V2201 - 16.0.14827.20158, 64bit)
° Microsoft Visual Basic for Applications 7.1, Retail 7.1.1119, Forms3: 16.0.14827.20024

...

ANSWER

Answered 2022-Apr-03 at 08:53

The effect does not show when the workbook is closed differently:
with the code

Source https://stackoverflow.com/questions/71189237

QUESTION

Outlook Node addin: store emails locally / in outlook data file

Asked 2022-Apr-02 at 03:39

we are currently developing addins for email clients, one for Outlook, one for Thunderbird, to be able to encrypt and decrypt emails based on attribute-based encryption.

As our goal is to encrypt in-transit, one requirement is to store once decrypted emails locally on the file system, such that it is possible to search in decrypted mails within the mail client.

I already found several other addins that create outlook data files (PST) to store data. However, it seems this functionality is not available if one writes an addin based on Node (https://docs.microsoft.com/en-us/office/dev/add-ins/quickstarts/outlook-quickstart?tabs=yeomangenerator). If one writes an addin via VSTO (https://docs.microsoft.com/en-us/visualstudio/vsto/walkthrough-creating-your-first-vsto-add-in-for-outlook?view=vs-2019) it seems to be possible.

So my question is if anyone knows if it is possible to realize this via a Node addin, and if so, how to implement it? Or are there other alternatives?

...

ANSWER

Answered 2022-Apr-02 at 03:39

PSTs are for Windows version of Outlook only, there is no way to deal with them from a JS addin. VSTO and Outlook Object Model allow to do pretty much everything that Outlook itself can do, and if not, you can drop down to the Extended MAPI level (native Outlook API) either directly (C++ or Delphi) or through Redemption (I am its author).

Source https://stackoverflow.com/questions/68650262

QUESTION

Excel VSTO refuses to load on particular machine

Asked 2022-Mar-30 at 04:27

We have VSTO addin for Excel, and it is working on all system except one, I got following error from problem machine.

It seems that there is problem of loading this Excel extension, and there is no clue why this will happen on particular system. Error from problem machine is as follows,

...

ANSWER

Answered 2022-Mar-29 at 06:40

You can use the event viewer in Windows to see exception messages that are captured by the Visual Studio Tools for Office runtime when you install or uninstall Office solutions. You can use these messages from the event logger to resolve installation and deployment problems. Read more about that in the Event logging for Office solutions article.

The VSTO_SUPPRESSDISPLAYALERTS windows environment variable can be set for enabling detailed Outlook and VSTO (Visual Studio Tools for Office) error messages when loading VSTO add-ins. See How do I enable VSTO error / display alerts?.

Source https://stackoverflow.com/questions/71656385

QUESTION

Catch VBA Errors in VB.Net/VSTO

Asked 2022-Mar-21 at 19:07

I have search on this site and beyond for an answer to these questions, and also trawled through a collection of VB/C# books I have on VB/VSTO. So far I've drawn a blank. I've posted the same question on a VB.NET facebook group, and if I get a solution, I'll post it here so it'll help others.

I am developing an application-level Add-In for Excel using VB.Net & VSTO.

Part of the functionality involves opening .xlsm (Excel macro-enabled) files. I have three questions I hope you can help me with.

I want to open each xlsm file with macros enabled, but not launch any Auto_Open macro in the xlsm file, or trigger the Workbook_Open event. Is that possible?
The xlsm file may have it's own ribbon attached to the file. Is it possible to inhibit the xlsm's ribbon from being added?
The xlsm file may have ActiveX controls that are connected to VBA macros. If a VBA macro produces an error, is it possible to catch the error in the .NET Add-In? The error may include "macro not found"

For info, at present I disable macros using the code snippet below. Whilst that helps with item #1, it doesn't help with items #2 or #3 (in fact, disabling macros is the cause of item #3).

Currently when I open the xlsm file(s) I disable macros using the following code:

...

ANSWER

Answered 2022-Mar-21 at 19:07

The xlsm file may have ActiveX controls that are connected to VBA macros. If a VBA macro produces an error, is it possible to catch the error in the .NET Add-In? The error may include "macro not found"

COM add-ins (represented by VSTO add-ins) and VBA macros are entirely different entities. You can't handle VBA errors in COM add-ins, or the opposite. But you may react to the application events, see Object model (Excel) for the list of available events.

The xlsm file may have it's own ribbon attached to the file. Is it possible to inhibit the xlsm's ribbon from being added?

To prevent the custom ribbon UI from loading you need to edit the file by removing the ribbon XML customizations contained inside the Excel file. VBA doesn't deliver any UI customizations nowadays. You can use the Open XML SDK for editing open XML documents on the fly from VSTO add-ins without involving the host application or its object model.

Source https://stackoverflow.com/questions/71558547

QUESTION

C# VSTO word AddIn Throws value does not fall within expected error

Asked 2022-Mar-10 at 15:52

I am new to VSTO word Addin,the end goal is to check if the custom document property exists.Read all the available articles online with no breakthrough.

Started of with this code

...

ANSWER

Answered 2022-Mar-10 at 15:22

You can iterate over all properties and check their names, compare two approaches:

Source https://stackoverflow.com/questions/71426444

QUESTION

WebView2Loader.dll not found is Outlook VSTO addin

Asked 2022-Mar-03 at 14:07

I read allot about the WebView2Loader.dll - file not found issue, but couldn't solve the problem in my case:

A simple Outlook VSTO add-in with FormRegion, Inside the FormRegion I placed the WebView2 control, and initialized it:

...

ANSWER

Answered 2022-Feb-23 at 17:03

First of all, make sure the WebView2 Runtime is installed on the system. You can read more about that in the WebView2 Runtime installation section in MSDN.

WebView2Loader.dll is a native and architecture-specific binary, so you need to include all flavors of this binary that you expect your app to run in. For example:

For x86, you would include the x86 version of WebView2Loader.dll.
For a managed app using AnyCPU, you would include the x86, x64, and arm64 versions of WebView2Loader.dll. The correct version of WebView2Loader.dll is loaded from the appropriate architecture-specific folder.

Make sure that you included all the required platform-specific assemblies. Read more about that in the Files to ship with the app article.

BTW I have found a similar issue - Unable to load DLL 'WebView2Loader.dll': The specified module could not be found.. It is very close to what you are describing.

Source https://stackoverflow.com/questions/71232454

QUESTION

Can we debug .NET desktop apps in Docker container

Asked 2022-Feb-28 at 04:43

(The more I dig this, the more confusing it gets. I have found Windows images available to download, but none of them appears to be the standard desktop OS)

Is there a way to debug my .NET Framework or .NET Core/5/6 desktop application (WinForms, WPF, VSTO) in a Docker container running Windows 10? I'm just trying to setup a playground environment that I could put together quickly and test my code.

...

ANSWER

Answered 2022-Feb-28 at 04:43

For my own notes and any future beginner, here is my current finding:

Docker is not a full-fledged virtual machine like what we get with VirtualBox, VMWare etc. It's more like a process in an isolated environment, called a Container. For example you could create a container that runs an instance of MySQL, or a container that runs an instance of NodeJS. Of course there are images containing Operating System too, such as Ubuntu, Alpine or even Windows, but those images do not contain the full desktop environment; they are just the base OS services.

So answering the question, no, this is not (currently?) possible at least for Windows. People have had success running Ubuntu desktop inside a Docker container, but that is an advanced topic and only works in Linux-based containers. I haven't seen anything like that for Windows.

Source https://stackoverflow.com/questions/71182533

QUESTION

Visual Studio Pre-build action to embed external xml file

Asked 2022-Feb-25 at 13:46

I'm on visual studio 2019 and developing a VSTO application using C#. I'm using WPF and MVVM by use of VSTOContrib library. The library uses naming convention to couple view (xml file) and viewmodel at runtime by searching the assembly.

The problem:

The view (xml file) is managed externally by non-developers in a separate folder. And this folder's path is unchangeable.

I've come to the conclusion the best course of action would be to embed the file at build time using pre-build actions however after hours of research I've been unable to find any information on the subject.

Has anyone done this before?

...

ANSWER

Answered 2022-Feb-25 at 13:46

Add an itemgroup to your project file:

Source https://stackoverflow.com/questions/71266127

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install VSTO

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: