View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jo Gjessing Jo Gjessing is offline
external usenet poster
 
Posts: 1
Default Creating a directory from within Excel VBA

Hi all,

I'm creating a little VBA script within Ms Excel, wanting the script to
change directory before writing a file, using the ChangeFileOpenDirectory
method. It works fine. But what if the directory does not exist? Then I want
the script to create it. Can you please tell me how I make it do so?

Thank you very much in advance.

Jo