Excel VBA writing a VB script file (Problem with MkDir Command

[MPW]

Hello.

I am using using VBA to create a VB script file that will create folders and copy files.

Everything was running great until I tried to use the MkDir command.
Here is the VBA Command followed by how it appears in the VB script.

macfile.Write ("     MkDir(""" & dest & "\" & stk & "_" & bkd & "_" & bkn & "_" & chp & """)" & vbCrLf)     'VBA Code

                     MkDir("G:\Projects\N1_Spanish\N1_HDH_SHJ_6_Sessions\N2_ESS_WYI_001_MAT_001")     'VB script command

The folder "G:\Projects\N1_Spanish\N1_HDH_SHJ_6_Sessions" already exists.

I know that this board is for Excel issues and not VB Script, but since I am using Excel to create this I thought I would give it a try. If I have violated the scope of the forum I will be happy to withdraw the question.

 

[MPW]

I finally dug this up and it answered my issue.

                    macfile.Write ("     Set oFSO = CreateObject(""Scripting.FileSystemObject"")" & vbCrLf)
                    macfile.Write ("     oFSO.CreateFolder """ & dest & "\" & stk & "_" & bkd & "_" & bkn & "_" & chp & """" & vbCrLf)