Get rid of driveletter in filepath *Help needed*

Hi all

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

/Jan

Please Login or Register  to view this content.

Hi SHG

i Have tried your code and have changed what i thought should be changed to fit my code... but unfortunately it doesnt work :\.

I have changed your "bob.xls" to "spid.xls" and this part must be right i guess.
i have changed my filepaths in the code from (example) "e:\spid\data\pictures\" & ComboBox1.Value & ".jpg" to just: "\data\pictures\" & ComboBox1.Value & ".jpg"

Before your code was inserted i had already other "dim as string" and i dont know if these should be deleted or stay?
If i start the program with your code (with my changes) and my code from before i either get "spid is already running, will you run spid again"?
if i say yes spid starts again and i think that IF i had saved the code with the new changes the program would maybe have looped. I didnt save it and when spid is run again im back to the "old" excisting code without your code.

If i say no i get an error.

I have uploaded a text file with my code.. can you ? or anyone else who takes time to look into this,, see what is wrong?

Thank you

/Jan

The code was just to show how to open a file using a path relative to the workbook. I know you were trying to do something with a picture, but had no idea what.

You code, at a glance, should be something like

Please Login or Register  to view this content.

Why post a Word doc instead of a workbook?

You're overcomplicating this.

Assuming your code works when you have a local mapped drive, and the files you open are all in the same directory as the workbook, then go back to your original code, and replace as much of this

"K:\spid\spid\Data\Tekst\"

as you need with ThisWorkbook.Path & "\"

So if the workbook is in "K:\spid\spid\Data", then the string above should be

ThisWorkbook.Path & "\Tekst"

If the workbook is in "K:\spid\spid\", then the string above should be

ThisWorkbook.Path & "\spid\Tekst"

If the workbook is in "K:\spid\", then the string above should be

ThisWorkbook.Path & "\spid\spid\Tekst"