OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

create folder and file using macro

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
hazabaral
Power User
Power User


Joined: 16 Apr 2008
Posts: 69

PostPosted: Wed Apr 16, 2008 12:50 am    Post subject: create folder and file using macro Reply with quote

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.
Back to top
View user's profile Send private message
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Wed Apr 16, 2008 6:20 am    Post subject: Reply with quote

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>
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group