[Please use the mailing list.]

Hi,

On Thu, 11 Jan 2007 14:14:22 -0800 (PST), Jacobite jacobite1607@yahoo.com wrote:

I noticed your posted on Corman Lisp forum and I had a question that you might be able to answer. I have been trying to learn .net programming in Corman Lisp, playing with your example of reading from an Microsoft Excel file. I happened to notice that Excel stayed open in the background. My questions are:

1- How do you close Excel cleanly? 2- Also how do I write to the excel file and save it? 3- How do you switch which Sheet tabs you are on? 4- Can you point me in the direction of example program, such as the Excel example on your webpage, that shows reading/writing to Microsoft Access.

By the way your examples have worked beautifully. Any help you could provide would be greatly appreciated.

I'm afraid I can't be very helpful here as all your question are more related to Office automation than to RDNZL itself. I just adapted an existing C# example (see link from RDNZL website) and that's what you should probably do as well if you're looking for more. There's most likely /lots/ of C# code out there which does what you want.

If you've found something and if you have problems adapting the C# code to Lisp, ask on the mailing list and I'll try to help.

Cheers, Edi.