Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

March 2008 - Nick Hodge's Excel Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Playing with OpenAsTextStream

    We produce individual text files for new items to go into our catalogue. These are sent to the creative people for laying out on the page. One file contains the Item#, Description, Text and Bullets for one item and is named with that item's number. Of course, for page layout it is good for them to copy and paste the text this way. It looks as below: 12345E 2500PSI 15LPM Petrol-Powered Pressure Washer This pressure washer, powered by a Honda GX160 engine, will blast away even the most stubborn...

  • Questions on customising the ribbon

    I have, via the blog contact form received three questions from Milan, these were Can you remove the Office Button? Can you link a combobox (on the ribbon) to a cell/range? Can you link a label (on the ribbon) to a cell? The answer to No.1 was answered in the 2nd of my series on customising the ribbon. In the section under Full Dictator Application. No. 2 is yes you very much can but it is not a simple process like having a 'link' property or similar. The write-up below demonstrates how you...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.