I have created and opened a new Excel spreadsheet using COM in Visual Studio 2010 C++. How can I rename a sheet in the workbook and how can I save the workbook to a specific location? I made this worth 500 because I put 2 questions in here but I'm pretty sure they are easy answers. I just don't know the correct method to use or where to look to find a list of methods available through COM for Excel.
XL->Visible = true;
Excel::_WorksheetPtr pSheet = p_workbook->ActiveSheet;