>Ok I have another question about excel automation. I am trying to figure out what would be the best way to set up my data and also format my data. I have a project where it deals with pricing. This project requires that I copy data to an already formatted xls spreadsheet. I have standardized my xls spreadsheets so that all I have to do is copy the data to a specific row. Also I have written my programs to do this. OK now here is the question I have: How do I set up borders around that data? Keep in mind that this data could change and that the size of the data could be decrease and/or increase. Is there a way to setup dynamic borders depending on the size of data i am copying over to xls? Thanks in advance.
>
>Kimberly
Kimberly,
When you copy over the row (or paste I should say) you know the dimensions of your data and could select data range. With range.borders collection you could set them as you want.
Cetin