Difference between revisions of "User:PhilHibbs"
From Apache OpenOffice Wiki
(Intro) |
|||
| Line 3: | Line 3: | ||
If anyone can help me with these specific questions, I'd appreciate it: | If anyone can help me with these specific questions, I'd appreciate it: | ||
| − | + | # How do I write a macro to open another calc document and get an object that I can use to read data from it? | |
| − | + | # 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? | |
| − | + | # How do I write a macro to save and close one of these other documents? | |
Latest revision as of 14:43, 24 June 2008
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:
- How do I write a macro to open another calc document and get an object that I can use to read data from it?
- 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?
- How do I write a macro to save and close one of these other documents?
