Best Method for distributing custom Macros/Code

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

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

Reply | Quote

Perhaps Jan Karel, as an Excel MVP, can comment on that. I don’t have Excel 2007.

Reply | Quote