I am converting VBA macro of excel into libre office calc.
how can I make this stuff
I’m sure this was asked before. Could you add how your question is different from similar questions?
From what I have learnt … VBA cannot be adopted into CALC.
About 12 Months ago I looked at Calc with a hope of using my Excel Addins.
All my Excel 2003 addins, templates and some xls-books create temp menu-bar sub-menus when the XLA/XLT/XLS files are opened.
One addin has 63 controls on its dedicated menu. The thought of rewriting 15 years of addins and templates and the apparent bugs in Calc, turned me off.
At the time the Calc forum was full of bug reports and finding Libre coding help was impossible.
My solution was to shell out for Office 2010 (the last ms-office that supports VBA) … BUT how I hate the Excel ribbon.
Although in Excel2007/2010 toolbar/ribbons are now dedicated to the file (similar to what MS-Word has been for years.)
To answer your question … It cannot be done … Calc does not use VBA, Libre uses a sort of visual-language.
Finding help on Objects, Method, Functions, ENums etc about a year ago was impossible.
When Calc is a serious contender for Excel VBA I will have a look at Calc again.
EDIT (1 hr later)
Maybe I am wrong. See …
Also refer the answers here and here. VBA support will likely improve over time, but at present (LO v4.2-4.3) it is not great.
I have fairly good knowledge about VBA and did lots of works personally and professionally. I also tried macro writing in LO Calc, but man, the tutorial, materials are hard to come by.
Thus I am preparing a series of tutorials on Macro writing in LibreOffice using basic to help the entire community once and for all.
Its still work-in-progress, you can have a look here:
http://www.debugpoint.com/category/programming/libreoffice/