I have an array called sSheet(100) that stores each Excel's Sheet Name as it should be sorted and the total number is in variable iSheet. Based on the what I have my Excel workbook should have the following Sheets sorted according to that array's listing from 0 to iSheet.
How do I rearrange the following to allow for the sort to exist?
'put code here to sort sheets in the order as in access..
For j = 0 To iSheet
For Each xlSheetReview In xlBook.Worksheets
If xlSheetReview.Name = sSheet(j) Then
'not sure how to handle the move code at this point.
'this is what I found online