Paradox Community

Items in pnews.paradox-programming

Subject:Re: Cut and Paste - Table into Excel -
Date:Mon, 30 Jul 2018 10:00:39 +1000
From:Robert MacMillan <macfam@bigpond.net.au>
Newsgroups:pnews.paradox-programming
I think I have found most of what I need. It looks like perhaps "Select" 
will get the information. Then possibly OLE function in Excel might 
paste it.

On 29/07/2018 10:43 PM, Steven Green wrote:
> copytoclipboard will get it out of the table.. will copyfromclipboard
> paste it, too?
>
>
> --
>
> Steven Green
> Myrtle Beach, South Carolina, USA
>
> http://www.OasisTradingPost.com
>
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Robert MacMillan"  wrote in message
> news:5b5d7510$1@pnews.thedbcommunity.com...
>
> 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
> performance issues.
>
> I need to improve the performance and the Excel Sheet has a couple of
> problems.
>
> 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
> one go.
>
> How can I do that in code?
>
> Thanks
>
> Robert


Copyright © 2004 thedbcommunity.com