Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    inacreditável & obrigado!

    Worf, you are a master of your craft. I can't thank you enough for your time and efforts. The macro is a work of art and works beautifully. I'll try to not contact...
  2. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - Thank you for working on this (again) and adding slide numbers. It did add slide numbers but I would like to ask for a couple of modifications in terms of placement and format.

    1. Right...
  3. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf - Just retagging this in case you did not get notification. I know its happened in the past with you and me as well. Thanks.
  4. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf - I did think of one thing as I was testing the code. Can you add code at the end which adds slide numbers to each slide? Right now after the code runs I manually go into "Insert/Slide...
  5. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi - I added in the tabs from the old file and the new file seems to be working without errors. THANK YOU again for your time and efforts to get this project completed. I'll be in touch in a...
  6. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf - I did as you suggested and created a brand new Excel WB and pasted in the current code. Initially I was getting a run time error message (Shapes.PasteSpecial: Invalid Request. The...
  7. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Okay. I will set up a new file on Monday and report the results. What's weird is the code prior to the title tab being added seemed to work fine. I would get an occasional hiccup but for the most...
  8. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - I think I am okay with leaving the code as is although I'm getting another (different) error when I try the new code in my master file. I will send you an email now with my master Excel file...
  9. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - I bow down to your Excel greatness. Very nice! As you predicted it worked once I added the text in those cells. Last question. If I end up having 10 slides do I just keep typing down? ...
  10. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf - I tried the new code and I am getting an Excel error message that reads: "Object library invalid or contains references to object definitions that could not be found". I noticed that my...
  11. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Thanks Worf! I'm glad you responded ... I thought maybe you saw my post and went running & screaming! Ha Ha. I'll try this out today and let you know how it works. I've been using the code...
  12. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - Quick question. Is there a way to link my title and subtitle text to cells in Excel instead of typing them out in VBA? The problem I am running into is some of my subtitles are really long...
  13. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - You did it!!! Awesome job! The resulting PP looks great now and no extra mag boxes. I'm not sure how you did it but a BIG thanks. What I'd like to do before I leave you alone is test...
  14. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf -

    Okay, slightly different results. The cover slide and data slides 3-7 are all still perfect, but Slide 2 (first data slide) is still a bit weird.

    1. There are now "Title" and...
  15. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Hi Worf - I tried the new code and still the same problem. Cover slide (slide 1) looks great. Data slides (slides 3-7) all look great. That first data slide (slide 2 in the deck) is still not...
  16. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf -

    I took another look at that first data slide and have an update. The "Title1" box is positioned correctly but it's coming in with 20 font and italics. There is a bold "2" sitting above...
  17. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf -

    Oh so close! All of the data slides look GREAT except that first data slide (first slide after the cover page).

    Here is what I am seeing on that first data slide:

    1. The title...
  18. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Welcome back! Okay I ran the new code and on my end the results are still mixed. The second slide (first data slide) still has a slide number but now it has it for both title and subtitle boxes. ...
  19. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Okay I ran the code from 57 ... here you go

    Layout 1
    "Title Slide" Shapes = Title 1
    "Title Slide" Shapes = Subtitle 2

    Layout 2
    "Title and Text" Shapes = Title 1
    "Title and Text" Shapes =...
  20. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - Sorry for the late response. I did not receive my usual email indicating a reply to the post. I actually logged on because I thought maybe you abandoned me! Glad to see you did not and that...
  21. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Okay Worf. I spent some time working with the code and it works great! Below is a final list of "things to fix". I've pasted my current code so you can work off of the latest version ... I...
  22. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - Disregard that last post ... I figured out the issue. I was missing the DIM code in the very beginning ... once I added that the code ran all the way through. I see the title and subtitle...
  23. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Worf - I tried the code and it stops at the code in RED below. That is the same line that trips me up every once in a while ... not sure why. I was playing around with the .potx template yesterday...
  24. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Okay Worf ... here are the results of the code in thread #44. A number appears at the top of each message box which I've detailed below:

    #1 = Title Slide
    #2 = 1_Title Slide
    #3 = Title and...
  25. Re: Macro to open Powerpoint and paste ranges from Excel - Troubleshoot error in code

    Ok. Will run first thing in the AM.
Results 1 to 25 of 56
Page 1 of 3 1 2 3