CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. January 4th, 2000, 03:44 PM #1
    coolily
    coolily is offline Member
    Join Date
    Jan 2000
    Posts
    72

    help please. cant i ever use excel ?

    i want to access excel from a form in vb for which i declared
    Public anyvariable As Excel.Application
    this does not seem to work.
    what can i do to access excel data from a vb form. help please.

    Reply With Quote Reply With Quote
  2. January 5th, 2000, 04:53 AM #2
    dave clarke
    dave clarke is offline Junior Member
    Join Date
    Sep 1999
    Location
    London , UK
    Posts
    22

    Re: help please. cant i ever use excel ?

    What is the returned error, have you set the reference to the Excel COM in Project->References?

    Dim xclApp as Excel.Application
    set xclApp = new Excel.Application
    xclApp.Workbooks.Open FileName:="myfile.xls", ReadOnly:=true




    Reply With Quote Reply With Quote
  3. January 6th, 2000, 12:23 PM #3
    coolily
    coolily is offline Member
    Join Date
    Jan 2000
    Posts
    72

    whats the difference?

    is the microsoft excel 8.0 object library reference newer version of excel 7.0.
    i have excel 8.0 object library.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured