UDF's returning #VALUE errors temporarily

Add-in Express™ Support Service
That's what is more important than anything else

UDF's returning #VALUE errors temporarily
 
Subscribe
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi Andrei,

when running the installer we are receiving a message that 'An administrator is required' and are unable to complete the installation.
Posted 10 Oct, 2017 17:25:16 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Sean,

Make sure you install the add-in to the folder the installer suggests, not to Program File. If this doesn't help, I'd like to access that machine remotely. Is this possible? If yes, I suggest using TeamViewer; in this case you'll need to send me your session ID and password to the support email address. If this isn't possible to access the machine remotely, please capture a video and send it to the support email address. When sending us an email, make sure it contains a link to this topic.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 11 Oct, 2017 04:03:38 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi Andrew,

unfortunately I don't have access to the clients machine out of hours (we are in Australia), we haven't changed any settings on the installer, is there anything else that could be stopping it?
Posted 11 Oct, 2017 05:01:15 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Please capture a video showing the installation process from A to Z and send it to the support email address.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 11 Oct, 2017 05:24:50 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi Andrei,

it is a good idea, I am unsure though, will the below code work to remove/reinstall the XLL addin, or does it only work with COM addins?

AddIns addins = null;

try
{

addins = AddinModule.CurrentInstance.ExcelApp.AddIns;
if (addins == null) return;

foreach (AddIn addin in addins)
{
try
{
if (addin.Name.Contains("Workpapers.Next"))
{
addin.Installed = false;
addin.Installed = true;
}

}
finally
{
if (addin != null) Marshal.ReleaseComObject(addin);
}
}

}
catch (Exception e)
{
Log.Error(e.GetBestMessage(), e);
AppState.RaygunClient.Send(e, new List<string> { "RegegisterFormulaAddin" });
}
finally
{
if (addins != null) Marshal.ReleaseComObject(addins);
}
Posted 12 Oct, 2017 20:40:05 Top
Dmitry Kostochko


Add-in Express team


Posts: 2731
Joined: 2004-04-05
Hi Sean,

As far as I can see from your code, you are accessing the AddIns collection while COM add-ins reside in the COMAddIns collection. So, everything looks correct, this code will access XLLs and UDFs only.
Posted 13 Oct, 2017 04:52:37 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Thanks for your help with this, I can confirm that this code has rectified the issue for the client.
Posted 19 Oct, 2017 19:51:58 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Thank you for letting us know!

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Oct, 2017 04:05:11 Top