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
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