Try:

Declare Function MakeSureDirectoryPathExists Lib "imagehlp.dll" (ByVal
lpPath As String) As Long

MakeSureDirectoryPathExists "c:\abc\def\ghi\jkl\"

NOTE: Path must end with \

"Bob" wrote:

What coding can I use or what ways can I use so that each workbooks path is
unique, meaning that not one workbook path is the same e.g.
C:\220210\220210.xls, C:\220211\220211.xls...

Thanks
Bob