Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 (Imperial to Metric Conversion)

    Hi,

    I have seen in some word documents that vba can be used to have an additional tool bar can be used to convert imperial measurments to metric measurements and vice versa. Does anyone know how this is added to a word document? I am familiar with access and vba but not word and vba.

    Any help would be much appreciated
    Best Regards,

    Luke

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2000 (Imperial to Metric Conversion)

    I have a conceptual problem with doing unit conversions within Word. Namely, why?

    Wouldn't you do this with a calculator or even Excel, and paste the results into your Word document?
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (Imperial to Metric Conversion)

    John,

    We are an estate agents and at present only list room measurements in imperial measurements. However to make it easy for everyone concerned it would be good to press the button, it asks you for the feet, which you enter, then asks you for the inches, which you enter. It will then format it correctly together with the metric conversion.

    This way shuld be less prone to errors, as long as the code was correct.
    Best Regards,

    Luke

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2000 (Imperial to Metric Conversion)

    Ah - I thought there would probably be a good reason! Possibly Hans knows of such a toolbar?
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  5. #5
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (Imperial to Metric Conversion)

    Yes, Unfortunately our organisation is more prone to human error (can't think why?) [img]/forums/images/smilies/smile.gif[/img]
    Best Regards,

    Luke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 (Imperial to Metric Conversion)

    If you search Google for word toolbar conversion imperial metric you'll find lost of utilities - from freeware to commercial - but most appear to be standalone programs. I found one that adds a toolbar to Excel: XL Convert, but not for Word. But perhaps you'll find one if you search diligently.

  7. #7
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (Imperial to Metric Conversion)

    The word file attached seems to have it, but not familiar with vba and word and how to apply it to a new fresh document or template.
    Attached Files Attached Files
    Best Regards,

    Luke

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 (Imperial to Metric Conversion)

    Open measure.dot or a document based on it.
    Select Tools | Templates and Add-Ins...
    Click the Organizer... button.
    Activate the Toolbars tab.
    Select measure.dot in the dropdown list on the left.
    Select Styles in the list of toolbars.
    Click the Copy >> button to copy the toolbar to your Normal.dot template.
    Activate the Macros tab.
    Select measure.dot in the dropdown list on the left.
    Select NewMacros in the list of modules.
    Click the Copy >> button to copy the module to your Normal.dot template.
    Click Close.
    The toolbar and associated macros will now be available in all documents.

  9. #9
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (Imperial to Metric Conversion)

    Thanks for that.
    Best Regards,

    Luke

Posting Permissions

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