Path Address Error "?" (Imaginary Question mark)

[urubag]

Hello,

Please note I am working a macro to create folders with a specific path address If I leave the path address in Visual Basic backend as below it works, but for some reason when I assigned a cell or range("D28").value Visual basic app detects there is a "?" in the path address as "?C:\Users\TTT90\Desktop\Test Files" and unfortunately, I was not able to do it in that way, that it is something in the past I did.

So, appreciate if someone knows the reason why this imaginary question mark appears. Note I already tried to remove it before having the final path but still appearing xD, getting me crazy.

Dim PathAddress As String 'Change the Path Address to your Unit

PathAddress = "C:\Users\TTT90\Desktop\Test Files"

Regards
Andres

 

[Joe4]

Where is the value in D28 coming from?
Is someone manually typing it into that cell, or is it the result of some data import, link, or copy/paste?

Enter this formula in any blank cell, and let us know what it returns:

=CODE(LEFT(D28,1))

 

[urubag]

Where is the value in D28 coming from?
Is someone manually typing it into that cell, or is it the result of some data import, link, or copy/paste?

Enter this formula in any blank cell, and let us know what it returns:

=CODE(LEFT(D28,1))

Actually, it is a cell where the user input the data.

 

[Joe4]

You didn't answer my question.
If you enter the formula I gave you in any open cell on your "Instructions" sheet, what does it return?

Also, in your original post, you said cell D28, but your code references cell F11.
Can you reconcile that discrepancy? Are you sure you are looking at the right cell?