hi guys..thanks for the replies...

MyPath = App.Path

I think this is your problem

Try

MyPath = oXL.DefaultFilePath

For the My Documents folder


This won't work as i have a setup which installs the .exe file and th
subfolder "MySubfolder" to the users Harddrive. So this could be an
location on the users HD.

This also means that:

Could it be where you are installing and running the exe from. You d
an
App.Path in the code, so this will point at that directory whic
could be
different on different machines, and then the sub-folder may no
exit.

shouldn't give me any problems.

I haven't managed to solve the problem so if anyone could give som
more help it would be very appreciated!

Cheers,
Ari

--
Message posted from http://www.ExcelForum.com