Here is the BETA version of my Colour Manager, and tool for creating colour pallets in Excel:
It’s a VB6 com addin, the only thing you really need to know is that you load a picture on the left and then click that picture to get the colour at that point. You can then click a pallet square to place it where that square is. Click the send to workbook button to send it to the active workbook.
However I have also made a video to show how to use it. Bosh!
Here is the file!
UPDATED FILE HERE:
MIE Colour Manager Beta 0.3.0.zip
Enjoy, feedback more than welcome.
Hi Ross,
I download your add-in, but I receive an error when the add-in loads…
“Sorry this addin does not support Excel 2007 or above.”
I am using Excel 2003 SP3 (german version).
any idea ?
Best Regards
Hi,
I think I know what this is, a basic programing error (i hope)!
I will try and load an updated file to night. If you could check back tommorow and try the update that would be cool!
Thanks for the feedback,
Ross
Hi,
Please find updated file in post.
Thanks for feedback!
Ross
Hi again Ross,
installed the new version, unfortunately I got the same error.
Regards
Hi,
if you run
[vba]
msgbox application.version
[/vba]
Ross
what does it say?
Cheers
application.version = 11.0
application.build=8237
application.operatingsystem=Windows (32-bit) NT 5.01
Regards and thanks for your support.
IM
hi imzde,
If you send me an email ross at methodsinexcel dot co dot uk, then I can send you a version with out the check in it. not sure when this should be an issue for you, but will try and find out?
Cheers
Ross
Thanks a lot Ross, I installed the “modified” version of the Add-In and now works perfect !
Vielen Dank für deine Unterstützung !
IMZDE
Keine Sorge, genießen!
Ross,
Good looking COM – I’ve downloaded and installed, but not item is available on the Tools menu. Anything I can do to debug? (xl2003)
Tkx,
AlexJ
Hi AlexJ,
Does the addin show in the com addins window – with a check next to it?
What Language version are you using?
Thanks
Ross
Ross
Yes the addin has a check.
I am not familiar with “Language Version” – please elaborate and I will find it.
BTW, macro security has both “Trust all installed addins and templates” and “Trust access to Visual Basic Project” enabled
Hi Alexj,
It is a com addin so macro security does not really effect it. The Language version is the native language that Excel used – for most people reading this blog that will be US or English, but I have had a problem with a German Version – it’s a bit hard to test all of the diffrent version though lol!
What sort of access rights do you have on your PC, and where did you extract the file too?
Thanks
Ross
Ross, languate is US, the dll is located in the standard AddIns directory. My access is user, by the IT guys her are very helpful (who knew!) so I can get help. Any thoughts? Am I looking in the right place for the menu command? Any chance that other addins could conflict? I have tried playing around without sucess.
The addin should add a menu option to the bottom of the tools menu.
Can you try it on another PC at the same place and see it it does not work on another PC for just your PC?
If you could try and install it successfully some where else then we can say for sure that its a problem with your PC, rather than a more general one?
Thanks
Ross
Neat little add-on – I will definitely use this – thanks
Well – tried tje addin on an old xl2002 machine – loaded fine but failed on a driver error – not your problem, Therefore, the original problem is my machine, not your addin. Pity – I was looking forward to using Colour Manager.
Is there any way to invoke the function without the menu item?
>Is there any way to invoke the function without the menu item?
No there are not public methods, but this is a beta, so I could change that!
Some more things to try:
install the addin with admin rights?
register the dll with regsrv then try to install,
remove all other addins and then try, – see if there’s a conflict?
I’m begin to wonder if it’s a guild issue…
Hi
On Windows Vista & Office 2007 I get the following error message:
“Run-time error 13″ Type mismatch.
Any idea on how to get MIE Colour Manager running on this configuration ?
Txs
Hi Bernard,
the addin does not support 2007, but it should give a message that say so. Not sure about the runtime error – thats not good!
Hopefully I will update this at some stage to wortk with 2007 and 2010. I will post when I do, sorry can be more helpful.
Ross
Thanks so much for this, it works perfectly! I had some trouble getting it installed but managed it finally using this cool solution: http://www.vbaexpress.com/kb/getarticle.php?kb_id=447
Thanks Leoni, I’m glad that you got it to work in the end, and sorry that you had to use a thrid party code to do it.
I really need to come back to this and write an installer for it!
Thanks for the feedback
Ross
Hi Ross,should I copy this file to some folder?Thanks!
Yes then load it via the com addins dialog.
Thanks
Ross