Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: vaishali maske
  Where is vaishali maske?
 mumbai
 India
 vaishali maske
 To: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: microsoft excel 2007
Thread ID: 210468 Message ID: 210474 # Views: 33 # Ratings: 0
Version: Visual FoxPro 8 Category: Errors & Debugging
Date: Tuesday, January 06, 2009 7:56:01 AM         
   


> > Hi,
> >
> >
> > I did following code for opening excel sheet from my foxpro programm(form button click).Its opening excel sheet but when I close it it shows me error that "OLE IDispatch exception code 0 from Microsoft Office Excel: 'icrosoft Excel.xlsx' could not be found.Check the spelling of the file name,and verify that the file location is correct"
> >
> > LOCAL lobject, lcFile,lobject1
> > lobject = CREATEOBJECT('Excel.Application')
> > lobject.Visible = .T.
> > lobject.Workbooks.Open(m.lobject)
> >
> > Can you tell me solution.
> >
> > Thanks,
> > vaishali maske
>
>
> Actually you are doing worng syntanx workbooks.open need a file name not excel object!.
> LOCAL lobject, lcFile,lobject1
> lobject = CREATEOBJECT('Excel.Application')
> lobject.Visible = .T.
> lobject.Workbooks.Open("c:\temp.xls")
>
>
> Anil
> My Blog



Hi anil,

This new code also shows same problem.pls tell me any other solution.

Thanks,
vaishali maske



COMPLETE THREAD
microsoft excel 2007 Posted by vaishali maske @ 1/6/2009 7:41:20 AM
RE: microsoft excel 2007 Posted by Anil Sharma @ 1/6/2009 7:46:11 AM
RE: microsoft excel 2007 Posted by vaishali maske @ 1/6/2009 7:56:01 AM
RE: microsoft excel 2007 Posted by Anil Sharma @ 1/6/2009 7:58:37 AM
RE: microsoft excel 2007 Posted by surinder singh @ 1/6/2009 9:59:24 AM
RE: microsoft excel 2007 Posted by vinod kabdal @ 1/6/2009 10:01:27 AM