Create a Print Button on Slide with VBA from Access

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
    - Text not justifying Hello, When I type a long sentance on powerpoint and it is more than one line, the second and subsequent lines are not in line with the first line, they are indented in. I'm not sure how to justify the lines. It may have something to do with bullets as these are descriptive lines underneath a bullet point. I want to keep the bullet point. Thank you, I am using powerpoint 2003 Tag: Create a Print Button on Slide with VBA from Access Tag: 386615
  - 2
    - lock presentation for editing from viewer? I want to lock my powerpoint presentation so that when I email it, the viewer wouldn't be able to edit it. Tag: Create a Print Button on Slide with VBA from Access Tag: 386612
  - 3
    - swf in powerpoint 2003 problems My girlfriend does marketing and she wants to put a flash file in her powerpoint for her boss. we can do the whole insert a shockwave flash object and point it to the swf but it doesn't work right. The thing is she got this flash file from someone else in the company. You're supposed to run the exe and it plays the flash content. There's a basic background and a table of links on the left. As you click on the links, the content in the right changes. All while this happens a series of pictures cycles at the top. Now, outside of powerpoint, if you run the swf file, it will only work correctly if the "assets" folder is in the same folder as the swf file. If you pull that assets folder out of the folder with the swf, it only shows the background. None of the content loads. That being said, is there a way in powerpoint to add the swf AND have it pull the content from the assets folder or is it not working because of how it's set up as the .exe package? She can call the .exe as a hyperlink in the document too, but then there's an annoying message saying some files can harm...blah blah blah, are you sure. Not too professional for a presentation in my opinion. is there anything we can do, or does this flash project need to be created a different way to play properly in powerpoint? I appreciate the help. Joe Tag: Create a Print Button on Slide with VBA from Access Tag: 386605
  - 4
    - Negative numbers in a spreadsheet cell I have the following code in my ppt vba working on an open spreadsheet dim s as string s=worksheet.cells(1, 1) It works fine for most cells. However, when the value is negative number, i.e., -8.75, I got a type mismatch error. And I couldn't find a way to get around. Does anyone have a solution? thanks, Tag: Create a Print Button on Slide with VBA from Access Tag: 386600
  - 5
    - Finding exact physical location of selected text or cursor Hi all, Just wondering if it is possible to find the physical location of selected text (ie, in units from top and left of slide) within a textbox/autoshape? I have a macro that formats my selected text in a special way, and I want it to put a line (not underline, an actual line) under the text. But I can't seem to get appropriate x,y coordinates for the line to put it in the right place. Thanks Tag: Create a Print Button on Slide with VBA from Access Tag: 386598
  - 6
    - Need to overlay PPT slides need to display the first slide then the second then the third without erasing the first slide Tag: Create a Print Button on Slide with VBA from Access Tag: 386592
  - 7
    - Printing animations I=92m working on a PPT add-in where I want to print a slide in different stages of an animation. If I print a slide that uses the build animation what I get is the final stage of the slide. I would like to be able to print all stages of the animation so that I can run a simplified version of the animation myself. I=92m currently printing slides into XPS format using the ExportAsFixedFormat method. Is it possible to print other stages of the animation into XPS format? Tag: Create a Print Button on Slide with VBA from Access Tag: 386586
  - 8
    - Powerpoint textbox copy from slide to slide I am trying to get information entered in a powerpoint by the user, through a visual basic text box, to carry from one slide to the next. I cannot seem to get it. I can get information to carry from one textbox to another on the same slide, just not from one slide to another. Any suggestions. Tag: Create a Print Button on Slide with VBA from Access Tag: 386571
  - 9
    - Information Pop-up You know how when you move your cursor over a command button a little box will pop up telling you what that button is? Is there anyway to get something like that in Power Point? We have a map of our campus and we would like to set it up so that when you move the mouse over a building a little box would pop up with some basic information (building name, date of construction, gross square feet). We don't want a hyper link to a new slide, we just want the box to pop up on the current slide. Possible? Tag: Create a Print Button on Slide with VBA from Access Tag: 386564
  - 10
    - Open multiple excel spreadsheet from ppt VBA I used set wksheet1=XLApplication.workbooks.open(excel filename as string).worksheet("ws1") and it did work. But I don't know how to open another worksheet from the same excel file. thanks, Tag: Create a Print Button on Slide with VBA from Access Tag: 386561
  - 11
    - Video playback in Poweroint 2007 using Windows XP I recently purchased a new HP laptop computer. I ordered it with Windows XP but I have Office 2007 installed. I am a frequent user of Powerpoint. I have tried inserting standard .wmv video files but they won't play. So I used my old computer with Windows XP but Poweroint 2003 and created a presentation with a few .wmv files and .wav files. Everythign is fine. I then uploaded the presentation to a website and downloaded it to my new computer and it plays fine. Any suggestions?? Tag: Create a Print Button on Slide with VBA from Access Tag: 386554
  - 12
    - Is there a substring function in ppt vba? And how does it work? Tag: Create a Print Button on Slide with VBA from Access Tag: 386551
  - 13
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386548
  - 14
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386545
  - 15
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386543
  - 16
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386542
  - 17
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386540
  - 18
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386539
  - 19
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386538
  - 20
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386536
  - 21
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386535
  - 22
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386533
  - 23
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386532
  - 24
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386531
  - 25
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386527
- Next
  - 1
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386520
  - 2
    - "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: Create a Print Button on Slide with VBA from Access Tag: 386517
  - 3
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386516
  - 4
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386511
  - 5
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386507
  - 6
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386499
  - 7
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386498
  - 8
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386495
  - 9
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386494
  - 10
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386482
  - 11
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386480
  - 12
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386479
  - 13
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386476
  - 14
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386474
  - 15
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386468
  - 16
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386464
  - 17
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386463
  - 18
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386456
  - 19
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386454
  - 20
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386447
  - 21
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386446
  - 22
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386445
  - 23
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386443
  - 24
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386442
  - 25
    - 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: Create a Print Button on Slide with VBA from Access Tag: 386441

Hi,

I have some VBA in an Access 2003 database that produces a slide and displays
data from a table in a presentation. It is working well.

I have been asked if it is possible to put a print button on the last slide
and when clicked, all the slides would be printed.

I have the code below that puts a custom action button onto my last slide. I
don't know how to get it to print when the button is clicked. I understand
that "Print" refers to a macro that would be in the PowerPoint VBA but this
VBA is running from Access, creating the presentation on the fly.

So how can I get that button to print the slides in the presentation
currently being displayed?

Many thanks
Anthony

My code:
**********

Set PrintButton = EndSlide.Shapes.AddShape(125, 340, 400, 30, 15)

EndSlide.Shapes.PrintButton.ActionSettings(ppMouseClick).Action =
ppActionRunMacro
EndSlide.Shapes.PrintButton.ActionSettings(ppMouseClick).Run =
"Print"

Is this the correct code below to print all the slides?
***********************************************************

PPPres.PrintOptions.OutputType = 1
PPPres.PrintOut

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/powerpoint/200805/1

Top