Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mkdir problem
Hi Keivn,
Try dropping the outer parentheses. MkDir "C:\test\" & RIGHT(ActiveCell.Text, 4) worked for me. --- Regards, Norman "Keivn Green" wrote in message ... When I try to use this command in a macro to create a directory that is the last for digits of the activecell it says " Wrong number of arguments or invalid property assignment." Here is the line in the code.. MkDir ("C:\test\" & RIGHT(ActiveCell.Text, 4)) If the active cell says 12345678 teh it should make a directory called c:\test\5678 Any ideas why this doesnt work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
mkdir command in excel 2003 on XP SP2 | New Users to Excel | |||
Shell "mkdir" | Excel Programming | |||
MkDir error | Excel Programming | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |