Opening Excel Files from Powerpoint 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
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386445
  - 2
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386443
  - 3
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386442
  - 4
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386441
  - 5
    - save Powerpoint on DVD for TV viewing Is there a way to save a Powerpoint on a DVD for TV viewing? -- jrs Tag: Opening Excel Files from Powerpoint VBA Tag: 386439
  - 6
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386438
  - 7
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386432
  - 8
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386424
  - 9
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386421
  - 10
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386418
  - 11
    - NG test *test* does this get through again? (sorry) Tag: Opening Excel Files from Powerpoint VBA Tag: 386416
  - 12
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386414
  - 13
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386411
  - 14
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386410
  - 15
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386402
  - 16
    - 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: Opening Excel Files from Powerpoint VBA Tag: 386401
  - 17
    - search & replace carriage returns Hi, Sorry if this has been asked recently or is obvious. I did not find the answer in the FAQ. 1. Is it possible to change settings so that hidden characters (carriage returns, tabs, spaces etc.) are shown, e.g. like in MSWord? 2. Is it possible to search for such characters without using VBA? I´m using MSPowerpoint 2003. TIA Örjan Tag: Opening Excel Files from Powerpoint VBA Tag: 386400
  - 18
    - Change font size and colour in footer through VBA Hi, I am using the code below to transfer data from an Access 2003 table to be displayed in PowerPoint. Currently, it displays a footer, along with the date and slide number. How do I go about adjusting the font size and colour of the text in the footer? (Sorry about the line breaks) Thanks, Anthony My Code here: *********** Dim PPApp As Object 'late binding Dim PPPres As Object Dim PPSlide As Object Dim db As Database, rs As Recordset Dim strSql As String Set PPApp = GetObject(, "PowerPoint.Application") If PPApp Is Nothing Then 'no existing application is running Set PPApp = CreateObject("PowerPoint.Application") End If If PPApp Is Nothing Then 'not able to create the application MsgBox "The application is not available!", vbExclamation+vbOKOnly,"Help." End If 'Open up a recordset on the employee table. Set db = CurrentDb strSql = "SELECT * From [Employee] WHERE (Status = True);" Set rs = db.OpenRecordset(strSql) Set PPPres = PPApp.Presentations.Add With PPApp While Not rs.EOF With PPPres.Slides Set PPSlide = .Add(rs.AbsolutePosition + 1, 2) PPSlide.HeadersFooters.Footer.Visible = True PPSlide.HeadersFooters.Footer.Text = "My Footer Text Here." PPSlide.HeadersFooters.DateAndTime.Visible = True PPSlide.HeadersFooters.DateAndTime.UseFormat = True PPSlide.HeadersFooters.DateAndTime.Format = 1 PPSlide.HeadersFooters.SlideNumber.Visible = True PPSlide.Shapes(1).TextFrame.TextRange.Text = UCase(CStr(rs.Fields("EmployeeID").value)) PPSlide.Shapes(2).TextFrame.TextRange.Text = "Name = " & CStr(rs.Fields("FirstName").value) & vbCrLf & _ "Surname = " & CStr(rs.Fields("Surname").value)& vbCrLf & _ "Phone = " & CStr(rs.Fields("Phone").value) & vbCrLf & _ "Level = " & CStr(rs.Fields("Level").value) PPSlide.Shapes(1).TextFrame.TextRange.Characters.Font.Size = 30 PPSlide.Shapes(2).TextFrame.TextRange.Characters.Font.Size = 26 PPSlide.Shapes(2).TextFrame.TextRange.Characters.Font.Color = vbBlue End With rs.MoveNext Wend End With PPPres.SlideShowSettings.Run Set PPApp = Nothing Set PPSlide = Nothing Set PPPres = Nothing End If End If Tag: Opening Excel Files from Powerpoint VBA Tag: 386399
  - 19
    - Screen Tips only show for a second, PowerPoint 2007 When I rest my mouse pointer over something on the ribbon the screen tips either show up for just a second or not at all. I did check and they are enabled. How can I get them to show up for more than just a second. They did before I don't know why they stopped. Tag: Opening Excel Files from Powerpoint VBA Tag: 386395
  - 20
    - PPT 2007 - 3-D Cube Hi, I would like to draw a 3-D cube, with 3 surfaces and each surface represent respective segments of product types, geographical share and brand names. Within each surface (segment), the proportion of product types, geographical share and brand names may vary, hence I like to use different colors to represent them. Can I create a SmartArt object for this ? and if so, how ? Thanks very much. EK Tag: Opening Excel Files from Powerpoint VBA Tag: 386391
  - 21
    - PPT Online and VISTA I've posted this before, but can't find the posting or similar questions. We've had a PPT 2003 presentation on our website for several years. On XP computers, the presentation automatically opens and plays in full-screen mode when the link is accessed. On VISTA computers, the PPT opens in the create/edit mode requiring manual starting. Anyone have any comments or ideas about this? Thanks. Tag: Opening Excel Files from Powerpoint VBA Tag: 386385
  - 22
    - Power Point Slide show not working correctly I recently sent a copy of a Power Point slide show, that I had received, to both my daughters. Both of them are using Windows XP and Office 2007. On one computer the show runs correctly (as it does on my Windows XP and Office 2003) but on the other it does not show text in a box which "fades in". What could be causing this? I have opened the file and saved it as html in order to see what types of files are within the slide show and there are no swf files which I thought may be causing the problem. The files within are htm, css, jpg, gif, js, wmf, wav and xml. Where to now? Tag: Opening Excel Files from Powerpoint VBA Tag: 386383
  - 23
    - Slide masters in PP 2007 I have created a new 'Text Only' slide master in a presentation. However, for some reason I now have 22 instances of the 'Title & Content' Master, and cannot delete them. Each time I use the custom master, it seems to generate a copy of the Title master. I do not seem to be able to delete any masters. Any suggestions? Thanks Tag: Opening Excel Files from Powerpoint VBA Tag: 386377
  - 24
    - Bullit points Hi, A number of bullit point that were created with Office 2000 or 2003 now show up as letters in Office 2007. Any idea why that could be happening? It shows up and a sqare empty box or letter N Tag: Opening Excel Files from Powerpoint VBA Tag: 386375
  - 25
    - embedding .swf files in PowerPoint 2007 I am trying to embed a .swf file into a PowerPoint 2007 presentation so that the .pptx file can be moved and copied and opened anywhere and the animation still work, without having to also move the .swf file. I found a tutorial that seems to be able to do this in Office 2003 (http://www.flashgeek.com/tutorials/02_embed_09.asp), however this does not work for 2007. I know how to get a .swf file into a presentation and linked, but this requires that the .swf file be moved with the .pptx file. I cannot figure out how to get it actually embedded so that only the .pptx file has to be moved. I am also not interested in the "package for CD" option. It seems to me that this is one area where PowerPoint could use significant improvement - I have the same trouble with movie files and sound files. Embedding these things into a presentation file should be easy to do. Tag: Opening Excel Files from Powerpoint VBA Tag: 386371
- Next
  - 1
    - ALINA Tag: Opening Excel Files from Powerpoint VBA Tag: 386370
  - 2
    - how to creat a loop on power point presentation I am trying to make presentation with powerpoint in such a way that works in a loop so that each slide changes byitself Tag: Opening Excel Files from Powerpoint VBA Tag: 386369
  - 3
    - Why will only 2 slides in my 5-slide show appear? the title says it all. please help me! Tag: Opening Excel Files from Powerpoint VBA Tag: 386366
  - 4
    - Narration and the mouse Is it possible to record a PowerPoint presentation using "Recor Narration" and have PowerPoint record the mouse movement on the scree too. I am trying to put together a presentation that explains the feature of a new software program and I want to click through the screen shot in an effort to make it look like the screen shots are the actua program in action. I know that I could record the presentation using Camtasia but I fin that the video quality of the Camtaisia playback file is a lo resolution and I need this presentation to sizzle. thank you as always, denn -- dslocum Tag: Opening Excel Files from Powerpoint VBA Tag: 386361
  - 5
    - repeated animation problem When I animate an animation (infinitely), I want to be able to exit the slide with just one mouse click. When I click once, the animation restarts, only after the second click the slide changes. Tag: Opening Excel Files from Powerpoint VBA Tag: 386354
  - 6
    - "X-out" an object after used with hyperlinks Hey everyone, I'm very familiar with hyperlinks and how to create them using Autoshapes. Thing is, I've created a 'game' with a home page that has 20 Rectangle autoshapes, all of which hyperlink to some place new. What I want to do is create the hyperlinks in such a way that when a person clicks on it, and then comes back to this main slide, the autoshape they clicked on is crossed out with X, or made Red, or somethig similar. See, with text, when you click a hyperlink, it changes color. But the autoshapes don't. So can I make an autoshape change in color (or get crossed out) once it's used? Thanks so much! Tag: Opening Excel Files from Powerpoint VBA Tag: 386352
  - 7
    - In Ppt 2000 I get "measurement must be between 0% and 10675%" I receive the above message when trying to modify an org chart in Powerpoint 2000. Any way to fix this? Tag: Opening Excel Files from Powerpoint VBA Tag: 386346
  - 8
    - Adding a macro to the toolbar in Powerpoint 2003 Hi: I followed the steps in www.microsoft.com for "Adding a button, menu or comman to the toolbar, in this case a macro: I went to do the steps as listed - Tools, Commands Tab, Click on Macro and drag to the customize tool bar. It does not work for me. Can you explain if there is a step missing that I'm not doing? -- Cynthia Behnam Tag: Opening Excel Files from Powerpoint VBA Tag: 386343
  - 9
    - Inserting m4a file in PowerPointe Does anyone know how to insert an m4a audio file into Powerpoint? MP3's go in fine, but the newer formats aren't recognized. Is there an update, add-in or some way to convert them to mp3 files. -- Jerry Tag: Opening Excel Files from Powerpoint VBA Tag: 386330
  - 10
    - office/Powerpoint 2007 free 60 day trial I have just successfully downloaded this 60 day trial to my PC running xp. It allows me to open the powerpoint page but when I try to add text or do anything it says I must get a code and buy a full version to continue. I thought a free trial was just that so why is it not allowing me to use it? Any ideas please??! Nicola Tag: Opening Excel Files from Powerpoint VBA Tag: 386324
  - 11
    - In Power Point, how do I have music for the entire slide show? Hi. I am building a PPT presentation and have one sone that I would like to play throughout. I can not figure out how in the world to do this. I assume I am missing something simple, right? Tag: Opening Excel Files from Powerpoint VBA Tag: 386317
  - 12
    - Using Microsoft PowerPoint Object Library 12.0 at ASP.NET applicat Hi, In my ASP.NET application I need to generate powerpoint presentations containg complex shapes and connectors in each slides. At first I tried with Aspose. But due to its limitations I searched for other APIs. And finally I found Microsoft PowerPoint Object Library 12.0 as the most usefull component which have all the functionalities I need. My questions: 1. Is it possible to deploy Microsoft PowerPoint Object Library 12.0 in ASP.NET server where Office is not installed? 2. If so then how? Tag: Opening Excel Files from Powerpoint VBA Tag: 386314
  - 13
    - how i can disable spacebar for slide transition I want to disable slide transition for mouse click, mouse roller button, space bar & keyboard arrow keys Tag: Opening Excel Files from Powerpoint VBA Tag: 386312
  - 14
    - Scrolling up lyrics for my presentation, i want to put scrolling up lyrics and i put lyrics into textbox to add animation. i added the credit to the box and it only go upto 2/3 of it... cna someone help me out? Tag: Opening Excel Files from Powerpoint VBA Tag: 386302
  - 15
    - Power Point What steps do I use to automatically advance Power Point slides? Tag: Opening Excel Files from Powerpoint VBA Tag: 386295
  - 16
    - academic calendar 2008-2009 When will a template for Powerpoint come out with an academic calender for 2008-2009? -- kreitzer Tag: Opening Excel Files from Powerpoint VBA Tag: 386294
  - 17
    - multiple animated gifs I have ppt 2002, and am trying to have multiple animated gifs on the same page (overlapped). Basically, I have each one "appearing" on a mouse click, and then doing it's animation without a loop, then another mouse click to activate the next gif animation on top of the first (I am doing this with 8 gif animations). The weird thing is that the animation doesn't always work. Sometimes as I mouse click the animated gif is already halfway through or other times it is already at it's last image. The animated gif very rarely starts and ends correctly. Tag: Opening Excel Files from Powerpoint VBA Tag: 386293
  - 18
    - PowerPoint 2007 Recoloring pictures In earlier versions of PP it was possible to recolor each component of a picture. Has this facitiy been removed in PP 2007? If not, where do I find it? Thanks Tag: Opening Excel Files from Powerpoint VBA Tag: 386285
  - 19
    - Installing a Design Hi, When I try to download one of the Themes for Powerpoing 2007 from the MIcrosoft webpage they dont install, why?? I use a paidfor student version, I have done the genuine stuff. Mads Tag: Opening Excel Files from Powerpoint VBA Tag: 386282
  - 20
    - playing video on power point 2007 for my presentation, i want to play video from youtube and play it by url adress. so i wouldn't have to download the video. but i dont know how, please help Tag: Opening Excel Files from Powerpoint VBA Tag: 386281
  - 21
    - Forgotten password on a PPT - read only I have a user who set a password on a PPT to open the file "read only" then forgot the password. I'm not that familiar with coding PPT, I'm usually an XL guy; any ideas on how it may be cracked or is he hosed? Tag: Opening Excel Files from Powerpoint VBA Tag: 386280
  - 22
    - How can I save as powerpoint 4.0 using powerpoint 2003 service pac I need to create a document in ppt 4.0, but am using ppt 2003 sp 2. No "save as ppt 4.0" option pops up with "save as" command. Please help. Thanks, Matt Tag: Opening Excel Files from Powerpoint VBA Tag: 386260
  - 23
    - Freeform drawing preview colour in Powerpoint 2007 I use a black background for most of my presentations. In PPT 2003 drawing with the freeform tool would preview in white before the shape was finalised by double clicking. In PPT 2007 the preview is black and hence invisible while drawing the freeform, so I can't see what I am drawing! The results are usually entertaining. I can't find any option to change the contrast colour of the freeform tool (in 2003 it appeared to change automatically so was dark on a light background). Same seems to apply to the scribble and curve tool. I can change the background colour, but this seems unnecessarily clunky. Any suggestions on how to modify this behaviour? Many thanks. Julian Cooper Tag: Opening Excel Files from Powerpoint VBA Tag: 386253
  - 24
    - determining slide number and object/shape number I'm using PPT 2007. I need to verify that I am referencing shapes and slides by their correct number in my vba code. For the slide number, I am looking at the slide number listed in the status bar in normal view of the slideshow. For the shapes, I am looking at the number listed in the custom animation pane for that shape or action button. Is this correct? I think I might be using the wrong numbers in code, because I'm getting a message that says: "Shapes(unknown member): Integer out of range. 15 is not in the valid range of 1 to 13." Tag: Opening Excel Files from Powerpoint VBA Tag: 386244
  - 25
    - placeholder types AND VSTO Using the AddPlaceholder method of the shapes object allows the creation of a placeholder shape on a slide. However, the available placeholder types do not include types that are seen via the InsertPlaceholder in the ribbon. For example, AddPlaceholder does not have a ppPlaceholderClipArt to create a clip art placeholder although a clip art type is available via the ribbon and ppPlaceHolderMixed throws an error. What gives? Tag: Opening Excel Files from Powerpoint VBA Tag: 386242

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

Top

RE: Opening Excel Files from Powerpoint VBA by john

john
Wed May 07 14:56:35 CDT 2008

This site has some good pointers
http://www.peltiertech.com/Excel/XL_PPT.html
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

"Lily" wrote:

> 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

Top