Publishing VSTO Add-in on github pages
I have develop a VSTO Excel Add-in with C#. And I have prepared docs using mkdocs deployed on github pages. So two seperated git repositories.
Goal
What I want to achieve is that users (a very limited number of them, btw) will be able do
- Download installer from my github pages docs
- Install
- Recieve updates automatically (from github pages URL)
My attempt
So, my current workflow is as follows:
- I publish my solution through VS. I publish it directly to the
docs/files/folder (my publishing folder according to VS), so the users have access directly to the.exeand.vsto. The installation URL is set to my github pages. - I think I am signing the clickonce manifest and the assembly with my test certificate.
- Deploy github pages with publish files from VS
And that's it. The files are there. I can download the installer.
The issue I can't fix
Local
- I clean the VS solution.
- Download the executable from my github pages (as normal users will)
- Install.
- WORKS!
A different computer
- Download the executable.
- Try to install, but the installer complains that
Customized functionality in this application will not work because the certificate used to sign the deployment manifest for AddIn or its location is not trusted.
Question
I don't want to pay for a certificate, just so that a handful of users could use this add-in. Is there anything I can do so the users will be able to install it anyway? Or should I just forget about any user being able to install months of my work?
EDIT:
What's also weird is that I can remove the installation path, publish with VS, copy publish directory to USB, transfer to a different computer and install without a problem. I just don't get it anymore.
The error means what it says - the certificate you used is not trusted, so you need to ask your users to install your certificate first before they install your VSTO addin.
If you don't care about the private key in the PFX file, you can just make it available. Or you can export just the public key.
- How to make Colors Mixer in vba
- How to get HEX color value from cell color?
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- How to randomize Excel rows
- VLOOKUP Returns 0 even though there is a value in the line below the first result
- transpose a table with multiple values in excel
- Trying to late bind outlook to but getting type mismatch error after create object line
- Power Query Transform a Column based on Another Column
- Apply FILTER formula to array (and use filter criteria on specific column in the array)
- Bitly API call using VBA Excel Macro
- excel vba projects not closing
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Sigma or Summation function in Excel
- Problem getting the value from a cell using M in excel
- INDEX MATCH to also pull through notes
- Move formatted data in selection from Excel into Word tables
- Excel VBA function to remove letters at end of string
- Can't get all excel processes to stop when closing through Powershell
- Excel function to construct an array from values without VBA
- Alternative method to delete file with out having to add MS Scripting Runtime Reference
- Add new button to worksheet with Excel Add-in
- Apply outline border only to range of cells with openpyxl
- How to Separate Data with Inconsistent Patterns into a Structured Format in Excel
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- How to reference the current User\Desktop location in VBA
- Powerpoint chart to excel relative link
- EXCEL: How do I return multiple columns using XLOOKUP, when the lookup_value is a range?
- VBA: How to Loop IF Statement through a Cell and Chart Series
- Incorporating Checkbox to lines of code rather than Cell value
- How do I remove a character from a column of data in Excel