Search:

How can I insert a video in PPT such that I can send the file to someone else and they can view it? It seems all my attempts only work if run from my local computer. I can embed Flash .swf and send...

I have a spreadshee with about 3200 rows (and cols A-AJ - not all populated). I need to search for all records that match a given pattern and copy data from one cell to another. The gotcha is that...

Nice job, thank you. I ended up making two changes:

1. rearrange the currencies to match the drop down list (two were off)
2. changing column G to be =1/rate instead of 'rate' otherwise it wasn't...

I have a spreadsheet which I can convert from USD to other currencies with user-entered rate, however I need to take it to the next step and let user select any to any (with them entering the...

Try this instruction:

AppActivate "Microsoft PowerPoint"

If PowerPoint is running and visible, this will bring it to the front. (It looks for a window whose title starts with "Microsoft...

I have an Excel application that creates 12 PPT slides and pastes data from Excel. I want to force PowerPoint to always be the active application (in the topmost window), however I find it works...

Ok yes, that makes sense ... I think http://windowssecrets.com/forums/images/smilies/smile.gif I read up on late binding and now got it working. Yeh!! I did this:


Dim objPPT as Object

Set...

I must be doing it wrong because it's not working. I removed the reference to PowerPoint 11. Here's the code with changes commented out. I had a reference to Shapes but commented it out - I still...

I have an Excel workbook which writes data to PowerPoint. I need it to work for both Office 2003 and Office 2007. In the VBA references I added MS PowerPoint 11.0 Object Library and it works for me...

I've used PowerMarks for years and it's ideal for how I want to manage bookmarks. Unfortunately it doesn't work well cross browser and support has stopped. I've looked at over 30 bookmark manager...

Application.TemplatesPath is Excel VBA - you're doing this from Excel, aren't you?

All Office applications share the same user templates path and workgroup templates path, so the path you get from...

You could use Application.TemplatesPath & "\blank.pot"

Application.TemplatesPath is the path to the user templates.

I can't find TemplatesPath in the PP object library. I also looked on the...

You could use

objPres.ApplyTemplate FileName:="...\blank.pot"

where ... is the full path to the default template.

Ok thanks that makes sense, I'll try it. Since this Excel workbook will be...

Try these lines immediately below On Error GoTo ErrHandler:

objPPT.Visible = True
Set objPres = objPPT.Presentations.Add(WithWindow:=True)


I spoke a bit too soon. It does all work great with...

http://windowssecrets.com/forums/images/smilies/biggrin.gif Happy happy. Wow, that worked! I have no idea why though. I don't quite understand all the GetObject, CreateObject,...

I think you can omit this line of code:

Application.ActivateMicrosoftApp (xlMicrosoftPowerPoint)

I removed that line and it generates an error even earlier. It says "Application (unknown...

From the help with code I found here in the Lounge, I was able to create a subroutine which copies a data table from 12 worksheets to 12 new slides in a PPT file. I open a new PPT and add 12 new...

Excellent work to everyone who replied. There is no way I could ever of figured this one out. Great job.

<img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> <img src=/S/bow.gif...

I need to create a list of items selected from a table of data. An item is selected if its quantity > 0. The selected items are used to populate another element however I need it to not include...

Excellent works like a charm - of course. I always struggle with Offset. At first I didn't include the worksheet name in the defined name, I didn't remember having to do that before.

// Thnx,...

I want to use a single chart (bar or line) to dynamically display 1 set of data from a table. The user selects the # of years (1-5) they want to view and the chart should only display those columns...

Ahhhh, I didn't even notice that (obviously). I added the counts and it works ... of course.

Thanks, Deb <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

This is perfect! I tested it and for some reason 3 of the categories don't display anything. I thought there were invalid characters so I rewrote those 3 categories. I marked the 3 in the attached...

I have a list of course categorires where each category has 1 to 30+ courses. I'd created a drop down list for the categories but now need a listbox (from Forms) to auto-populate with the courses for...

Sorry for taking so long to get back to you on your solution. YES, it was exactly what we needed and worked great. It proved to us that the set up the customer was using was incorrect. It saved us...