AnsweredAssumed Answered

Activex Excel Sort Problem

Question asked by steveb on Jun 17, 2013
  • Comment • 0
Hi, 
New to the forum. I would like to know if anyone can help me with this issue? After many hrs of frustration , trial and error and web searches, I found a post from way back by Dave Hamilton.
1. VEE SORT EXAMPLE
--------------------
ExcelApp.range("A:F").Sort(ExcelApp.range("A1"),
xlAscending,xlSortLabels,asVariantNull(""),asVariantNull(""),asVariantNu
ll(""),asVariantNull(""),xlGuess,1,"False",xlSortColumns,xlPinYin);

This works awesome, with the exception that when I try to read values back into VEE, I get the results from the original unsorted data!!

I'm currently Using VEE 7.52 and Office 2007. Unfortunately the XL Lib doesn't work with my combo of OS etc.

Can anyone give me a pointer as how to "activate" the Sort data?

Thanks  
No one else has this question

Outcomes