How to create sub folder in a folder using VBA

Question

Need suggestions here as I am creating a folder using MkDir and the folder name is an input in a cell from the user. After creating this folder I further need to create sub folder. strOrderNo stores the input value from the user.

Following is the code used and though the order no folder is created, not able to create sub folder invoices.

On Error Resume Next

MkDir "C\" & strOrderNo

MkDir "C\strOrderNo\Invoices"

On Error GoTo 0

Note that because of On Error Resume Next you don't see your error messages (it turns off all error messages). Because you don't see them, you don't know which the error message is, and that is why you cannot fix the error. — Pᴇʜ
– Pᴇʜ, Commented Feb 25, 2021 at 14:59

Pᴇʜ · Accepted Answer · 2021-02-25 14:57:38Z

0

Your are using the strOrderNo in a mkdir string, rather than the variable.

Assuming the first mkdir is behaving how you want it, the second needs to be:

MkDir "C" & strOrderNo & "\Invoices"

edited Feb 25, 2021 at 14:57

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

answered Feb 25, 2021 at 14:42

lostbard

5,3001 gold badge17 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shai Rado Over a year ago

Shouldn't it be "C:\" & strOrderNo ?

lostbard Over a year ago

only if it was meant to be that with the first mkdir as well. hence my 'assuming' disclaimer :)

Collectives™ on Stack Overflow

How to create sub folder in a folder using VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related