Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
arranging worksheets in alphabetical order
I want to arrange the worksheets in a Excel worbook in alphabetical
order. I read the worksheet names into a list and sort it. When I try to rearrange I am having problems. I get a run-time error "Move method of worksheet class failed" Any help will be appreciated. Thanks, Sunil Code snippet: long int numSheets; CWorksheets Sheets; CWorksheet wSheet; Sheets = oBook.get_Worksheets( ); numSheets = Sheets.get_Count( ); for ( int i=1;i<=numSheets;i++ ) { wSheet = Sheets.get_Item( COleVariant( (short)(i) ) ); wSheet.Activate( ); tmpName = wSheet.get_Name(); //AfxMessageBox( tmpName.c_str() ); if ( ( tmpName != "VE_Dump" ) && ( tmpName != "Summary" ) ) sheetNames.push_back( tmpName ); } sheetNames.sort( ); //trial to see it it works wSheet = Sheets.get_Item( COleVariant( (short)(1) ) ); wSheet.Move( COleVariant( (short)(3) ), covOptional ); |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put worksheets in Alphabetical order? | Excel Discussion (Misc queries) | |||
Arranging words in alphabetical order | Excel Discussion (Misc queries) | |||
How do I put worksheets in alphabetical order | New Users to Excel | |||
How do I put worksheets in alphabetical order | Excel Worksheet Functions | |||
Worksheets in alphabetical order | Excel Programming |