Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Worksheet code names from PowerPoint 2007
Why does this work when used in PowerPoint 2003
Public Function FindWorksheet(myXLBook As Excel.Workbook, _ myWSCodename As String) As Excel.Worksheet Set FindWorksheet = Nothing On Error Resume Next Set FindWorksheet = myXLBook.Worksheets(CStr(myXLBook.VBProject.VBComp onents(myWSCodename).Properties("Name"))) On Error GoTo 0 End Function And it doesn't work in PowerPoint 2007. I have confirmed that there is a worksheet in myXLBook that matches myWSCode name. Thanks! Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format only part of a DataLabel in Excel 2007/PowerPoint 2007 char | Charts and Charting in Excel | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Code to create worksheet names based on the values in the selectedrange | Excel Programming | |||
2007 Assigning Range Names in one spreadsheet/worksheet | Excel Discussion (Misc queries) | |||
How to find hidden names on an Excel worksheet ? | Excel Worksheet Functions |