VBA Reference Library

Question

Hi,

Part of my Open Workbook Event refers to Environ.  I get an error message Cant Find project or Library.  So i go to set a reference to the System Monitor Control and it tells me its MISSING:  However, when i check C:\Windows\System32 the file sysmon.ocx is there.  So now i dont undertstand what it means when it referes to a Library as MISSING:

As i run Excel (2003) on a company network although i've checked Chip Pearsons website i wouldnt be able to apply his suggested fix.

I'm at a loss of what to do next!!  Would having Excel re-installed clear the issue.

Any advice greatly received.

Thanks

John

Answer 1

Hi,

Part of my Open Workbook Event refers to Environ.  I get an error message Cant Find project or Library.  So i go to set a reference to the System Monitor Control and it tells me its MISSING:  However, when i check C:\Windows\System32 the file sysmon.ocx is there.  So now i dont undertstand what it means when it referes to a Library as MISSING:

As i run Excel (2003) on a company network although i've checked Chip Pearsons website i wouldnt be able to apply his suggested fix.

I'm at a loss of what to do next!!  Would having Excel re-installed clear the issue

The general rule for a flagged reference item is to put a checkmark in the flagged item's checkbox if it is not checked and remove the checkmark if it is checked. Usually, that straightens things out.