• Office VBA Macros You Can Use Today

    by
    Ken Puls
    Rate this article
    Published on 2006-01-02 08:15 AM      Number of Views: 1510  
    0 Comments Comments



    Quote Originally Posted by MrExcel.com
    You might be comfortable writing code for Excel in VBA. You realize how cool VBA is for Excel and you wonder, "is it possible to automate the creation of PowerPoint slides?" I will admit that once I step outside of the realm of Excel VBA, I am completely lost trying to automate Word or PowerPoint or Outlook. I am sure that it can be done, but I am not the guy to do it.

    The idea behind this book is to gather together five VBA experts - one from each core Office component. These co-authors contributed their favorite VBA macros that would be useful to a wide range of Office users.
    My contributions to the book Office VBA: Macros You Can Use Today, include helping with writing the instructions for using macros, and proofreading.

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo

  • Recent Forum Posts

    Murray_Sparkles

    VLOOKUP Formula help!



    Here is a semi-updated version with some more details on the recall sheet and how I would *Like* it to work.

    Thank you again...

    Murray_Sparkles Today, 01:02 AM Go to last post
    Murray_Sparkles

    VLOOKUP Formula help!

    Thanks Ali, I will try to come up with a small mock-up to help clear things up. I apologize for any confusion! I am very new to Excel, really only using...

    Murray_Sparkles Today, 12:47 AM Go to last post
    navic

    Conditionnal Formating

    Select all Date cells in 'I' column. Apply CF and formulas

    - Yellow

    Code:
    =OR(TODAY()-$I2=1;TODAY()-$I2=2;TODAY()-$I2=3)
    - Green...

    navic Yesterday, 08:39 PM Go to last post
    Jlamarre

    Conditionnal Formating

    The only date that should be taken in consideration is the "I" column. All other dates should not be taken in consideration.

    In...

    Jlamarre Yesterday, 07:21 PM Go to last post
    navic

    Conditionnal Formating

    It's still confusing.
    If I understood you well the Subtraction between two dates in the example is the next

    - Red
    Today Date...

    navic Yesterday, 06:31 PM Go to last post
Gravatar by 1e2.it