View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soniya[_2_] Soniya[_2_] is offline
external usenet poster
 
Posts: 15
Default Create directory

Hi,

How can i create a direcory using VBA if it do not exists?

for eg. when i click my command button i want to copy
sheet2,sheet3, sheet4 to c:\BkUp\FileName.. so that if
the direcory exixts it will save the file or create BkUp
directory and save the file ???

TIA
Soniya