|
Guest
Posts: n/a
|
Thanks Bharat
"Bharat Biyani" wrote:
> Hi Ramon,
>
> The below link will help u use the Excel object model in a still better way.
> It discusses how to access password protected workbooks etc.
>
> http://msdn.microsoft.com/library/de...l/ExcelObj.asp
>
> ---
> Bharat Biyani ((E-Mail Removed))
> http://www.orcim.com
>
> "Ramon" wrote:
>
> > Hello All:
> >
> > I'm working on an .Net Windows application to access an Excel file using
> > Microsoft.Office.Interop.Excel.
> >
> > Basically what I'm doing is querying an excel file for the following info:
> > - Number of worksheets
> > - Number of external data sources, type of source
> > - Number of macros
> > - Number of addins used, name of addin
> > - Security settings
> >
> > One of the problems I'm having is when querying a password protected
> > document I need to enter the password.
> >
> > Is there anyway to overcome the password protection and get the desired
> > information from the document without having to manually enter the password?
> >
> > Also I'm missing the part of getting the Number of external data sources and
> > type of source; I need help with this also.
> >
> > Thanks in advance,
> > Ramon
> >
|
|
|
|
|
|