Updated Links and VB

[MCorn]

Hi,
Does anybody know how to write some vba that is
simulating a link refresh on a regular basis in
PowerPoint?
I have a link in PowerPoint from Excel that needs to be
updated automatically. (the auto update feature does not
work. I was told to write vba to simulate a link refresh.)
Any help would be appreciated!

Thanks, MCorn

 

[Guest]

-----Original Message-----
Hi,
Does anybody know how to write some vba that is
simulating a link refresh on a regular basis in
PowerPoint?
I have a link in PowerPoint from Excel that needs to be
updated automatically. (the auto update feature does not
work. I was told to write vba to simulate a link refresh.)
Any help would be appreciated!

Thanks, MCorn

.

hi mcorn,
i think it might be worth you taking a look at a company
called take-off. they have a product called DataPoint
Personal edition, it will do exactly what you're looking
for. you can download a free 30 day trial from their site
www.take-off.as. its very affordable and well worth the
purchase.

hope this is some help. it will certainly save you a lot
of time with vb.

Regards,

Scott Harvey
http://www.123powerpoint.com

 

[TAJ Simmons]

MCorn,
Update links during slide show Add-in for PowerPoint 97 or later
http://www.mvps.org/skp/updtlinks.htm

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free powerpoint templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com

 

[Shyam Pillai]

If you wish to update the contents of the Excel file while the show is
running, make sure to share the workbook to avoid error. By default the
workbook is opened in Exclusive mode which will only only a single
application to modify it.
-
Regards
Shyam Pillai

Toolbox: http://www.mvps.org/skp/toolbox/