ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste problems!!!!!! (https://www.excelbanter.com/excel-programming/314997-paste-problems.html)

ramyap[_2_]

Paste problems!!!!!!
 

HI Jim.....

Thanks a real lot!!!!!!! That solved the issue!!!! :) :)
I was not using Pastespecial, though I was using Paste with th
same range as what I had copied.
As u suggested I made the destination range as a single cell & i
works fine!!

I need to use Excel on the server side as my application collect
project metrics & generates reports & charts using the collection
data. I dont call the excel application from my web application as it
not suppported (as u rightly ponted out).
What I do instead is I get the parameters of each job & put it in a
SQL table. This table has an Insert trigger, which in turn calls a
windows application on the server side itself which then performs th
charting & then updates the database.
I use xp_cmdshell to call the windows application.

Thanks a lot
~Ramy

--
ramya
-----------------------------------------------------------------------
ramyap's Profile: http://www.excelforum.com/member.php...fo&userid=1576
View this thread: http://www.excelforum.com/showthread.php?threadid=27273


Jim Rech

Paste problems!!!!!!
 
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
|




All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com