Hi-
I'm working on something and cannot for the life of me figure out why it won't work.
I need to pull in a range of cells from Excel into powerpoint, to complete a presentation. This is the code I have. It's not complete because I have been stepping through the code until I get to the end...
I think I figured it out!! My mistake was I was going to the text box in 'normal' view, going to "Edit hyperlink" and was hoping I would see my link. But I saw nothing, no hyperlink was inserted. But when I PLAY the show, it DOES hyperlink to where I said for it to go. The below tutorial...
This is what someone else said,
"It's failing because when you call the link, you're calling an empty link. The only info you have is slide title.
",,Tom_Slide"
An empty link location is the same as a link to "#" (that's why the link is displaying as #). You're getting errors because the code...
"and for the hyperlink, it inserts the following, "#,,Tom_Slide", and it is in the section for "Existing file or web page." "
... sorry I meant to say John_Slide, but the principle still applies.
Thanks! But it looks like I jumped ahead of myself. Now I can't even get the hyperlink.subaddress to insert a hyperlink based on the slide title. So say the text box is already selected, and I have a slide that has a title of "John_Slide," I use this code,
With...
Hi-
I'm trying to automatically insert a hyperlink into a text box based on what the text of the text box is. I am using PowerPoint.
What slide the text box links to can be linked based on the title of the slide. For instance, the title of the slide might be "John_Slide" while the text in...
I added a message box to slow it down and that worked. That will work for now, but hitting the message box over and over again might get old. I'll keep looking for a better answer.
Hi-
I'm encountering a problem with my code. I have a code that draws Excel charts into a PowerPoint presentation. When I step through the macro (with F8), it draws them all just fine. But if I run the macro without stepping, it gets jammed up at a certain point. I think I need to put a...
Hi-
I'm new to the forum but excited to find a community specifically geared to VBA.
I've looked all over the internet and through my book on VBA to fix the following but can't figure out how to do it.
Every time I open VBE, it opens every single sheet, module, etc. within the Excel program...
