Steve and Brian,

Back in Jan of this year you assisted me with the vba code to find and
extract a value from a ppt table. At that time, Brian stated that he
preferred to use excel spreadsheets vice ppt tables.

So... Brian how do I code to search an embedded excel worksheet for a
specific value while running a presentation. I don't want to open excel.

I am currently using vba controls to allow the user change various values
during the presentation. Based on these values, I do some calculations.

The spreadsheet could eventually run to 1400 lines. The user entered values
designate row and colunm values.

Thanks
--
Tom Conrad

Re: ppt 03 Use vba to find & extract a value fm an embedded excel work by Steve

Steve
Thu Jul 17 10:16:27 CDT 2008


You'd have to open Excel (ie, activate the embedded worksheet) in order to work
with it, but I'm guessing that Brian can tell you how to do it invisibly.



> Back in Jan of this year you assisted me with the vba code to find and
> extract a value from a ppt table. At that time, Brian stated that he
> preferred to use excel spreadsheets vice ppt tables.
>
> So... Brian how do I code to search an embedded excel worksheet for a
> specific value while running a presentation. I don't want to open excel.
>
> I am currently using vba controls to allow the user change various values
> during the presentation. Based on these values, I do some calculations.
>
> The spreadsheet could eventually run to 1400 lines. The user entered values
> designate row and colunm values.
>
> Thanks
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Living in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com