Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    93

    Unanswered: excel automation

    hello freinds !!
    i am have created a new sheet with excel automation and it worked fine
    my concern is the new sheet created shuld be without grid lines
    and i tried with 3 options
    with wrksheet
    wrksheet.displaygridlines=false
    end obj

    but it throws the error as .. no such property exist !!

    can any of you guys help me out with any possible thoughts

    thanks

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Excel automation can be very confusing to work with.
    As I said in the other post - you can learn a lot by using the "Record Macro" tool, performing the operation, and then viewing what was recorded - and going to the help file for clarification on what properties apply to what objects.

    Windows("book1.xls":1).DisplayGridlines = False

    EDIT:
    You should probably be posting these over in the Excel forum
    Last edited by RedNeckGeek; 12-13-07 at 17:26.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Code:
    with wrksheet
       .displaygridlines=false
    end obj
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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