Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows Message when Directory Already Exist
I have a macro that creates a directory (see below). However, I would like to
have a statement to tell me the following: 1.- Find if directory already exist. 2.- Have a window message to give me the option YES or NO to rewrite it. 3.- If I click YES I will rewrite it. 4.- If I click NO I will came back to retype the information. Thanks in advance. Maperalia. '$$$$ START CREATE NEW DIRECTORY $$$$$$$$$$$$$$$$$$$$$$$$$$ NewDir = Format(Sheets("Test").Range("D5").Value) MkDir "C:\Mario\Radius and Flat Bend\ColorLINE\Radial\ColorLine Template\" & _ Format(Sheets("Test").Range("D5").Value) '$$$$ END CREATE NEW DIRECTORY $$$$$$$$$$$$$$$$$$$$$$$$$$ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if a predefined number of workbooks exist in a specific directory | Excel Programming | |||
Check if a pre0defined number of workbooks exist in a specific directory | Excel Programming | |||
Data may exist in the sheet(s) message | Excel Programming | |||
Save to directory and create if not exist | Excel Programming | |||
How to check if a folder/directory exist using VBA | Excel Programming |