Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    Thumbs up

    Excel Version: 2007

    Question: What is the best/easiest method to distribute custom macros and or VBA Code for use in Excel to our users for version 2007 of Excel?

    Details:
    Within our company we have a god number of accoutants using Excel for financial reporting that need what I call custom helper functions to perfrom cleanup like work on workbooks/sheets prodcued by the 3rd party accounting software we use. For example when they get an Excel based report from this 3rd party app they can't add some aggreate functions like SUM() because all of the cells with values are padded (ususally to the left but sometimes to the right) with the non-visible character that haws the ASCII value of 160.

    I have a simple custom function that when run will strip out all of these in the active worksheet and would like to provide our accountants with this same function but I', not sure as to which method for doing thsi would be best and especially easiest to not only distribute this one but to also add future custom functions that may be updates to this function or completely new functions.

    Thoughts?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd create an add-in and make it available on the network. See Jan Karel Pieterse's series of articles starting at Create Addins.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='771604' date='21-Apr-2009 19:25']I'd create an add-in and make it available on the network. See Jan Karel Pieterse's series of articles starting at Create Addins.[/quote]


    Yeah I thought about the Add-In route but it seems like Excel 2007 is so locked down that using Add-Ins is now a lot more involved/complicated

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Perhaps Jan Karel, as an Excel MVP, can comment on that. I don't have Excel 2007.

Posting Permissions

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