Get Excel sheet names, named ranges and reference tables-VBForums
Results 1 to 1 of 1

Thread: Get Excel sheet names, named ranges and reference tables

  1. #1

    Thread Starter
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,309

    Get Excel sheet names, named ranges and reference tables

    The attached VS2012 solution contains a class project that can be used in your projects to get sheet names, named ranges and reference tables via Excel automation. The test project is a simple console app.

    Note that you can get sheet names via OleDb but the sheetnames come back pre-sorted while using Excel automation we get them in ordinal position.

    To learn more (rather than me duplicating text in an existing article) see my MSDN article Working with Excel reference tables.
    Attached Files Attached Files

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.