[AccessD] Using the SUBST command

Hi List

Has anyone used the SUBST command from VBA?

I am currently developing a system in Access 2010 which requires data to 
be exported to a Word template.  Easily done.
The problem comes in with the length of the paths involved with the 
storage folder for the templates and the created documents.

I would like to use the SUBST command to map the path to a drive, action 
the import or export, and then disconnect the drive.
But I cannot get the command to run.

Code snippet:
....
....
....
Save:
             Shell ("c:\cmd.exe /c SUBST X: " & gstrDraftIMPPath)

             myFileName = "ServiceNo " & mRsClients!ServiceID & "- 
Client " & mRsClients!ClientName _
                                 & " Personal Officer " & 
mRsClients!PersonalOfficerName

             .SaveAs "X:\" & myFileName, wdFormatDocument
         End With 'my word doc


If I map the drive manually, it all works perfectly.  But I can't get it 
to map automatically.  Has anyone done this before, or guide me to the 
correct Shell syntax if it's wrong

Thanks in Advance
-- 
*/Bryan
/*



-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3349 / Virus Database: 3204/6513 - Release Date: 07/23/13