-
July 24th, 2021, 04:48 PM
#1
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 :
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|