Is there a substring function in ppt vba?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Powerpoint
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Document font sizes change on different machine I am running PPT 2003 w/ SP2. When I open presentations given to me by several other users in the office, the fonts resize or reformat on their own when I open the file. For example, a font may format to bold that was normal typface, or it may grow by a size. I checked the same files on another user's machine (who is running same version of Office), and the files open without issue. Is this the bug that has been mentioned a few times in earlier posts? Or do I have a setting toggled differently? Oh...the one I am working on now is a PPT doc with a single master slide. Tag: Is there a substring function in ppt vba? Tag: 386548
  - 2
    - Shape (unknown member) : Invalidid request. To select a shape, its view must be active. This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C8B0FF.E7A6DA80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi. This is my first attempt to write a PowerPoint macro though I've = written lots of Excel macros. I have a few questions: First, I'm trying to write a simple macro that will loop through all of = the slides in the open PowerPoint presentation and identify each = embedded Excel worksheet and activate it (the reason for this isn't = important but the worksheet is connected to a database and I want to get = fresh data). My macro looks like this: Sub UpdateExcelShapes() Dim oShape As Shape Dim oPresentation As Presentation Dim oSlide As Slide Dim oSelection As Selection =20 Set oPresentation =3D ActivePresentation Set oSelection =3D Application.ActiveWindow.Selection =20 For Each oSlide In oPresentation.Slides For Each oShape In oSlide.Shapes If oShape.Type =3D msoEmbeddedOLEObject Then If Left(oShape.OLEFormat.ProgID, 11) =3D "Excel.Sheet" Then oSlide.Select oShape.Select oShape.OLEFormat.Activate SendKeys "{ESC}" End If End If Next oShape Next oSlide ' If Not oSelection Is Nothing Then ' oSelection.Select ' End If End Sub When the macro gets to the oShape.Select statement I get the error = message in the subject line of this posting. What does it mean and how = do I fix it? I have no idea what view the message is referring to. Second, I've written a similar little macro for Word. In that macro I = needed the moral equivalent of the commented out code at the bottom of = the macro to reselect whatever was originally selected before the macro = started. Sadly in PowerPoint the Selection object doesn't have a Select = method. Any suggestions? Thirdly, if I can get this macro to work, I'd like to have it triggered = whenever the PowerPoint presentation is opened. I was looking for the = equivalent of the ThisWorkBook object that would have a Open event I = could hook into but I see no such object in the VBE project explorer = window. What am I missing? TIA, josh ------=_NextPart_000_003C_01C8B0FF.E7A6DA80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>Hi.  This is my first attempt to write a PowerPoint macro = though I've=20 written lots of Excel macros.</DIV> <DIV> </DIV> <DIV>I have a few questions:</DIV> <DIV> </DIV> <DIV>First, I'm trying to write a simple macro that will loop through = all of the=20 slides in the open PowerPoint presentation and identify each embedded = Excel=20 worksheet and activate it (the reason for this isn't important but the = worksheet=20 is connected to a database and I want to get fresh data).  My macro = looks=20 like this:</DIV> <DIV> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>Sub = UpdateExcelShapes()<BR>   Dim=20 oShape        As = Shape<BR>   Dim=20 oPresentation As Presentation<BR>   Dim=20 oSlide        As = Slide<BR>   Dim=20 oSelection    As Selection<BR> <BR>   Set=20 oPresentation =3D ActivePresentation<BR>   Set oSelection =3D=20 Application.ActiveWindow.Selection<BR> <BR>   For Each = oSlide In=20 oPresentation.Slides<BR>      For Each oShape = In=20 oSlide.Shapes<BR>         If = oShape.Type=20 =3D msoEmbeddedOLEObject=20 Then<BR>          &nbsp= ; If=20 Left(oShape.OLEFormat.ProgID, 11) =3D "Excel.Sheet"=20 Then<BR>          &nbsp= ;   =20 oSlide.Select<BR>         &n= bsp;    =20 oShape.Select<BR>         &n= bsp;    =20 oShape.OLEFormat.Activate<BR>       &n= bsp;      =20 SendKeys=20 "{ESC}"<BR>          &n= bsp;=20 End If<BR>         End=20 If<BR>      Next oShape<BR>   Next=20 oSlide</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>'   If Not oSelection = Is Nothing=20 Then<BR>'      = oSelection.Select<BR>'   End=20 If<BR>End Sub<BR></FONT></DIV> <DIV>When the macro gets to the oShape.Select statement I get the error = message=20 in the subject line of this posting.  What does it mean and how do = I fix=20 it?  I have no idea what view the message is referring to.</DIV> <DIV> </DIV> <DIV>Second, I've written a similar little macro for Word.  In that = macro I=20 needed the moral equivalent of the commented out code at the bottom of = the macro=20 to reselect whatever was originally selected before the macro = started. =20 Sadly in PowerPoint the Selection object doesn't have a Select = method.  Any=20 suggestions?</DIV> <DIV> </DIV> <DIV>Thirdly, if I can get this macro to work, I'd like to have it = triggered=20 whenever the PowerPoint presentation is opened.  I was looking for = the=20 equivalent of the ThisWorkBook object that would have a Open event I = could hook=20 into but I see no such object in the VBE project explorer window.  = What am=20 I missing?</DIV> <DIV> </DIV> <DIV>TIA,</DIV> <DIV> </DIV> <DIV>josh</DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_003C_01C8B0FF.E7A6DA80-- Tag: Is there a substring function in ppt vba? Tag: 386545
  - 3
    - Audio setup in PPT 2007 Using PPT 2007 in XP home for the first time (used PPT 97 previously) to create a birthday montage. I have a few .wav files to include, and I want each to span over a specified number of slides. I'm using Rehearse Timings which I believed would allow me to set the exact number of seconds the clip played per individual slide, and then transition automatically to the next slide. But when you play the slideshow, the slides don't transition at all. (this will be burned onto CD and connected via laptop to be viewed on a TV so it HAS to transition automatically). To add the file, I did Sound - Sound from File. I've tried every possible setting and it still doesn't transition. I don't remember having this problem in PPT 97, but then I don't think that had the Rehearse Timings feature. PLEASE HELP!! THANK YOU!! Tag: Is there a substring function in ppt vba? Tag: 386543
  - 4
    - How can I type foreign accents without using insert symbols? I teach foreign languages and always struggle with the fact that I cannot as easily type foreign accents in Powerpoints as I can in Word where this is not difficult at all. In Powerpoint I have to use the "Insert Symbol" function for every accent which takes so much time. Does anyone have some advice on how I can do this more easily? Thank you! Tag: Is there a substring function in ppt vba? Tag: 386542
  - 5
    - Since installing SP 3 we can no longer open ppsm files Since installing SP 3 we can no longer open ppsm files. This is because the open command in the file association is deleted for some reason. Anyone can tell me some alternative to reenable the same. Tag: Is there a substring function in ppt vba? Tag: 386540
  - 6
    - how to refer to an excel spreadsheet from powerpoint? I need to copy some data from an excel spreadsheet to power point. How can I refer to the spreadsheet from ppt vba? thanks Tag: Is there a substring function in ppt vba? Tag: 386539
  - 7
    - How to type a bullet point from vba? I need to type some text including a bullet point in a cell of a table, how can I specify the bullet point in the code? thanks, Lily Tag: Is there a substring function in ppt vba? Tag: 386538
  - 8
    - Video in PPT flashes for a moment before playing... Hello, I have two videos in a powerpoint (2007) presentation, and when the slide advances, the first frame of the video shows, then disappears for a second, and then the video resumes. It does not do this when played outside of Powerpoint. I've moved a copy of the PPT along with the two WMV files and shortened the names to minimize the length of the file path. This helped a bit, but is there anything else i should try? Thanks in advance! Michelle Tag: Is there a substring function in ppt vba? Tag: 386536
  - 9
    - How to resize individual elements within a chart template I need to be able to alter slightly an individual element within the standard chart template - the size of the "assistant" box. I have applies the template to a slide and right-clicked the box that I want to add an assistant box under. I then right-clicked the assistant box and choose "Format Auto Shape". However, under "Format Auto Shape" all re-size options are greyed out. Is there any way to resize a box within this template??? Tag: Is there a substring function in ppt vba? Tag: 386535
  - 10
    - Last Date Saved Field How do you add a {LAST SAVED DATE} Field to a 2003 Power Point presentation? This feature is available in MS Word 2003. Tag: Is there a substring function in ppt vba? Tag: 386533
  - 11
    - Referring to a table on any slide? How can I refer to a table on any slide from vba? without using activewindow.selection.shaperange(1).table, but just use the slide number and then point to the table? thank you, Lily Tag: Is there a substring function in ppt vba? Tag: 386532
  - 12
    - PowerPoint goes back to slide 1 during presentation When in presentation mode, the slides went back to slide 1 all by itself - no one was touching ANYTHING. I am using PPT 2003. I imported "slides from file" into my document from our speakers document. This is the only thing I can think that would have caused this glitch. It happened several times. Has anyone out there had this happen to them? Tag: Is there a substring function in ppt vba? Tag: 386531
  - 13
    - WMA sound files I am using the latest Pwr Pnt and want to include some .wma sound files. According to what I read on the "Help" that format is suported by PWR PNT. These songs play just fine on my Windows Media Player. According to what I read on "help" I may need a different codex. I only know what I read so any help or assistance would be greatly appreciated. Mastiff Tag: Is there a substring function in ppt vba? Tag: 386527
  - 14
    - PowerPoint 2007 acting SLOW after XP SP3 upgrade After upgrading my XP Prof (danish lanq) to SP3 my PowerPoint is getting useless :( All other Office applications works ok - but PowerPoint is lagging... No other changes to the platform have been made... Anyone experiencing the same problem? Tag: Is there a substring function in ppt vba? Tag: 386520
  - 15
    - "Color Typewriter" animation slower in '07 than '03 My company has rolled-out an Office '07 pilot, and I've noticed a drastic decrease in visual performance when viewing animated slides I've created in the '03 version of PPT. Specifically, the color typewriter effect performs more sluggishly. I've read the thread regarding "print drivers" as the fix, but I'm still curious as to why there is a difference in performance between the two versions when the environment (my desktop configuration, the network...) has not changed. Is PPT using a different method for rendering animations? Have the recommended system requirements been radically changed? While I have the help desk looking into the matter, I'm curious to see if there has been similar feedback. Tag: Is there a substring function in ppt vba? Tag: 386517
  - 16
    - SmartArt conversion If I decide to convert samrtArt back to bullet list without copying and pasting that from the text pane how can I do that?? Tag: Is there a substring function in ppt vba? Tag: 386516
  - 17
    - Custom Animation I use Office 2003. When I try to animate (Custom Animation), I can set it up but the animation doesn't work. That is - the Custom Animation menu opens up, I can see that Group 1 should appear with the first mouseclick, Group 2 with the second etc. but when I go into the Slideshow, everything appears at once. I did add the option that would allow me to open Office 2007 documents a few weeks ago, could this cause any problem? Thanks Matt Tag: Is there a substring function in ppt vba? Tag: 386511
  - 18
    - Can I create a broken bar chart for the larger values in Powerpoin I'm doing a graph that has a few low numbers but one high one, I have seen charts before where the higher number column appears broken to show that it is a higher number? The graph I'm using is a bar chart. Can anyone point me in the right direction? Tag: Is there a substring function in ppt vba? Tag: 386507
  - 19
    - power point macro Although I can create a Macro in Power Point, I can't get it to accept a sequence of custom animation commands. Any clues anybody? Tag: Is there a substring function in ppt vba? Tag: 386499
  - 20
    - Powerpoint 2003:Missing Images I have created 4 Chapters of Photo and Sound Images (460 Images in Each Chapter) using Powerpoint 2003. The problem I have is, when using Powerpoint 2003 to view the Presentations, about every 5th to 12th Image is missing on screen. Since this problem presented itself in Powerpoint, I also notice that Emailed PPSs miss some Images. This problem does not happen if I use Microsoft Powerpoint 2003 Viewer to view files outside of Powerpoint 2003 itself. I have also determined that the problem does not present itself when the same Presentation Files are run on other PCs or Laptops. In an effort to identify the cause of this problem I have tested with Graphics Accelleration both on and off and various settings for Accelleration. No improvement. I have changed out and increased DDR400 Memory to max of 4 Gb, I have performed a Windows Repair Install and Un-Installed Graphics Card Driver and Installed current version Driver 93.71, all to no avail, missing Images still persist. My PC specs: MB = Gigabyte GA-81PE775 Pro, CPU = Intel P4 3.0GHz, RAM = 4Gb DDR 400, Video = GeForce MX 4000 93.71 Driver, HDD = SATA 500Gb, OS = XP Pro SP2 + Updates, Application = Office 2003 SP3 + Updates, AVG AntiVirus and AVG AntiSpyWare. Can anyone Please advise if my Hardware can be contributing to this problem in any way or any other pertinent information that may assist in resolving this problem. Thank You, Owen Carlton Tag: Is there a substring function in ppt vba? Tag: 386498
  - 21
    - MCI error - mp3s randomly stop working; reinstalled WMP11 but noth Would love some help here. I have PPT 2003 and XP sp2. Using this set-up I have created many ppt presos with media in them and they have all worked fine. Up until now that is. Now I am getting this MCI error ("The specified file cannot be played on the specified MCI device. blah blah.."). The offending media in question is an mp3 I have run mplayer2.exe (WMP6?) and mp3s will not work there either, the error being "The source filter for this file could not be loaded. (Error=80040241)". The same mp3s work fine though in every other application I've tried (WMP11, Winamp, RM). So does this mean the problem is not the codecs? I've tried uninstalling and re-installing WMP11 I don't know how many times. I have also uninstalled pretty much every program I can think of that could potentially be causing a codec clash, including: - Winamp - Real Player - Samsung PC Studio + any other programs I saw which had anything to do with multimedia (exlc. VLC and PowerDVD) I have never downloaded and installed a codec pack, rogue or otherwise. To be honest until today I didn't even know what a codec was. The number of character in the file path is well less than 100 too. I would be most grateful for any advice as honestly I am at my wits end. I just don't understand how it could all work fine one day and now it doesn't. Kind regards Rob Tag: Is there a substring function in ppt vba? Tag: 386495
  - 22
    - PPT2003: Export of "attached" forms, files... Dear all, I am developing a PPT (2003) AddIn which contains quite a lot of files (forms, classes, modules...) meanwhile. For backup and repository purposes I usually export all of these files. Something I am looking for is automising this export. For now I have to click on each file, select "export", select the folder and save. This can be quite annoying for a lot of files (which I have). Is there an easier way - like a script or alike that automises this process? With regards, Martin. Tag: Is there a substring function in ppt vba? Tag: 386494
  - 23
    - Editing selected table cell in VBA Hi All I'm wanting to write a macro to modify the properties of some cells I have selected in a table in ppt (but not every cell in the whole table). I can't seem to work out how to let vba manipulate just the cells I have selected. Is this possible? Can anyone help? Thanks in advance Tag: Is there a substring function in ppt vba? Tag: 386482
  - 24
    - Organizing a "Library" of Slides Is there a way of organizing a collection or library of slides taken from a number of different presentations so they can be reused in future presentations? I've seen ads for a program called SlideWhere. Is this program helpful? Are there other programs that are better? Is there a way to do this just using Powerpoint alone (I'm using PPT97 and PPT2003)? Thanks! Tag: Is there a substring function in ppt vba? Tag: 386480
  - 25
    - changing where a task pane is displayed on the monitor screen I have Powerpoint 2003. I've been working right along on programs OK and when I click on "custom animation", the task pane has been displaying on the far right side of my monitor screen. Now all of a sudden the task pane (and other ppt task panes) display across the entire top of the monitor screen. I can't figure out what I did to change how task panes display and I have been unable to change it back so that the task panes display along the far right side again. HELP! Tag: Is there a substring function in ppt vba? Tag: 386479
