TrackChanges differences between Excel 2003 and Excel 2003 SP2??

M

Michael Howes

I generate some Excel files from C# code.

I turn track changes on (why do I have to share an Excel file to turn
on track changes??!). Everything works fine on my machine (Excel 2003
SP2) but Track Changes is not on (the file is shared) on another machine
which has Excel 2003 with no service packs.

any ideas of changes in the API between the initial release of 2003
and SP2?

my code
excelApp.Workbooks[1].SaveAs(FullPath,
Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing);

if (OctetUtils.m_bPart11Compliant)
{
excelApp.Workbooks[1].KeepChangeHistory = true;

object oWho = "Everyone";
excelApp.Workbooks[1].HighlightChangesOptions(Excel.XlHighlightChangesTime.xlAllChanges,
oWho, Type.Missing);
excelApp.Workbooks[1].ListChangesOnNewSheet = true;
excelApp.Workbooks[1].HighlightChangesOnScreen = true;
File.SetAttributes(FullPath, FileAttributes.ReadOnly);

}

thanks
mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning on TrackChanges in Excel 2003 from c#? 0
HighlightChangesOptions and HighlightChangesOnScreen not saving? 0
Excel workbook.saveas freezes program 2
Excel workboox.saveas freezes program 1
Visual Basic - HRESULT: 0x800A03EC Error Trying to Save Excel Work 0
Error on opening Excel 2007(.xlsx) on office 2003 machine. 0
Access 2003 and excel 0
Difference between Excel 2002 and 2003? 3

Top