Creating, open folders with Polish characters (1 Viewer)

[megatronixs]

Hi all,

I have a form with a button that is used to create or open a folder. It works OK when I use English names, but when I use Polish names with the characters, it simply does not work and opens my folder instead.

Any clue how this could be solved?

Private Sub btn_cv_candidate_Click()
    Dim oApp As Object
    Dim path As String
    Dim filename As String
    Dim strEventPhotos As String
  
    path = "C:\Current Evidence\Recruitment Tracker\CV Folder\" & Me.record_id & "_" & Me.Canditates & "\"
    
    'checking if the folder exist if not creating one
    If Dir(path, vbDirectory) = vbNullString Then
    MkDir path
    'MkDir path & "\" & "Emails\"
    End If
    strEventPhotos = "C:\Current Evidence\Recruitment Tracker\CV Folder\" & Me.record_id & "_" & Me.Canditates & "\"
    Shell "EXPLORER.EXE " & strEventPhotos, vbNormalFocus
End Sub

Greetings.

 

[Ranman256]

Some characters CANNOT be used as in a folder name.
Im not sure what Polish chars look like but they could be part of the list.
(using English keybd settings)

 

[megatronixs]

Hi Rannman256,
I can use Polish characters without problems directly when creating the folder name, but can't with vba. I actually mean like letters ł ą ń (a few examples).

Greetings.

 

[JHB]

Use the StrConv function to converted the unicode string to ANSI before you check/ create a folder.
Here is a link how to use the function.
https://www.techonthenet.com/access/functions/string/strconv.php