Trouble creating a new folder on my desktop

[Grilleman]

Hi -

Trying to check if a folder already exists in a desktop folder called 'Parent Folder'. The path is ..."C:\Users\Tom\Desktop\Parent Folder\plus the variable nFolderName. If this folder exists, I want to return a message telling the user it already exists. If the folder does NOT exist, I want to create it using the variable... nFolderName.

What's happening when I run this code is I get a new folder named nFolderName in the folder named Parent Folder. However, when I hover over my variable in the code, I see the variable name assigned from the input box. I'm stumped!

As a student of VBA, I really want to understand why my code is not behaving as intended. My sample workbook is attached.

Thanks for any help.

Please Login or Register  to view this content.

[6StringJazzer]

The path name you are using is fully within quotes. Even though it includes nFolderName, it takes "nFolderName" as the actual folder name, rather than the value of the variable. You need to separate the variable from the string:

Please Login or Register  to view this content.

[saravnepali]

Try this one

Please Login or Register  to view this content.

[Grilleman]

Thanks sixstringjazzer! That worked. And thanks for the explanation too. Very helpful learning.

Grilleman