.xlam

Good morning, I have several tools working with which include sometimes the same Subs . So everytime I found an effort on one Sub and change it in one workbook I repeat this in the other workbooks. Wasting time - isn’t it? I want to have one workbook with all Subs inside, soft coded. So they...

I have a .xlam file that will likely be updated to newer versions. I would like to include a version number in the name of the add-in such that someone browsing either the list of add-ins ("Developer->Add-Ins") or list of references ("Visual Basic"->"Tools"->"References") will see the version...

Hello, my company is finally moving from office 2010 to 2016...can someone please let me know how to handle the upgrading when it comes to all the codes residing in different workbooks including personal.xlsb and .xlam? Do I need to export everything then import them again or they will just work...

Hi all. I have an .xlam file that is password protected for viewing. At times the .xlam accepts user inputs and saves itself to archive the inputs. (This is accomplished with simple thisworkbook.save statements in applicable code, as well as a redundant worksheet_save private function for the...

Hi all. I have an .xlam file that is password protected for viewing. At times the .xlam accepts user inputs and saves itself to archive the inputs. (This is accomplished with simple thisworkbook.save statements in applicable code, as well as a redundant worksheet_save private function for the...

Hello, I'm trying to run an XLAM file from a macro. Using the run method I get the following error Run-time error '1004': Cannot run the macro (filepath) The macro may not be available in this macro or all macros may be disabled. I'm quite familiar with VBA, but am just starting with .xlam...

Hello fellow Excel users, I recently upgraded from Excel 2003 to Excel 2010. I have an add-in that I built in 2003 and backed up before my Excel upgrade, and I am wondering how to bring it in to Excel 2010. It is an .xla file that adds an item to the now drastically re-arranged Options...