wrong "default file location" after installing Office-addin

[H Bernd]

Hi all

I need some help for the following problem
In Excel the "default file location" is set to an unc path
Saving and Opening of files works fine until I install my own Office-addin which is automatically started when Excel is started. If I then try to open a file the folder containing the addin is offered instead of the unc path. However the "default file location" points still to the unc path

If the "default file location" in Excel contains a drive letter, all works fine
The same Office-addin can also be used in Word and Powerpoint. This also works fine (even if the "default file location" is set to an unc path)

This effect can be seen in Excel 2000, 2002 and 2003

Can anybody help me with this problem

TI

Heinrich Bern

 

[BrianB]

You might need a "bootstrap". I have had to replace the Excel Send Mai
with a custom macro because it resets the path. Something like :-

'-----------------------------------------------------
MyLoc = Application.DefaultFilePath
'-- your code here
Application.DefaultFilePath = MyLoc
'-----------------------------------------------------

 

[H Bernd]

Thank you for the hint you gave me
I used already some code to change the default file path. However the VB "ChDir" function doesn't support unc paths
After replacing that function by the kernel32-routine "SetCurrentDirectory" all works fine

Heinrich Bernd