Abhinav wrote:
I am trying to delete data on a shared workbook through
automation.

m_pXlWorksheet-UsedRange-Delete(Excel::xlToLeft);

This throws an error even when the workbook is not opened
by anyone else.


From Excel help:

<<
Limitations of shared workbooks
Some features of Microsoft Excel are not available when you use a
shared workbook. If you need to use these features, do so before you
share the workbook, or remove the workbook from shared use.

In a shared workbook, you cannot do the following:

Cells
Merge cells. You can view cells that were merged before you shared the
workbook.

Insert or delete blocks of cells. You can insert or delete entire rows
and columns.

... etc.




Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup