LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default TrackChanges differences between Excel 2003 and Excel 2003 SP2??


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.XlHighlightChangesT ime.xlAllChanges,
oWho, Type.Missing);
excelApp.Workbooks[1].ListChangesOnNewSheet = true;
excelApp.Workbooks[1].HighlightChangesOnScreen = true;
File.SetAttributes(FullPath, FileAttributes.ReadOnly);

}

thanks
mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 differences to 2003 questions George Applegate[_2_] Excel Discussion (Misc queries) 0 May 4th 09 08:41 PM
Scrolling differences b/w Excel 97-2003 and new Excel07 Ditch Charts and Charting in Excel 0 April 9th 09 06:13 AM
can you summarize differences between Excel 2000, 2003 & 2007? LSL Excel Discussion (Misc queries) 2 August 7th 08 03:39 PM
Excel Macros - Any Major Differences Between 2003 and 2007 bk Excel Worksheet Functions 1 November 20th 07 03:56 PM
opening word doc from excel 2000 and 2003 differences Colin C Excel Discussion (Misc queries) 0 December 11th 05 08:06 PM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"