File path: Not a long one, but in the same folder...

[zapppsr]

I have a spreadsheet linked to a databse which is a txt file and it is at the following adress:

W:\LIDERAN\Demandas_Direcao\PCP\Alocacao\TXT\aloca.txt

I'm looking for a way to refer to de file "aloca.txt" without having to be in that address, but at the same path the spreadsheet is.

For instance, if the spreadsheet is at:

:: C:\Budget

and it is moved to...

:: H:\2012\Balance

with the txt file at the same folder, when I update data, it would look at the new folder root, instead of looking at the whole path it was before.

In short, I need to refer to the txt file and ignore the path, and make Excel look at the same folder the spreadsheet is.

Like using some wild card in the link:

Instead of:

W:\LIDERAN\Demandas_Direcao\PCP\Alocacao\TXT\aloca.txt

something like %aloca.txt

Can you guys help me?

 

[taurean]

Try like this:

Dim strTFPath As String
strTFPath = ThisWorkbook.Path & Application.PathSeparator & "aloca.txt"

 

[wigi]

Try:

ThisWorkbook.Path & "\aloca.txt"

or

ActiveWorkbook.Path & "\aloca.txt"

 

[zapppsr]

Where do I put this code?

I don't code in Excel.

I was expecting something simple, like editing this dialog box:

 

[taurean]

I think, this dialog is in Portuguese language and I don't know if I have used its English equivalent. I will PM one forum expert who will be in a position to understand it better.

 

[Marcelo Branco]

Looking at the image in #4 it seems this is not an Excel issue (as far as i know)

It's related with Windows. How to set a path to a network drive using environment variables (path) or something like that?

M.

 

[taurean]

I do not know a way to achieve this, I am sorry. Probably a Windows system / network admin would be the right person to handle such task. I'd recommend you post this on Windows related forum.