Excel vba form dll problem for add-in
Excel 2010 Office version
I have an add-in project that loads ok on some of my folks machine and others...I'm starting to have a problem.
All of the controls on the form are not loading and i get a reference error when loading the add-in.
Any idea as to why this is happening..?
Thanks
fordraiders
Check out Tools, References. Any in there marked "MISSING"?
ASKER
yes and no...
Its weird, I tried exporting all my code and forms and creating a new .xlam on their machine also..
After importing:
The tab control on a userform, just gets totally wiped, the tab control is their but all additional tabs get deleted. and all the controls are deleted. ?
Its weird, I tried exporting all my code and forms and creating a new .xlam on their machine also..
After importing:
The tab control on a userform, just gets totally wiped, the tab control is their but all additional tabs get deleted. and all the controls are deleted. ?
Sounds like your userform is corrupted. Can you perhaps attach the file in question?
ASKER
it installs correctly on some machines.
It is not corrupted.
It is not corrupted.
Did yoou check the references?
If a libary is missing VBA can't recognize parts of the language used in the code. If the version of a library is different from what it should be the effect of such not understanding could be "weird".
Reference libraries are set on each machine individually. They are not part of any program, and they don't install automatically. Setting the references is a one-time affair for each computer. The local installation of Excel remembers which libraries are needed and loads them automatically next time, irrespective of which workbook or add-in is opened.
From the VB Editor click on Tools and Select "References". Compare the list of checked (available) items on a machine where everything is perfect with a similar list taken from a machine which is acting weird. Eliminate differences.
If a libary is missing VBA can't recognize parts of the language used in the code. If the version of a library is different from what it should be the effect of such not understanding could be "weird".
Reference libraries are set on each machine individually. They are not part of any program, and they don't install automatically. Setting the references is a one-time affair for each computer. The local installation of Excel remembers which libraries are needed and loads them automatically next time, irrespective of which workbook or add-in is opened.
From the VB Editor click on Tools and Select "References". Compare the list of checked (available) items on a machine where everything is perfect with a similar list taken from a machine which is acting weird. Eliminate differences.
Again: can you post the file? (you can remove everything from the worksheets, we just need the VBA)
ASKER
I would but this is company protected code.
Is there another way to get it to you. I can password protect it.
Is there another way to get it to you. I can password protect it.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
ok Thanks
VBE / Tools / References