SaveAs

2 views
Skip to first unread message

Carrier Field Operations Tech

unread,
Sep 26, 2001, 2:50:46 AM9/26/01
to
How do you create a directory in XL vb when saving a file with a new name?
All help is appreciated.

Bruce


Patrick Molloy

unread,
Sep 26, 2001, 3:23:07 AM9/26/01
to
use the mkdir function:


Dim sPath As String
sPath = "C:\Testing1"
MkDir sPath
ThisWorkbook.SaveAs sPath & "\" & "Myfile.xls"


Patrick Molloy
Microsoft Excel MVP

>.
>

Reply all
Reply to author
Forward
0 new messages