Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: vinod kabdal
  Where is vinod kabdal?
 Delhi
 India
 vinod kabdal
 To: vaishali maske
  Where is vaishali maske?
 mumbai
 India
 vaishali maske
 Tags
Subject: RE: microsoft excel 2007
Thread ID: 210468 Message ID: 210485 # Views: 29 # Ratings: 0
Version: Visual FoxPro 8 Category: Errors & Debugging
Date: Tuesday, January 06, 2009 10:01:27 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

LOCAL oa as object, oa
xlsFile=GETFILE('xls')
oa=CREATEOBJECT('excel.application')
oa.Visible=.t.
oa.Workbooks.Open(m.xlsfile)


Thanks

Vinod Kabdal



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