Clearcontents of a range in excel using visual lisp

[RobyG]

I am trying to update a worksheet with new data. I need some help to clear the contents of a range of cells ex: (A13:O250), using visual lisp.

 

I have searched and not found much on working with excel from visual lisp.

 

I found C:TEXTXL and leaned some things from it. It seems that everything I find deals with writing to excel just once, not updating.

 

thanks in advance

 

roby

[Bill Tillman]

Check this site out...there is good information here:

 

http://web2.airmail.net/terrycad/LISP/GetExcel.lsp

[RobyG]

thanks for the quick response, I briefly looked through that code, it does have lots of good code, but I did not see anything directly dealing with my task. I may be able to study it and glean some hints in the right direction.