ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with Updating Add-in path programically (https://www.excelbanter.com/excel-programming/343845-problem-updating-add-path-programically.html)

loshy

Problem with Updating Add-in path programically
 

Hello,
I am using Excel 2000
I have problem with adding and already installed addin agai
programically.

When i add again the old addin path is not getting updated.

i am using the following code to add add-in

dim xlApp As Object
Dim addobj As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.workbooks.Add
Set ai = xlApp.AddIns.Add(newpath & "MyaddinName.xla", True)
ai.installed = True
xlApp.workbooks.Close


plz hel

--
losh
-----------------------------------------------------------------------
loshy's Profile: http://www.excelforum.com/member.php...fo&userid=2835
View this thread: http://www.excelforum.com/showthread.php?threadid=47935



All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com