472,969 Members | 1,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,969 software developers and data experts.

Hyperlinks to Powerpoint and Word - how much control does VBA give you?

I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.

I know that Access can store a hyperlink to a slide or a Word bookmark, and
I have fooled around with it. But I do not want an app where the client has
to click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no user
interaction.

In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevant
info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant
slides to a new presentation.

Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Access
to simulate a user clicking on the link.

Thanks for any info.
Alan
Nov 12 '05 #1
6 3879
On Sun, 08 Feb 2004 05:09:55 GMT, "Colleyville Alan"
<ae***********@nospam.comcast.net> wrote:

Have you considered Automation?
-Tom.
I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.

I know that Access can store a hyperlink to a slide or a Word bookmark, and
I have fooled around with it. But I do not want an app where the client has
to click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no user
interaction.

In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevant
info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant
slides to a new presentation.

Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Access
to simulate a user clicking on the link.

Thanks for any info.
Alan


Nov 12 '05 #2
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:9g********************************@4ax.com...
On Sun, 08 Feb 2004 05:09:55 GMT, "Colleyville Alan"
<ae***********@nospam.comcast.net> wrote:

Have you considered Automation?
-Tom.
Yes - as stated below,
I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Accessto simulate a user clicking on the link.
I am happy to use automation. But I want to know if Access can use the
hyperlinks as a way to get to the data. If I determine that slides 72 and
85 of one file plus slide 63 of another file are what I want, then querying
out some records that have the hyperlinks in them would allow a user to
click them on a form and show the 3 slides. But I do not want them show; I
want them copied to a new presentation. I can do the automation coding *if*
I can have VBA and Access simulate the clicking of a hyperlink. Is there a
command that does this, that takes you to the slide a hyperlink would?

\I have an application that has an Access table that stores the locations

ofslides in a Powerpoint file. This used to work fine when there were about 4files and 200 slides. The database would open all four PPT files at once,and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer isbogging down with trying to open them all at once.

I know that Access can store a hyperlink to a slide or a Word bookmark, andI have fooled around with it. But I do not want an app where the client hasto click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no userinteraction.

In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevantinfo and copy it to a new Word doc. WIth PPT, it woulcd copy the relevantslides to a new presentation.

Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Accessto simulate a user clicking on the link.

Thanks for any info.
Alan

Nov 12 '05 #3
I am not familiar with the memory requirements of PPT slides but your
description of the problem hints you have maxed out on RAM and that your
computer is switching data between RAM and the harddrive as needed. Could this
be your problem?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Colleyville Alan" <ae***********@nospam.comcast.net> wrote in message
news:DwjVb.249480$na.415331@attbi_s04...
I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.

I know that Access can store a hyperlink to a slide or a Word bookmark, and
I have fooled around with it. But I do not want an app where the client has
to click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no user
interaction.

In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevant
info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant
slides to a new presentation.

Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Access
to simulate a user clicking on the link.

Thanks for any info.
Alan

Nov 12 '05 #4

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:jg*******************@newsread1.news.atl.eart hlink.net...
I am not familiar with the memory requirements of PPT slides but your
description of the problem hints you have maxed out on RAM and that your
computer is switching data between RAM and the harddrive as needed. Could this be your problem?


I have checked and it looks like there is still avail RAM. But it also
looks like PPT is having a problem; "corrupt" may be too strong a word, but
I just ran the Detect and Repair feature and it still is very slow opening
files and when I tried to run a slideshow with only 12 slides, it took about
12 seconds from when I hit "run" until the first slide came up.

My question about hyperlinks still remains since I want to use a similar
approach for managing info in Word docs. Any ideas about whether Access can
simulate clicking on a hyperlink?

<rest of msg snipped>
Nov 12 '05 #5
I'm not sure what you are asking but you can open a file programatically with:
Application.FollowHyperlink [FilePath] & "\" & [DocumentName]

Is this what you are looking for?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com



"Colleyville Alan" <ae***********@nospam.comcast.net> wrote in message
news:cxuVb.120738$U%5.599711@attbi_s03...

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:jg*******************@newsread1.news.atl.eart hlink.net...
I am not familiar with the memory requirements of PPT slides but your
description of the problem hints you have maxed out on RAM and that your
computer is switching data between RAM and the harddrive as needed. Could

this
be your problem?


I have checked and it looks like there is still avail RAM. But it also
looks like PPT is having a problem; "corrupt" may be too strong a word, but
I just ran the Detect and Repair feature and it still is very slow opening
files and when I tried to run a slideshow with only 12 slides, it took about
12 seconds from when I hit "run" until the first slide came up.

My question about hyperlinks still remains since I want to use a similar
approach for managing info in Word docs. Any ideas about whether Access can
simulate clicking on a hyperlink?

<rest of msg snipped>

Nov 12 '05 #6
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:qD******************@newsread1.news.atl.earth link.net...
I'm not sure what you are asking but you can open a file programatically with: Application.FollowHyperlink [FilePath] & "\" & [DocumentName]

Is this what you are looking for?


Yes, I am pretty sure that it is. I want to get to the file, then copy the
contents (e.g. a Word bookmarked section or an individual slide) back to an
open file (Word or PPT). This looks like it will do the trick. Thanks.
Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: C Williams | last post by:
Hi, I am writing some VB.NET code that compiles to a dll. There is some code within it that manipulates Powerpoint 2003. The dll I am writing is for smart tags, and I am having trouble...
10
by: John Smith | last post by:
Is there anyway to convert/export/copy an Access report into a Powerpoint slide? I know I can publish via Excel/Word but these remove formatting etc and therefore always require some degree of...
2
by: Jonathan Trevor | last post by:
Hi, For the last couple of releases of a product we're developing we've been running to very wierd behavior from IE and our ASP.NET web application which serves up various types of files and I'm...
3
by: C Williams | last post by:
We are having trouble automating Powerpoint 2003 from an asp.NET web page. I know that MS officially discourages doing such a thing, but we are trying nonetheless. On only one of two servers, I...
1
by: Stefan Weisenbach | last post by:
Hi there, I am currently working on a project to display powerpoint presentations inside a .NET application. As I understand there is no such thing as a ole control which can embed powerpoint...
9
by: Viken Karaguesian | last post by:
Hello all, I'm making a calendar section in a website. Each month is its own page and navigated by Previous / Next links. I have it working now with standard hyperlinks, but I want to learn how...
1
by: PengYu.UT | last post by:
There has been some lengthy discussion on pros and cons of Word and Latex on the web. But for drawing figure there are also two set of packages metapost and powerpoint(visio). I don't see much...
0
by: CodeHulk | last post by:
This is an office automation project. I am currently working on a document control project tracking powerpoint, word, and excel documents. The documents are required to have a specific style of...
3
by: =?Utf-8?B?UmlkZ2V3YXk=?= | last post by:
I am using PowerPoint 2000 with a very large presentation with many Hyperlinks, mostly to other slides but many also to Internet links. Recently, some of them are not working. I correct them on...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.