I really need the solution to this problem.
My excel program sometimes need to open a file at for example this path:
E:\spid\data\pictures\picture.jpg - and thats all fine but how can i get rid of the need to specify driveletter?
If other users of the program save the spid-program on their f: drive ,, k:drive or whatever driveletter other than e: - my path/paths in the program doesnt work anymore :/
Are there any way to program that my excel program should use the folder of which the program itself lies in, as root folder ? So the program will work no matter which drive the folder lies on ?
So the path afterwards only would be \data\pictures\picture.jpg. For example ?
I have already tried \\data\pictures\picture.jpg - that doesnt work.
My folder SPID contains the excel file (spid.xls) in its root and thats the only programfile in that folder furthermore i have different folders inside the SPID folder like "pictures" , "texts" and "url" . These folders contain only things that is being called to spid.xls whenever needed... To show picture / show text or read an url for going to a website.
Can this be done ? Like creating a universal path ?
Thanks in advance