User:PhilHibbs

Hi, I'm Phil. I use Excel at work, and want to learn how to do all the things in OOo that I do in Excel. Mostly this involves writing Basic macros to do clever stuff such as read in other spreadsheets and write stuff out to text files from them, or read in text files and write stuff out to this or other spreadsheets.

If anyone can help me with these specific questions, I'd appreciate it:

1. How do I write a macro to open another calc document and get an object that I can use to read data from it?
2. How do I write a macro to create a new calc document and get an object that I can use to write data to it?
3. How do I write a macro to save and close one of these other documents?