Hey, glad it worked out for you, Ramya. Sometimes I get lucky<g.

--
Jim Rech
Excel MVP
"ramyap" wrote in message
...
|
| HI Jim.....
|
| Thanks a real lot!!!!!!! That solved the issue!!!! :) :)
| I was not using Pastespecial, though I was using Paste with the
| same range as what I had copied.
| As u suggested I made the destination range as a single cell & it
| works fine!!
|
| I need to use Excel on the server side as my application collects
| project metrics & generates reports & charts using the collections
| data. I dont call the excel application from my web application as its
| not suppported (as u rightly ponted out).
| What I do instead is I get the parameters of each job & put it in an
| SQL table. This table has an Insert trigger, which in turn calls an
| windows application on the server side itself which then performs the
| charting & then updates the database.
| I use xp_cmdshell to call the windows application.
|
| Thanks a lot
| ~Ramya
|
|
| --
| ramyap
| ------------------------------------------------------------------------
| ramyap's Profile:
http://www.excelforum.com/member.php...o&userid=15760
| View this thread: http://www.excelforum.com/showthread...hreadid=272739
|