Ask Your Question

Basic how to's related to programming macros

asked 2018-10-27 14:02:23 +0200

JAKE gravatar image


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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-27 23:11:35 +0200

Ratslinger gravatar image


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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-27 14:02:23 +0200

Seen: 211 times

Last updated: Oct 27 '18