- Next
  - 1
    - slide transitions w/ custom animation I have a ppt presentation w/ custom animation set for five-second intervals automatically. However, after the last graphic or text box appears, the slide transitions nearly instantaneously to the next slide. I have the slide transitions set for five seconds throughout the entire presentation. Is there an easy way to slow down the transition or do I need to go back and reset each slide transition one at a time? Thanks. -- NickBaque Tag: Is there a substring function in ppt vba? Tag: 386476
  - 2
    - Keyboard activation in Presentation mode Is it possible without vba to have an action button behave as a keyboard keystroke? For example, I create an "A" key; in presentation mode someone clicks the key and it prints out an "A". Will I need to use activex buttons instead? I thought about pure trigger animation and building the characters myself through custom animation but that seemed too tedious... I also want to build a working ppt or pptx calculator in the same fashion but have come across the same problem... Any suggestions? Tag: Is there a substring function in ppt vba? Tag: 386474
  - 3
    - How do I change the default that opens new file when PPT is opened I'm becoming annoyed at a new file opening every time I open PowerPoint -- how do I change that default? Tag: Is there a substring function in ppt vba? Tag: 386468
  - 4
    - Motion Path Accuracy I'm just starting to use motion paths to develop some animations, and I'm having trouble making them accurate enough to keep my objects aligned. For example, say I have a group of four boxes (upper left, upper right, lower left, lower right) that form a grid. I want to show those boxes moving around to show a particular reordering of data that I'm illustrating, but when the boxes come to their final resting places in the same grid, they are not well lined up because the motion paths don't seem to "snap" to where I'm wanting the boxes to move (meaning, the end points of the paths are not in the right place). Are there tricks to making accurate paths? I've found the same disappointment in general when working with freeforms - I don't know how to put the points exactly where I want them when drawing or editing. Thanks, Eric ------------------------- If toast always lands butter-side down, and cats always land on their feet, what happen if you strap toast on the back of a cat and drop it? Steven Wright (1955 - ) Tag: Is there a substring function in ppt vba? Tag: 386464
  - 5
    - Copy Excel data to a large table in a ppt slide I have a large data table in power point, the content of which mainly comes from excel spreadsheet. I cannot use copy and paste as the table doesn't exist in excel. I want to build a vba to copy data from excel to power point directly whenever there is an update. However, it is difficult to point to the correct position of each data point in the power point table. Is there a way to do this? thanks. Tag: Is there a substring function in ppt vba? Tag: 386463
  - 6
    - PowerPoint 2003 - Disable Autosize My company has standards for PPT font sizes, etc. However, I find that whenever I create a presentation, PowerPoint takes it upon itself to resize my fonts without my permission. Is there a way to shut this off? Tag: Is there a substring function in ppt vba? Tag: 386456
  - 7
    - Track Changes Hello, I'm using PPT 2002 on a Windows XP SP2 computer. How can I share a PPT file with another user and both of us be able to track changes? Thanks. Tag: Is there a substring function in ppt vba? Tag: 386454
  - 8
    - Stretching WordArt In PPT2003 you could stretch text vertically or horizontally - but in 2007 it seems that this function no longer exists - but essentially treats all text the same - it maintains the proportions of the fonts. This is a big step backwards if true - despite the great 3-D effects that you can otherwise apply. Am I missing something? Tag: Is there a substring function in ppt vba? Tag: 386447
  - 9
    - Opening Excel Files from Powerpoint VBA I need to open some excel files from powerpoint VBA and also to copy some cells over to one slide. I don't know how to write the vb code in powerpoint. Does anyone know? thanks Tag: Is there a substring function in ppt vba? Tag: 386446
  - 10
    - vids:xvid decompressor When I try and follow the instructions to put video into powerpoint, it returns the error message: video not available cannot find 'vids:xvids' decompressor I can view the video through the media player. Do you have any ideas? Please return me!!! Tag: Is there a substring function in ppt vba? Tag: 386445
  - 11
    - How do I share a power point presentation? I want to be able to share a power point presentation so that if others have it open I can still make edits to the presentation. Thanks! Tag: Is there a substring function in ppt vba? Tag: 386443
  - 12
    - Hardware acceleration in 2007 I've had PPT 2007 installed on two very powerful laptops but find that hardware acceleration just doesn't work like it did in 2003. With HA enabled the result is the same on both computers: Problem #1: the object animations do not play out in the slide preview - everything just appears (but play correctly with HA off) Problem #2: when playing the slideshow HA has no affect on the speed whatsoever - and is sometimes even slower. Problem #3: all the object animations are slower with much faster computers in PPT 2007 than they were with slower computers in PPT 2003 It seems that MS has managed to just break the hardware acceleration function between versions. I can't be the only one who has this problem. Config: Dell XPS M1530 Intel Duo Core 2.4 4Gb RAM 256Mb video RAM 200Gb, 7200 RPM HD Vista Ultimate All updates installed for Vista and Office Tag: Is there a substring function in ppt vba? Tag: 386442
  - 13
    - size of blinking cursor Can anyone help me change the size of the blinking cursor in PowerPoint 2007? I am running Vista Home Premium. I have increase the thickness option in the Ease of Access > Make the computer easier to see page. I see the dired effect in Word but there is no effect in PowerPoint. Thanks for your help in advance Clement Tag: Is there a substring function in ppt vba? Tag: 386441
  - 14
    - save Powerpoint on DVD for TV viewing Is there a way to save a Powerpoint on a DVD for TV viewing? -- jrs Tag: Is there a substring function in ppt vba? Tag: 386439
  - 15
    - Need alternative to Pixie One of the coolest, cutest little utilities, Pixie, accurately and reliably picks up color on screen and displays RGB and other values. Free, small, easy... ...and evidently incompatible with Vista, according to two clients who have tried it. Can anyone confirm this incompatibility (perhaps there is a workaround), and if confirmed, has anyone found an alternate product for grabbing color values from screen images that works with Vista? Many thanks... -- Rick Altman Author Why Most PowerPoint Presentations Suck...and how you can make them better www.betterppt.com Host The PowerPoint Live User Conference Sep 21-24 | San Diego CA www.powerpointlive.com Tag: Is there a substring function in ppt vba? Tag: 386438
  - 16
    - Steps to add a macro to a customized toolbar Can you add a macro to a customized toolbar so that it shows everytime you open PowerPoint 2003 that it will be there? If so, can you provide me with the steps to how to do it. Thanks! -- Cynthia Behnam Tag: Is there a substring function in ppt vba? Tag: 386432
  - 17
    - Macro won't run in slideshow view I am in the process of making a game for a meeting resembling Wheel of Fortune. I was planning on creating a macro for each of the letters of the alphabet so that when clicking on the letter it automatically poplulates the letter in the puzzle. The macro will run if i run it from clicking on tools/macro/macro and clicking run, but they won't work when i add them in the action setting for the slide show. I've tried both action buttons and just text and adding the new action setting so that on click it runs the macro, but they won't run. It underlines the text so i know it recognizes that there is an action associated with it, but when i click on it from the slideshow, it won't run. What am i doing wrong!?!?! I've also tried changing my security to low, but that doesn't make it work either. :( Tag: Is there a substring function in ppt vba? Tag: 386424
  - 18
    - How to Delete saved Slides from Recent Document? Power Point 2007. How to delete/remove one or two saved-slides with Thumtack on the right from Recent Document? Thanks for your help in advance. Tag: Is there a substring function in ppt vba? Tag: 386421
  - 19
    - How to turn of hyperlink virus warning? Hello All, when a Package to CD is created in PPT2003 with linked PDF documents, when the CD is run and the hyperlinked button to the PDF is clicked, a warning appears with "Some hyperlinks contain viruses or.....", but of course the pdf's do not contain any viruses, so... How do I get rid of these warnings?? Thanx! Guurt Tag: Is there a substring function in ppt vba? Tag: 386418
  - 20
    - NG test *test* does this get through again? (sorry) Tag: Is there a substring function in ppt vba? Tag: 386416
  - 21
    - sound in a different slide what should i do to make different slide (content for subtopic) with a different sound??? ... sorry if my english was broken Tag: Is there a substring function in ppt vba? Tag: 386414
  - 22
    - photo album - set default font for captions? I find the Photo Album with captions useful for managing photos and presentations but would like to change the default font for captions. Can anyone help? Tag: Is there a substring function in ppt vba? Tag: 386411
  - 23
    - Default shadow settings Is there a way to change the default shadow settings when I choose a lower-right drop shadow for example? I would like to have the default be 0% transparency and 10 for distance. It is a pain to have to set it for every object I create. I don't want to use format pickup, because I don't want all the attributes all the time. What about other object settings? I assume if there's a way for one then there's a way for all. Can this be done in the registry? It has to be getting it's defaults from somewhere. It sure would be nice if you could change these defaults through the interface. Tag: Is there a substring function in ppt vba? Tag: 386410
  - 24
    - POWERPOINT Presentations - Viewing Why can't I open a Powerpoint Presentation when I can see a Preview? Are there any file open blocks that I can unset? -- User Tag: Is there a substring function in ppt vba? Tag: 386402
  - 25
    - PP2003 takes 10 minutes to load templates after 2007 converter ins I installed MS 2007 file converter to work on PP2007 files using PowerPoint 2003 but now PP 2003 takes >10 minutes to bring up design templates using 100% CPU. Tag: Is there a substring function in ppt vba? Tag: 386401

And how does it work?

Re: Is there a substring function in ppt vba? by Chirag

Chirag
Thu May 08 14:18:09 CDT 2008

InStr(<Start offset in string>, <string>, <substring>)
returns 0 if substring not found in string. otherwise returns the offset
(which is >= Start offset in string).

InStrRev() is the same but searches from the end.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"Lily" <Lily@discussions.microsoft.com> wrote in message
news:084A1901-F7C4-4E27-8439-85AD21E95F95@microsoft.com...
> And how does it work?

Top

Re: Is there a substring function in ppt vba? by Steve

Steve
Thu May 08 16:03:26 CDT 2008

In article <084A1901-F7C4-4E27-8439-85AD21E95F95@microsoft.com>, Lily wrote:
> And how does it work?

Other than the specific features that refer to the PowerPoint object model, PPT
VBA is the same as any other VBA and the same as Visual Basic in most respects.

Mid$, Instr, Left$, Right$ all work the same as in other VB/VBA dialects.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Top