Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Error on opening Excel 2007(.xlsx) on office 2003 machine.

I am working on the project where I need to open programmatically, password
protected office 2007 files (particularly excel and ppt files) on a machine
which has office 2003 installed.

Whenever I am trying to open the password protected 2007 ppt or excel,
through code it is prompting to enter the password and application become
visible to the user, which is not intended behavior.

If same code is tried on the machine which has office 2007 installed, files
open correctly without prompting to enter the password and in invisible mode,
which is the intended behavior.

We are using ref to Microsoft.Office.Interop.Excel11.0 library to open the
file and fallowing C# code

Excel.Application _excelApp = null;
Excel.Workbook _book = null;
object readOnly = true;
object updateLinks = 2;
object _dontCare = Type.Missing;
object ignoreReadOnly = true;
object notify = false;

_excelApp = new Excel.Application();
_excelApp.Visible = true;
_excelApp.DisplayAlerts = false;
_excelApp.AutomationSecurity =
Microsoft.Office.Core.MsoAutomationSecurity.msoAut omationSecurityForceDisable;

_book = ",
updateLinks,
readOnly,
_dontCare,
"test",
_dontCare,
ignoreReadOnly,
_dontCare,
_dontCare,
_dontCare,
notify,
_dontCare,
_dontCare,
_dontCare,
_dontCare);

Please let us know if you have any solution for this.

same behavior is identified for the powerpoint2007 files also.

but simmilar issue work fine with password protected office2007 word
file(.docx) on office 2003 machine.

My machine has .net PIA installed and also office 2007 file convector.

Reply
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
Opening Office 2003 excel file in Office Excel 2007 Joel Excel Discussion (Misc queries) 1 July 3rd 09 05:56 AM
Opening an Office 2007 Excel file in Office 2003 charstachura Excel Discussion (Misc queries) 1 November 8th 07 09:36 PM
Opening a XLSX File from 2007 excel to 2003 excel lvasquez3 Excel Discussion (Misc queries) 0 July 2nd 07 03:50 PM
how do i convert . xlsx file to office 2003 (excel) Gill Excel Discussion (Misc queries) 0 July 6th 06 12:56 AM
how do i convert . xlsx file to office 2003 (excel) Gill Excel Discussion (Misc queries) 0 July 6th 06 12:49 AM


All times are GMT +1. The time now is 05:24 PM.

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

About Us

"It's about Microsoft Excel"