Where can I download skincrafter.dll? If you're getting missing skincrafter.dll file errors or other errors with the skincrafter.dll file we suggest that you re-install the program, uninstall and re-install a more up-to-date version, or check to see if any updates are available for the program associated with the file instead of attempting to.

MJWhiteman2 17-Feb-05 0:44 17-Feb-05 0:44 I'm trying to use some Excel COM from Visual C++, but am having difficulty calling certain functions. For example, take the WorkSheets.Add method. The function declaration is as follows: LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type); By looking in the Excel VBA Help, I can get documentation for this method: Add Method (Worksheets Collection) Creates a new worksheet. The new worksheet becomes the active sheet.

Returns a Worksheet object. Syntax expression.Add(Before, After, Count, Type) expression Required. An expression that returns a Worksheets object. Before Optional Variant. An object that specifies the sheet before which the new sheet is added. After Optional Variant. An object that specifies the sheet after which the new sheet is added.

Count Optional Variant. The number of sheets to be added. The default value is one. Type Optional Variant. The sheet type.

Can be one of the following XlSheetType constants: xlWorksheet, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. The default value is xlWorksheet. Remarks If Before and After are both omitted, the new sheet is inserted before the active sheet. OK, now for some example code. I can add a new worksheet quite easily using the following code: // After obtaining a Worksheets object, called ws: COleVariant VOptional(( long)DISP_E_PARAMNOTFOUND, VT_ERROR); ws.Add(VOptional, VOptional, VOptional, VOptional The problem is that this default usage inserts the sheet before all current sheets in my workbook, but I want to insert it after all the other sheets. In Excel VBA, I can do this by simply running: Worksheets.Add.Move after:=Worksheets(Worksheets.Count) However, I'm having real trouble finding what the data type of the 'After' argument needs to be in C++ and I can't find any sample code anywhere!

I have found hundreds of examples passing numbers or strings, but not objects! Can anyone supply some sample code?

Using the _Worksheet.Move method would also accomplish the same thing, but I have the same problem, so any help would be greatly appreciated! Just in case anyone needs to do this, I figured out how to do it.

The 'after' parameter needs to represent the IDispatch pointer of the worksheet you want to add the new sheet after. So you have to do something like this: // Create a COleVariant to reference an object. The m_lpDispatch member gives a // pointer to the IDispatch interface of an object.