|Subject:||Re: Cut and Paste - Table into Excel -
|Date:||Sun, 29 Jul 2018 08:43:38 -0400
|From:||"Steven Green" <firstname.lastname@example.org>
copytoclipboard will get it out of the table.. will copyfromclipboard paste
Myrtle Beach, South Carolina, USA
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Robert MacMillan" wrote in message
The reason for asking this question is that I am moving data from a
Paradox Table into a very complicated Excel Spreadsheet. And Vladimirs
Excel Library with some extensions does it well but with some
I need to improve the performance and the Excel Sheet has a couple of
1. It recalculates every time something is added. So recalc is now off
and I have added to Vladimirs Library with a recalulate function and
then trigger that at the end of the load. So that works really well.
2. There is also a huge amount of formatting in this sheet as in colours
in cells and so on. And every time I transfer an item the spreadsheet
redoes all the formatting which is a PITA.
Interactively I can open the underlying table. Select the first field,
then the number of fields I want, not the total table,
<ctrl><Shift><Down arrow> which gets the data I want, <ctrl c> for copy,
move to the spreadsheet, <ctrl v> and all the information gets pasted in
How can I do that in code?