HighlanderSword Posted March 5, 2020 Posted March 5, 2020 Hello, I'm trying to convert the excel macro line below over to Autoit using the Excel UDF $oExcel.ActiveWorkbook.Worksheets("Results").ListObjects("Table1").Sort.SortFields.Add Key:=Range("Table1[count]"), SortOn:=xlSortOnValues, Order:=xlDescending , DataOption:=xlSortTextAsNumbers When I run this , I get error 7 and extended value -2147352567 _Excel_RangeSort($oWorkbook,"Results", "A3:C" & $LastRow,"B:B",$xldescending) What am I missing ?
Nine Posted March 5, 2020 Posted March 5, 2020 Might also be, because of a table included. Hard to say without code and .xls “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Debug Messages Monitor UDF Screen Scraping Round Corner GUI UDF Multi-Threading Made Easy Interface Object based on Tag
HighlanderSword Posted March 6, 2020 Author Posted March 6, 2020 ok figured it out _Excel_RangeSort($oWorkbook,"Results" , "A3:C" & $LastRow,"B:B",$xldescending,$xlyes)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now