Others (Shyam Pillai, Steve Rindsberg, and Brian Reilly come to mind)
have shared code similar to that in the links below.
You may want to check
http://groups.google.com/group/micro...t/browse_frm/t
hread/266050c1ab82d068/d1db214af1e867c5?
lnk=st&q=update+powerpoint+excel+group%3A*powerpoint*+author%
3Atushar&rnum=9&hl=en#d1db214af1e867c5
and
http://groups.google.com/group/micro...t/browse_frm/t
hread/d051479bb2295ce1/d576d044f5fe2ea8?
lnk=st&q=update+powerpoint+excel+group%3A*powerpoint*+author%
3Atushar&rnum=12&hl=en#d576d044f5fe2ea8
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <(E-Mail Removed)>,
(E-Mail Removed) says...
> I didn't know if I should place this question in this group or in an
> excel group or a MS access group, its a little bit of everything.
>
> Right now I have created a PP presentation with embedded worksheets and
> the worksheets are actually just SQL query which draw information from
> the MS access database. I'm trying to figure out a way to have the
> worksheets update themselves (by that I mean pull the info from the
> database) without me having to go open each worksheet individually and
> then click "enable automatic refresh" which is what I do currently.
>
>