Save as with excel automation

[Sami4]

Hello all.

I need your help because i want to save an excel sheet (i have 2 sheet) to an txt file (File Type : Text (DOS) ).
To do that, i use the following article from microsoft "How to automate Excel from C++ without using MFC or #import" (http://support.microsoft.com/kb/216686/en).
Here a piece of my code:

if( file == NULL) {
MessageBox(NULL, "Nom du fichier manquant", "Error", 0x10010);
return false;
}

WCHAR str[MAX_PATH];
MultiByteToWideChar(CP_ACP, 0,file, -1, str, MAX_PATH);

VARIANT vaPath;
vaPath.vt = VT_BSTR;
vaPath.bstrVal = SysAllocString(str);

AutoWrap(DISPATCH_METHOD, NULL, xlBook.pdispVal, L"SaveAs", 1, vaPath);

SysFreeString(vaPath.bstrVal);
VariantClear(&vaPath);

SetSave(true);
}

I found any informations doc in this forum anf if you could help me.
Thanks by advance for your help.

[VictorN]

Hello all.

I need your help because i want to save an excel sheet (i have 2 sheet) to an txt file (File Type : Text (DOS) ).
To do that, i use the following article from microsoft "How to automate Excel from C++ without using MFC or #import" (http://support.microsoft.com/kb/216686/en).
Here a piece of my code: ...

So, what is the problem?

[Sami4]

Thanks VictorN.


To understand, when you save a sheet manually, you have a dialog box and you choose the name and the type of the file :

File Name :example.fdf
File Type : Text (DOS)

In my case, i don't want to save it like 'classeur Microsoft Excel but to an Text (DOS) when using autowrap example.
Thanks.

[Tom Frohman]

The way I have AutoWrap set up in my program I have to use the arguments in reverse order.

See
http://www.codeguru.com/forum/showth...ighlight=excel

VARIANT result;
VariantInit(&result);
VARIANT fname;
fname.vt = VT_BSTR;
fname.bstrVal=::SysAllocString(L"C:\\output.txt");
VARIANT fformat;
fformat.vt = VT_I4;
fformat.lVal=20;
AutoWrap(DISPATCH_METHOD, &result, pXlSheet, L"SaveAs", 2,fformat, fname);