How do I Copy Excel Macros from One PC to Another

[mikeb7500]

I developed a Pop-Up Calendar. The add-in works in the original Excel Spreadsheet file on the originating PC. Although I've tried to save it as both a macro enabled worksheet and macro enabled workbook, the spreadsheet copies to the second PC, but the add-in doesn't...and also doesn't even show up on the list of macros. I am loading the file on a thumb drive, then onto the second computer. What is the procedure to save and copy Add-ins? Also I developed the Calendar Add-in on Windows 8.1, and would like it to work on any PC with any operating system which I choose to load it on (currently trying to load it on a second PC with XP)...please help. Thanks

 

[Fishboy]

Hi MikeB7500,

What versions of Excel and Windows are on both machines? I had a similar problem where the Microsoft Date and Time Picker Control 6.0 was not installed on a specific PC and my popup calendar would not work on that one machine. I ended up having to download MSCOMCT2.cab and install it on that PC to get everything working again.

 

[mikeb7500]

Hi Fishboy,

Developed in Excel 2013 and Windows 8.1

Tried loading it on Excel 2007 and Windows XP

and also tried loading it on Excel 2010 and Windows 7 with no luck

 

[Fishboy]

Hi Fishboy,

Developed in Excel 2013 and Windows 8.1

Tried loading it on Excel 2007 and Windows XP

and also tried loading it on Excel 2010 and Windows 7 with no luck

Hmm, out of interest can you try creating a new popup calendar on one of the machines affected? I am fairly sure you will find the key plugin required for it is missing from those PCs (I don't think it comes as standard any more) If I am correct, I suspect the Microsoft Date and Time Picker Control 6.0 will not be there.

Can you test this out and lest us know how you get on?