Thread: create a folder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default create a folder

On error resume next
mkdir "C:\pswanie"
On Error goto 0

--
Regards,
Tom Ogilvy


"pswanie" wrote:

i got a code to "save as" and overright a workbook. what i need is for it
to check if C:\pswanie\inventry does exist. if it does then the
code runs. if not i need to create that folder and insert inventry.xls