Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,798 questions
customized menu items of my excel Add-In application
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 95%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Julie Shen
1
Reputation point
HI, Team,
my Excel Add-In application was developed by .net 4.7. I add some menu items into right click menu in order to i can execute that function eg(Refresh Sheet) with VBA code, this works well for past years.
but recently, there is a client report a issue that he can't see those customized menu items of my excel Add-In application,
so when he execute those functions with VBA code, it report error "Invalid procedure call or argument".
it's weird that the related code hasn't change for years and I can't also reproduce this issue.
can someone help check what reason will cause those customized menu items of my excel Add-In application to be disappeared?
thanks,
{count} votes
-
DaisyTian-1203 11,626 Reputation points2020-12-07T07:27:08.24+00:00 @Julie Shen
Is it an Excel VSTO addin project? If it is, vsto development is currently not supported in the Q&A forums, please ask your question in Visual Studio Tools for Office (VSTO). If I misunderstand your questin,please point out. -
Julie Shen 1 Reputation point
2020-12-09T09:16:41.13+00:00 Hi, Daisy,
our add-In project is not VSTO. our project is a desktop excel Add-In, and it will use ExcelDna.xll. I am not sure if our client issue related to ExcelDna.xll, if it is because he update his excel to the latest version and not compatible with the ExcelDna version we use. since he haven't faced this issue before.
thanks, -
DaisyTian-1203 11,626 Reputation points
2020-12-10T01:56:06.503+00:00 @Julie Shen According to my understanding, you installed
ExcelDna.AddInin your Class Library project's NuGet Package Manager, and there was a error after Nuget package was upgraded without any changes to the project,right? -
Julie Shen 1 Reputation point
2020-12-10T02:08:31.54+00:00 Hi,Daisy,
we haven't upgrade our ExcelDna in our Add-in project for many years, and we can't reproduce this issue.
this issue can only be reproduced by one of our client. I am not sure if this because he upgrade his excel and the latest excel version has some conflict with the old ExcelDna in our project.
Sign in to comment
Sign in to answer