I have a VBA module that takes the contents of a spreadsheet in a specified format, re formats the data and writes the new format to a text file. The VBA module does what it is supposed to, but now i want to send it to someone who is non-technical. I need an easy way to install the functionality either to the Excel app on the other person's computer or an easy way to run the addin on specific spreadsheets. i have the module in a .bas and .xlam format and can make any other format.
Ideally i would put a file in a specific place on the target computer and then be able to run the module by pressing a series of keys, but could live with a navigation to the addin via menus.
What do you all think is the best way?
Ideally i would put a file in a specific place on the target computer and then be able to run the module by pressing a series of keys, but could live with a navigation to the addin via menus.
What do you all think is the best way?
