Working in MS Access VBA, I can make this work with an unqualified function lib
name as in:
2319 theSS.AddIns("Function").Installed = True
I'm guessing this looks in the path specified by some Office default or another.
But I've got users who have that particular library ("Function"....helluva name
for a library, I know.... but somebody else made it up...) in different places -
depending, I guess, on the parms supplied when Office was installed on their PC.
Seems like something along the lines of:
2319 theSS.AddIns("C:\Program Files\Microsoft
Office\Office10\Function.xla").Installed = True
should work to override any MS Office setting - but I can't make it work.
Don't have the error# handy, but it throws a runtime error when I try it.
Anybody know where I'm going wrong.
--
PeteCresswell
Bookmarks