Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: Smallville
  Where is Smallville?
 Taguig
 Philippines
 Smallville
 Tags
Subject: RE: Open Protected XLS File
Thread ID: 289180 Message ID: 289207 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Wednesday, December 29, 2010 1:47:57 PM         
   


> >
> > Try this (I didn't test it)
> >
oExcel.Workbooks.Open(cWB,,,,'wagmatakot')
> > 

> >
> > Regards
> > Samir
>
> Samir,
>
> Thank you it works!
>
> oWorkbook = oExcel.Application.Workbooks.Open(lcXLSFile,,,,"wagmatakot")
>
> Thanks!
>
> Smallville,
> Taguig City

Hi Smallville
A tip for you, that may help when using automation: I got the code above using intellisense, see Message ID: 289113 on how to activate intellisense for excel.

Regards
Samir

ENTIRE THREAD

Open Protected XLS File Posted by Smallville @ 12/29/2010 2:38:04 AM
RE: Open Protected XLS File Posted by Samir H. @ 12/29/2010 2:52:28 AM
RE: Open Protected XLS File Posted by Smallville @ 12/29/2010 8:55:12 AM
RE: Open Protected XLS File Posted by Samir H. @ 12/29/2010 1:47:57 PM