Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.GetCodeName/Get_CodeName
Hello
Both these methoeds return empty strings to my C++ Add-in code. Whereas VBA returns the expected codes sheet1, sheet2 etc.. Any idea how to get these Worksheet codes with automation? Regds Gap. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.GetCodeName/Get_CodeName
Gap,
Try something along these lines, with a reference set to MS VBA Extensibility: Sub ShowCodeName() MsgBox ActiveWorkbook.VBProject.VBComponents(ActiveSheet. Name) _ .Properties("_CodeName").Value End Sub HTH, Bernie MS Excel MVP "Gap" wrote in message oups.com... Hello Both these methoeds return empty strings to my C++ Add-in code. Whereas VBA returns the expected codes sheet1, sheet2 etc.. Any idea how to get these Worksheet codes with automation? Regds Gap. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.GetCodeName/Get_CodeName
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Gap, Try something along these lines, with a reference set to MS VBA Extensibility: Works quite nicely without the reference Bernie. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |