天道酬勤,学无止境

powerpoint

Connect to SQL Server from Powerpoint

How can I connect to a SQL DB from Powerpoint (be it 2007 or 2010) to generate reports? I've seen quite a few forums and most of them talk about using external tools. Check http://www.officekb.com/Uwe/Forum.aspx/powerpoint/34863/Linking-PowerPoint-to-a-database http://www.ljzsoft.com/pptreport/help/ppt-report-help.htm Isnt there any out of the box solution for this? P.S. I've also posted this at the MSDN Forum. Didnt get any replies hence posting it here

2022-01-18 12:48:23    分类:问答    sql-server   vba   powerpoint

Data linking between Excel data and Visio/PPt

Question: How can we link data from excel sheets to ppt diagrams / visio diagrams ? Diagrams here are data flow diagrams depicting data trasfer between different applications. I am aware that the excel data needs to be formatted but not sure how to go about it and could not find helpful links online. Any light on this would be very helpful. Thank you.

2022-01-18 06:48:02    分类:问答    excel   powerpoint   visio

Handling key events on WebBrowser control?

Currently I am using an application which play ppt and flash in WebBrowser Control. In WebBrowser I am able to hide context menu by using this.IsWebBrowserContextMenuEnabled = false; and capture key event by using this.PreviewKeyDown += new PreviewKeyDownEventHandler(IWebBrowser_PreviewKeyDown); but while playing the ppt, both context menu and keypress events are not functioning i.e. I can see context menu and arrow key force the ppt to change the slide. Again while playing flash, context menu is visible and I can handle key event. is there any other setting to it can same for whatever (HTML

2022-01-18 06:42:41    分类:问答    c#   flash   webbrowser-control   powerpoint

Convert PowerPoint 2007/2010 file formats to svg using pptx4j in Java

In my Java project I am working on PowerPoint 2007/2010 file format so I am Using pptx4j open source project. However, I don't know how to convert PowerPoint 2007/2010 file formats to an SVG file. Can anybody help me?

2022-01-17 23:01:38    分类:问答    java   svg   powerpoint

How to automatically trigger the App Object initialization in Powerpoint?

It is said here: http://msdn.microsoft.com/en-us/library/aa211599%28v=office.11%29.aspx Before the procedure will run, you must connect the declared object in the class module (App in this example) with the Application object. You can do this with the following code from any module. Dim X As New EventClassModule Sub InitializeApp() Set X.App = Application End Sub Run the InitializeApp procedure. Run HOW ? By hand ? I want it to automatically run when opening the powerpoint rather. Is there any way ?

2022-01-17 16:51:26    分类:问答    vba   powerpoint

PowerPoint VBA - Paste Special (Enhanced Metafile) bug

I am using a macro in PowerPoint 2003 SP3 to find a specified chart in an Excel workbook, copy it, and then paste it into the current slide as an Enhanced Metafile with, ultimately, the following line of code: Application.ActiveWindow.View.PasteSpecial DataType:=ppPasteEnhancedMetafile As often as it works, I also receive the following error: Run-time error '-2147188160 (80048240)': View (unknown member) : Invalid request. The specified data type is unavailable. If I end the macro and attempt to manually Paste Special as Enhanced Metafile, I have no problem, so it's not as though the clipboard

2022-01-17 04:09:36    分类:问答    vba   powerpoint

How to convert a PowerPoint slide into HTML?

I am trying to insert PowerPoint slides into HTML preserving links in the PowerPoint slide. I was just wondering if any of you knew a good method to maybe exporting a PowerPoint slide to an HTML and then displaying it in a div on your page, with a link to say do a JavaScript function on that same page.

2022-01-17 03:22:39    分类:问答    javascript   html   powerpoint

如何在 VBA 中实现消失的动画?(How to implement disappearing animations in VBA?)

问题 我正在尝试在 VBA 过程中测试形状上的效果动画。 我已经实现了在MainSequence添加一些新动画,定义时间轴中的哪个位置......但我无法创建消失的动画。 我检查了一些已经存在的代码的开头......并且 EffectType 似乎返回与相关出现动画相同的值,所以我很遗憾地认为没有办法在 VBA 中创建消失的动画。 请告诉我我错了,我必须在 300 多张幻灯片上做同样的创作...... 回答1 是的,你错了,但是文档是......好吧,我想你已经知道了。 这是诀窍。 要添加消失动画,您必须添加出现动画,但将其“退出”属性设置为“msoTrue” 看一下这个代码示例: Private Sub SetAnimation() Dim effNewEffect As Effect With ActiveWindow.View.Slide Set effNewEffect = .TimeLine.MainSequence.AddEffect(.Shapes(.Shapes.Count), msoAnimEffectAppear, trigger:=msoAnimTriggerWithPrevious, Index:=-1) End With effNewEffect.Timing.TriggerDelayTime = 1.0 effNewEffect.Exit =

2022-01-16 19:19:06    分类:技术分享    vba   powerpoint

How to implement disappearing animations in VBA?

I'm trying to test effect animations on shapes in a VBA procedure. I've already achieved one which is adding some new animations in the MainSequence, defining in which position in the Timeline... but I am not able to create disapearing animations. I checked in the beginning of the code some already there...and the EffectType seems to return the same value as related appearing animation, so that I sadly believe there's no way of creating disapearing animations in VBA. Please tell me I am wrong, I have to do the same creations on over 300 slides...

2022-01-16 18:13:27    分类:问答    vba   powerpoint

C# 中的 PowerPoint 笔记(PowerPoint Notes in C#)

问题 我想阅读 C# 中 PowerPoint 幻灯片的注释。 以下片段对我有用。 slide.NotesPage.Shapes[2].TextFrame.TextRange.Text 但是,这不适用于某些演示文稿。 然后它抛出一个“超出范围”异常。 索引2的含义是什么? 有没有其他方法可以做到这一点? 回答1 您不能假定注释文本占位符将位于任何特定索引处,甚至不能假定它具有特定名称。 这是 VBA 中的一个简单函数,它返回幻灯片的注释文本占位符: Function NotesTextPlaceholder(oSl As Slide) As Shape Dim osh As Shape For Each osh In oSl.NotesPage.Shapes If osh.Type = msoPlaceholder Then If osh.PlaceholderFormat.Type = ppPlaceholderBody Then ' we found it Set NotesTextPlaceholder = osh Exit Function End If End If Next 结束功能 回答2 这意味着您正在尝试访问slide.NotesPage.Shapes集合的第三个元素。 如果集合有 2 个或更少的元素,则会引发异常,因为指定索引2处的元素不存在,因此无法访问 -

2022-01-16 18:06:31    分类:技术分享    c#   powerpoint