Has anyone used VBA to update a ppt file with data from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We track jobs and part in Access for my job. Every week we have to create a powerpoint show to brief our department head on maintenance actions. At the moment, we have reports in Access that we export to Excel, reformat it and paste it into our powerpoint template.

I know how to envoke a powerpoint slide and edit minor things, but I need to update tables. I am new to programing in VB, but I do have experience with C++, Basic, HTML, and other misc languages. I am going to take VB this spring...
 
Allen,
maybe have a look at www.take-off.as/datapoint
With that add-on you call pull information from access into powerpoint
directly to generate new presentations.
Kurt.

Allen Pinkley said:
We track jobs and part in Access for my job. Every week we have to create
Click to expand...
a powerpoint show to brief our department head on maintenance actions. At
the moment, we have reports in Access that we export to Excel, reformat it
and paste it into our powerpoint template.
I know how to envoke a powerpoint slide and edit minor things, but I need
Click to expand...
to update tables. I am new to programing in VB, but I do have experience
with C++, Basic, HTML, and other misc languages. I am going to take VB this
spring...
 
At $220, it's a bit steep for us working stiffs. But since he is with a
company, maybe they can afford the un-stated business price.

If it was me, I'd wait to take the VBA course and have PPT pull the data it
needs from your Access database.

B
===============
Please spend a few minutes checking out www.pptfaq.com This link will
answer most of our questions, before you think to ask them.

Change org to com to defuse anti-spam, ant-virus, anti-nuisance
misdirection.
 
Allen,

Microsoft had an article on their web site a couple of years ago, with
downloadable files to use to learn how to automate Access from PowerPoint.
Here is the link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/OfficeKiosk.asp

Unfortunately, the download file is no longer available, but I have it and
can send it to you if you wish. It was designed for PowerPoint and Access
2000. The zipped file is about 2.2 Meg. Drop me a line with an e-mail
address that can handle that size attachment and I will send it to you.

Bill Foley
www.pttinc.com
Allen Pinkley said:
We track jobs and part in Access for my job. Every week we have to create
Click to expand...
a powerpoint show to brief our department head on maintenance actions. At
the moment, we have reports in Access that we export to Excel, reformat it
and paste it into our powerpoint template.
I know how to envoke a powerpoint slide and edit minor things, but I need
Click to expand...
to update tables. I am new to programing in VB, but I do have experience
with C++, Basic, HTML, and other misc languages. I am going to take VB this
spring...
 
For entertainment purposes, $200 would be steep. But if it works, the
savings at 1/2 hour - n hours per presentation...

Of course, depending on how many slides and the data organization, it
could be a matter of just a few minutes -- query the data in Access and
copy+paste the result into a table in a PP template.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You might want to check a non-programmatic solution using interactive
pivot tables. For a the tutorial see the PowerPoint | 'Interactive
PivotTables' page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks for the info, I will email you with a good email address on Monday.

v/r

Allen Pinkley
 
Back
Top