Search:

Type: Posts; User: jujuraf; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    1,863

    Insert video in PPT without local storage

    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...
  2. Replies
    1
    Views
    383

    I have a spreadshee with about 3200 rows (and...

    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...
  3. Replies
    2
    Views
    344

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

    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...
  4. Replies
    2
    Views
    344

    I have a spreadsheet which I can convert from USD...

    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...
  5. Try this instruction: AppActivate "Microsoft...

    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...
  6. I have an Excel application that creates 12 PPT...

    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...
  7. Replies
    5
    Views
    2,540

    Ok yes, that makes sense ... I think...

    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...
  8. Replies
    5
    Views
    2,540

    I must be doing it wrong because it's not...

    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...
  9. Replies
    5
    Views
    2,540

    I have an Excel workbook which writes data to...

    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...
  10. Replies
    4
    Views
    560

    I've used PowerMarks...

    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...
  11. Replies
    11
    Views
    1,954

    Application.TemplatesPath is Excel VBA - you're...

    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...
  12. Replies
    11
    Views
    1,954

    You could use Application.TemplatesPath &...

    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...
  13. Replies
    11
    Views
    1,954

    You could use objPres.ApplyTemplate...

    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...
  14. Replies
    11
    Views
    1,954

    Try these lines immediately below On Error GoTo...

    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...
  15. Replies
    11
    Views
    1,954

    http://windowssecrets.com/forums/images/smilies/bi...

    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,...
  16. Replies
    11
    Views
    1,954

    I think you can omit this line of code: ...

    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...
  17. Replies
    11
    Views
    1,954

    From the help with code I found here in the...

    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...
  18. Replies
    4
    Views
    2,197

    Re: Dynamic list with no spaces (Excel 2003)

    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...
  19. Replies
    4
    Views
    2,197

    Dynamic list with no spaces (Excel 2003)

    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...
  20. Replies
    12
    Views
    2,187

    Re: Offset formula for chart (Excel 2003)

    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,...
  21. Replies
    12
    Views
    2,187

    Offset formula for chart (Excel 2003)

    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...
  22. Re: Offset formula to choose table data (Excel 200

    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>
  23. Re: Offset formula to choose table data (Excel 200

    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...
  24. Offset formula to choose table data (Excel 2003/SP2)

    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...
  25. Replies
    18
    Views
    2,358

    Re: transpose list with offset (Excel 2003)

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4