Problem using Oorang's worksheet compare on a Mac

[Oorang]

Updated code post with non-enum message box syntax. Just as a side note, if one of you mac types wouldn't mind, in the VBE, go to Tools>References and tell me what dll is referenced for the entry that says "Visual Basic for Applications". (Just out of curiosity.)

[RonMcK]

Aaron,

What I found is:
ORLMcKenzieR-M:/Applications/Microsoft Office 2004/Office ronald$ ls -l "Visual Basic for Applications"
-rwxrwxr-x 1 admin admin 5715840 Feb 12 2006 Visual Basic for Applications

HTH,

[Oorang]

I think that is a partial path. Try doing this:

1. Set a reference to "Microsoft Visual Basic for Applications Extensibility"
2. Go to tools>macro>security and check "Trust Access to Visual Basic Project"
3. Run the following:

Public Sub PrintRefs()
    Dim r As VBIDE.Reference
    For Each r In Excel.Application.VBE.ActiveVBProject.References
        Debug.Print r.Name & vbNewLine & r.FullPath & vbNewLine
    Next
End Sub