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

Threaded View

  1. #1
    Join Date
    Jun 2021
    Posts
    51

    How to get worksheet name?

    Hi,
    I'm having trouble locating the worksheet name ,
    My code uses as following:
    Code:
    IDispatch* xlSheet; //<--get xlSheet ok
    
       VARIANT result4;
        VariantInit(&result4);
        AutoWrap(DISPATCH_PROPERTYGET, &result4, xlSheet, L"Name",0); 
        if (result4.vt == VT_BSTR)
        {
    	  
        }
    Can you tell me where did I go wrong?
    because from this post says it takes no arguments so I set the number of arguments to 0 .

    The error I get is :

    Name:  bug1.jpg
Views: 1123
Size:  10.3 KB

    When I use the code snippets from above post, it runs fine.
    Did I misspelled the property name "NAME"?

    Thanks you!
    Last edited by Dang.D.Khanh; July 24th, 2021 at 04:54 PM.

Tags for this 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
  •  





Click Here to Expand Forum to Full Width

Featured