File not found VBA6.DLL on compile VBAProject

[annandap]

Hi,
I need assitance to resolve the above issue, it happends when I am in the VBA Editior and attempt to compile my macro project (using Excel 2007).

I can run my macro from excel ok but I am unable to compile it in the editor. This has been an ongoing issue and I have rebuilt my pc since and am still getting the same issue.

Observations are:
1. The macros are storted in the Personal.xlsb file and I get the error as described above.
2. If I add an excel macro file called Personal.xls (from my Office 2003 excel) with macros in, any macros in this file will compile with no errors or reference to the VBA6.DLL.

Any assitance would be greatly appreciated.
Regards..
Peter.

 

[genomon]

I don't program for Excel, but if this was an Access problem I would suspect broken or missing references in the project library (Tools|References).

Ever notice how fast Windows runs? Me neither.

 

[SkipVought]

I would suspect the same thing.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[annandap]

Hi,
Thanks for the responses, I have already checked the references as I thought the same thing. There is no indication to any missing references and it only happens when the macros are contained in the Personal.xlsb. If I move the macros to the Personal.xls they compile normally with no errors.

Regards..
Peter.

 

[PHV]

Why an .xlsb instead of an .xlsm ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[annandap]

Hi,
.xlsb is the file type that Excel 2007 creates when it wants to store macros available to all open sheets in excel. Excel will create this file if it does not exist the first time you go to create a macro.

I have resolved my problem this morning by removing the old .xlsb file and letting Excel create a new one, I then copied all my macros back into the new .xlsb file and they compiled in the VBA editor no problems.

Regards..
Peter. :-D