Hi,



my issue is pretty simple:
In a macro, I have an error message "Ambiguous name detected".
I have looked up elsewhere what that message means and it's pretty clear, I'm using something that is already taken so to speak. The VBE also highlights the very word that causes the issue ...

<=> but that is a variable?! Aren't variables supposed to be populated and re-populated just as often as you need them to?

Can anybody help me there?

P.S.:
I can of course post the piece of the code where this happens, but it's not quite apparent to me how that would help. Still, if you need to see it, I can provide it.
Shortly speaking, I have a variable v_path1 (which is the term highlighted) which holds the filepath and a variable Dateiname which holds the file_name.
=> Then I have a formula
>> v_path_total = v_path1 & "\" & Dateiname <<
... and then I open the file like
>> Workbooks.Open Filename:=v_path_total, UpdateLinks:=False <<
That is basically all I'm doing.

Thanks a lot!

Best regards,

Officer_Bierschnitt