Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 27 of 27

Thread: Solved: Very helpful piece of code

  1. #21
    VBAX Regular
    Joined
    Nov 2005
    Posts
    82
    Location
    And I thought it was just me who had a warped sense of humour.

  2. #22
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hmm, that would be interesting. An add-in sounds wonderful. Perhaps different configurations one can pick from, much like the AutoFormat feature of Excel? Now THAT would be something of a prize gem indeed!

  3. #23
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Hello everyone,

    I've attached an updated version here (1.02) for anyone to play with if they like. I'll get to Zack's "predefined configuations" later, but for now, the new version includes the following changes:

    -Added support for Access & Visio
    -Creates an instance of the application if one is not already present

    Now... don't expect it to install Visio for you if you don't have it, though! Future version will check what apps you have installed, and will only let you configure those.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  4. #24
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Hey guys,

    I found out that someone liked this so much they blogged it! LOL!

    http://cat14051.mysinablog.com/index...rticleId=66003

    Hi Emily!
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  5. #25
    Dude, your famous!

    Quote Originally Posted by kpuls
    I found out that someone liked this so much they blogged it! LOL!

  6. #26
    VBAX Contributor
    Joined
    Oct 2004
    Posts
    159
    Location
    Quote Originally Posted by kpuls
    Hey guys,

    I found out that someone liked this so much they blogged it! LOL!

    http://cat14051.mysinablog.com/index...rticleId=66003

    Hi Emily!
    Hi
    Sorry, reproduce the code without your permission.

  7. #27
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    No worries, Emily. It was a public post. I'm glad you liked it, and I only wish I could read the comments on your site.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •