Text to speech

**D_Rennie** · 08-31-2009, 02:55 PM

While looking around the web i found out that the text to speach is built into excel, though there is no way of getting to it withen 2007.
Found this writen by ken purls though it only works if this code is withen a open instance of excel. So it got me thinking, Ive heard of people talking about the personal.xls file and what i understand of it it runs this file whenever excel is opened. So how if at all can i put this in there so the text-speach is added to the ribbon on every excel file opened.

Please Login or Register  to view this content.

//needs blank error handling... On Error Resume Next
cheers

**martindwilson** · 08-31-2009, 03:14 PM

click office button
click excel options
click customize
select commands not in the ribbon
scroll down and you'll find the speak cells options
add to qat(quick access tool bar)

**Andy Pope** · 09-01-2009, 04:20 AM

Ken's article has a .xlam file. Once loaded will be available to all workbooks.
http://www.excelguru.ca/node/103

**D_Rennie** · 09-01-2009, 07:39 AM

Thankyou for the heads up on the original file.

I did have a very quick play at creating a personal file and putting the code in there.
Like i say a quick play though couldnt get the code to run on a workbook open procudure.

anyhow thankyou.

**Andy Pope** · 09-01-2009, 07:43 AM

Did you create the ribbonx required to add a button and assign it's onaction?

**D_Rennie** · 09-01-2009, 08:00 AM

no i didnot know they exisited till now,
Just seen ken's RibbonXCh07Examples and im still trying to figure that one out.
they seam very simlar to an addin button though. i think ill need a sitdown look to figure this out.

**Andy Pope** · 09-01-2009, 08:08 AM

Have a look at Ron's pages on Ribbon related thinks.
http://www.rondebruin.nl/ribbon.htm

Also check Stephen Bullen's chapter on the subject
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm

**D_Rennie** · 09-01-2009, 08:23 AM

thanks again andy.
There is a lot of reading and learning there. Hopefully if dont overload and can get somethings working like this withen the ribbon.