Posted by: Michael S 2009-02-26 18:51:13 Last edited by: Michael S 2009-02-26 19:12:27 (Total edited 2 times)
I am designing a simple program that will allow a user to copy data from an Excel spreadsheet, paste it into a Reginald view control and then press an Insert button so as to insert the data into a DB2 table. (I'm quite aware one could write a VBA program to do this, but that would entail all sorts of problems I'd rather avoid and which are beyond my capabilities)
At the moment, I'm designing the window such that there is a Paste button. When they press this, the copied data is pasted into the view control (which is obviously adjusted dynamically).
Is there a way of capturing a paste event on the view control so I can skip the paste button all together ?
I could also write some VBA code (after a lot of trial and error) to interface to the required datasource. The reason I'm avoiding this option is that it would mean (?) creating an Excel workbook with VBA code that people would then copy to their own drives with the resulting problems of updating the code if I discover bugs or want to add improvements.
Using a Reginald exe IN ONE PLACE makes it easier to maintain. All the user has to do is to copy their Excel rows/columns (which could be ANYWHERE) and paste them into the view control. Thereof the question.
搜索
论坛
Home
回顶部
1. Pasting into a view control
g.yi.org Hits:0
