Groups > WordPerfect Office > Quattro Pro 11 > Re: Macro problem




Macro problem

Macro problem
Tue, 31 Oct 2006 15:54:36 -080
The following macro worked well in QuatroPro 7 version.

      {Sort.Reset}

      {Sort.Block QUATER3:J48..L66}

      {Sort.Key_1 QUATER3:L47}

      {Sort.Key_2 QUATER3:K47}

      {Sort.Order_1 Descending}

      {Sort.Order_2 Descending}

      {Sort.Go}



In QuatroPro 11 it works if the macro is run from the same page that the 
macro code is located on.  But it gives me an "invalid key {sort.go}"

message if macro is run from the page where the data, sorted by the macro, 
is located.  Any ideas?  Please help.

Thank you.

Jeff


Post Reply
Re: Macro problem
Wed, 1 Nov 2006 09:28:35 -0800
Roy:
Tried 48 still no go.
I would appreciate any other thoughts.
Jeff
"lemoto" <ctech@corel.ca> wrote in message 
news:VA.0000414e.002e182b@corel.ca...
>
> Jeff:
>> The following macro worked well in QuatroPro 7 version.
>>
> Why are the Keys ?47 when the Block is 48..66 ?
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
> 


Post Reply
Re: Macro problem
Wed, 01 Nov 2006 11:04:00 GMT
Jeff:
> The following macro worked well in QuatroPro 7 version.
>
Why are the Keys ?47 when the Block is 48..66 ?
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Post Reply
Re: Macro problem
Wed, 01 Nov 2006 16:42:05 GMT
Jeff:
> In QuatroPro 11 it works if the macro is run from the same page that the 
> macro code is located on.  But it gives me an "invalid key
{sort.go}" 
> message if macro is run from the page where the data, sorted by the macro,

> is located.

Well. This is no direct help to you - I put the macro on another page and 
called it from the data page,and it ran as it should. Just for reference, 
this is what I used:

{Sort.Reset}
{Sort.Block QUATER3:J47..L66}
{Sort.Key_1 QUATER3:L47}
{Sort.Key_2 QUATER3:K47}
{Sort.Order_1 Descending}
{Sort.Order_2 Descending}
{Sort.Go}
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Post Reply
about | contact