J
JVW
I have an Excel COM add-in that is using ClickOnce for updates. My program
also depends on a VBA add-in which must be installed at the same time but I
hate to require our customers to run two installs.
I could install the VBA add-in from my COM add-in if I could only find the
directory that contains the installation files. But I can't find a way to
reference that directory. I think my program knows in some way where the
directory is because it checks there for program updates. My idea is that I
could put the VBA add-in the same directory whenever there's a new version
and my COM add-in could check for it and update it automatically (the code
for installing VBA add-ins is simple).
So is there any way to reference that directory from my COM add-in?
also depends on a VBA add-in which must be installed at the same time but I
hate to require our customers to run two installs.
I could install the VBA add-in from my COM add-in if I could only find the
directory that contains the installation files. But I can't find a way to
reference that directory. I think my program knows in some way where the
directory is because it checks there for program updates. My idea is that I
could put the VBA add-in the same directory whenever there's a new version
and my COM add-in could check for it and update it automatically (the code
for installing VBA add-ins is simple).
So is there any way to reference that directory from my COM add-in?