Always prompted to save even when not modified

M

Macca

hi,

I am using Automation with VC++ 6 to create an excel workbook. I then do
some writing to it and save it before closing the workbook.

When i open the excel spreadsheet from windows explorer i can see the
contents fine. The problem i am having is that when i close it, the save as
dialog appears to prompt me if i would like to save any changes i have made,
even though i haven't made any changes.

I would like to be prompted only if changes are made.

I have included some code snippets below. I'd appreciate any help on how to
solve this problem. I have used a lot of code from Knowledge Base Article
179706.

Thanks In Advance.
Macca


// Create a Spreadsheet
COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);


_Application app;
Workbooks books;
_Workbook book;

Worksheets sheets;
_Worksheet sheet;
Range range;
Font font;
Range cols;

// Start Excel and get Application object.

if(!app.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
return;
}


//Get a new workbook.
books = app.GetWorkbooks();
book = books.Add (covOptional);
 

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

Top