View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default How to determine the parent directory

Check out this link...

http://support.microsoft.com/default...b;en-us;213800

So use something like

Shell ("Command.com /c md C:\Test")

HTH

"KS Wong" wrote:

Dear all,

I have a string variable, i.e. strDB="c:\data\aproject\database\dbfile.mdb".
I want to add a subdirectory under "c:\data\aproject\reports"
programmatically. How can I do that?

Thanks in advance!