create folder and file using macro

[hazabaral]

I am trying to create folder using macro

I am using a command button which has the code
MkDir ("C:\SubDir1")
one problem i have that it does not allow me unlimited number of MkDir command in one macro.
And but I dont know how to create/name the folder which refence to a cell string of a spreadsheet. like i have a calc spreadsheet sheet1, in sheet1 cloumn A looks like
SubDir1
SubDir2
SubDir3
SubDir4
.....
..
..
SubDir100

Now how can I pick this cell string and create a directory by using MkDir command in macro or any other way. And I want to create a file (like A100.ods) using the same method.

Pease help me if someone have some solution.

[AndrewZ]

Don't post the same thing twice. I deleted your duplicate post in code snippets because it is not for questions: only for working snippets. Then, I moved your post from Calc to Macros and API.
_________________
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* OpenOffice.org Ninja
* BleachBit
</signature>