Updating the filepath on formulas automatically

[Buoyana]

I'm new to macros and I think the solution to my problem requires one... Please be thorough! I use VLOOKUP to pull from a data base that is shared on Dropbox, so every time the document is being opened from another computer, the formulas are no longer compatible. The name of the file I'm using is "EVALUATION_FEB_2022" and the file I'm pulling data from is "DATABASE_2022". In case it's useful, the formula I use is =VLOOKUP($C2,'[DATABASE_2022.xlsx]February'!$C$8:$W$81, 8, false). This formula spreads out across many columns and rows with different targets, so automation would be really useful. The current filepath is C:\Users\OOSB\Dropbox\OOSB\February\[DATABASE_2022.xlsx]February.

 

[GlennUK]

You have not said what the filepath of that database is on another computer? And also, why is not the same filepath - or am I not understanding the filepaths from computer to computer with Dropbox?

 

[Buoyana]

It's not the same Filepath because it isn't the same Dropbox account, it is only a shared folder. The filepath would remain the same with the exception of a different username (e.g. C:\Users\Marie\Dropbox\MarieAntoinette\February\[DATABASE_2022.xlsx]February. Even if we shared the same account, the computer's username is also different.

 

[GlennUK]

It's not the same Filepath because it isn't the same Dropbox account, it is only a shared folder. The filepath would remain the same with the exception of a different username (e.g. C:\Users\Marie\Dropbox\MarieAntoinette\February\[DATABASE_2022.xlsx]February. Even if we shared the same account, the computer's username is also different.

That doesn't answer my question. In fact it brings my question into focus - how does the macro know what the new filepath is to be? Is it based on username - as your example seems to be?