ExcelBanter - Creating folders using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Creating folders using VBA (https://www.excelbanter.com/excel-programming/328967-creating-folders-using-vba.html)

Fred Smith

Creating folders using VBA

I need to create folders with the name:

Thisworkbook.path & "\Clients\" & cell.value

Is there a VBA command that would create this folder?

--
Regards,
Fred
Please reply to newsgroup, not e-mail

Harald Staff

Creating folders using VBA

Hi Fred

MkDir

HTH. Best wishes Harald

"Fred Smith" skrev i melding
...
I need to create folders with the name:

Thisworkbook.path & "\Clients\" & cell.value

Is there a VBA command that would create this folder?

--
Regards,
Fred
Please reply to newsgroup, not e-mail

RB Smissaert

Creating folders using VBA

MkDir Thisworkbook.Path & "\Clients\" & Cells(1).Value

RBS

"Fred Smith" wrote in message
...
I need to create folders with the name:

Thisworkbook.path & "\Clients\" & cell.value

Is there a VBA command that would create this folder?

--
Regards,
Fred
Please reply to newsgroup, not e-mail

All times are GMT +1. The time now is 05:04 PM.