Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format only part of a DataLabel in Excel 2007/PowerPoint 2007 char SamW Charts and Charting in Excel 6 August 16th 09 08:56 PM
using the Excel generic worksheet names instead of user-given names in code Paul Excel Discussion (Misc queries) 5 June 26th 09 08:44 PM
Code to create worksheet names based on the values in the selectedrange Mike C[_5_] Excel Programming 2 March 17th 08 12:33 AM
2007 Assigning Range Names in one spreadsheet/worksheet bretsharon[_2_] Excel Discussion (Misc queries) 2 February 5th 08 01:34 AM
How to find hidden names on an Excel worksheet ? Jon Sipworth Excel Worksheet Functions 2 December 13th 05 06:16 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"