Basic how to's related to programming macros


I couldn’t find any actionable macro example nor tutorial.

What I need to create is to be able to read filename from column as parameters.
-How do I pass parameters i.e. column references to function/macro?

Next step is to load that file.
-How to use parameter value (string) as a filepath and to load a file?

Third step is to search a line from the file starting with predefined string and return it.
-How to turn regexp on file content?

Fourth step would be splitting this line by character =
-How to split s string?

Fifth and final step is to return splitted string’s 2nd value.
-How to return a value?


You should look through ‘Open Office Macros Explained’ by Andrew Pitonyak. The PDF is found here → OOME. You will find a vast amount of information and examples there.

Your question actually contains many different questions some of which may require further information. This forum is designed to ask one question at a time. If after going through the OOME document you still have questions, please ask a specific question with sample/example information always being a plus.