CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Guest

    opening .XLS file in vb

    hi

    i want to know that how can i open a spcified Excel file(.XLS) in VB application and also i should be able to edit .XLS sheet and print it and then back to VB application

    thanks


  2. #2
    Join Date
    May 1999
    Posts
    23

    Re: opening .XLS file in vb

    Hello !

    In your project, you can reference :
    Microsoft Excel x.0 Object Library
    So when you'll Dim a New variable, there'll be new choices :
    Excel.Application, Excel.WorkSheet, ...
    And i saw that the Excel.WorkSheet object as a PrintOut method !!

    I hope it will help you !
    For more help, see the VBAXLx.HLP in your Office directory (where x is the version number of Excel).
    If not installed, you can find it on the Office CD !


Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured