Murray Brown
asked on
Excel VBA referenvce
Hi. What reference do I add for the following VBA code
Sub DeleteModule()
Dim VBProj As VBIDE.VBProject
Dim VBComp As VBIDE.VBComponent
Set VBProj = ActiveWorkbook.VBProject
Set VBComp = VBProj.VBComponents("Incom ing")
VBProj.VBComponents.Remove VBComp
End Sub
Sub DeleteModule()
Dim VBProj As VBIDE.VBProject
Dim VBComp As VBIDE.VBComponent
Set VBProj = ActiveWorkbook.VBProject
Set VBComp = VBProj.VBComponents("Incom
VBProj.VBComponents.Remove
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Microsoft Visual Basic For Applications Extensibility
Hi,
You need to set a reference to:
Microsoft Visual Basic For Applications Extensibility 5.3.
You need to set a reference to:
Microsoft Visual Basic For Applications Extensibility 5.3.
I think it requires a reference to the Microsoft Visual Basic for Applications Extensibility library.
Curt
Curt
Sorry XL-Dennis, I didn't refresh before posting that one.
Curt
Curt
...and everyone else that beat me! :-)
Maybe EE should consider autorefresh for these pages.
Hey why did you leave me out?
Either you award the points to the first answer or split it amongst all who gave the same answer.
Either you award the points to the first answer or split it amongst all who gave the same answer.
Hi all,
Fairness is important in communities like EE and therefore I cannot accept that my answer was rewarded with any points. I suggest that the first answer is rewarded with all the points.
Fairness is important in communities like EE and therefore I cannot accept that my answer was rewarded with any points. I suggest that the first answer is rewarded with all the points.
No problem XL-Dennis, all we provided a correct answer, and that is the most important!
I can agree with what You say :-) But since another guy feels he was left out then it's seems to be important for him.
BTW, call me Dennis
BTW, call me Dennis
Ok Dennis, I understand ;)
I certainly didn't deserve any points being 12 minutes behind the first answer. I would have seen all the replies if I had refreshed before I posted. It's not certain that ssaqibh would have seen any posting if if he did refresh before posting. Auto refresh would be good though!
Isn't the general rule that equal answers that arrive within the first minute should share the points which means that jpaulino and ssaqibh should share the points?
Curt
Isn't the general rule that equal answers that arrive within the first minute should share the points which means that jpaulino and ssaqibh should share the points?
Curt
EE rules say that the first answer should be awarded the points. But it has frequently been seen that people have been sharing points among same or similar answers. So it should either be first only or all.
ASKER
this answer was first and on the money