Re: Am I making things too complicated?



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/microsoft.public.powerpoint/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/microsoft.public.powerpoint/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 <1135749727.550627.15320@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
KKawahata@xxxxxxxxx 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.
>
>
.



Relevant Pages

  • pivottable and OLAP cubes
    ... I have OLAP cubes on worksheets which draw data from an access database. ... Sometimes, some of these queries return no records, because there are none. ...
    (microsoft.public.excel.worksheet.functions)
  • How to set Optionbox value from code?
    ... I have an Excel applciaiton, it reads values from an Access database and ... One of these worksheets contains a group box with two option boxes labelled ... controls are NOT bound to any worksheet cells. ...
    (microsoft.public.excel.programming)
  • Update all Sheets
    ... I have 2 linked queries to My access database. ... I have 4 Worksheets in my Excel file. ... For Each qryTab In wks.QueryTables ...
    (microsoft.public.excel.misc)
  • Am I making things too complicated?
    ... excel group or a MS access group, its a little bit of everything. ... the worksheets are actually just SQL query which draw information from ... the MS access database. ...
    (microsoft.public.powerpoint)
  • Re: Minimize - maximize - restore Buttons are gone
    ... If that is not the answer, try asking in an Excel group. ... "Stormin' German" wrote in message ... > I can no longer copy worksheets into or out of that book ...
    (microsoft.public.win2000.general)