DLL unable to compile (permission denied)

[bartrein]

Hi

I'm having a problem compiling my VB6 library which i am using in excel VBA.

Excel application is closed, i've set class = nothing at the end of my vba macro.

any idea why is this happening?

 

[genomon]

Try disabling antivirus, especially if it is Symantec Endpoint.

Cogito eggo sum – I think, therefore I am a waffle.

 

[genomon]

Ooops - forgot! If you are using Excel 2007 you will need to enable all macros in the trust center, and make sure you add the location of the dll to the list of trusted folders.

Cogito eggo sum – I think, therefore I am a waffle.

 

[bartrein]

Thanks genomon. I am using excel 2003 and antivirus shouldn't have anything to do to with it (i think).

When i rename my DLL i can compile it no problem, and even without renaming, it allows me to compile. it's usually when i close excel to add some changes in VB6 and then compile when i getting this message about permission.

any idea why?

 

[TysonLPrice]

Next time you get the error try pulling up task manager and see if something is running you don't expect.