[RESOLVED] Format in excel 2007

[primfran]

In previous versions of excel I was able to format the contents of a cell by using Format() (ex. Format(A1.Value, "0.00%") to turn the value of cell a1 into a percentage. But in the 2007 version of excel I get an error that the project or library cannot be found. Does anyone know which reference I should add to get this to work?

thanks

[RobDog888]

It works for me so you may have lost a reference. Was this workbook previously created in 2003 or before?

Visual Basic for Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library

At a minimum you should have those.

[primfran]

I have all 4 of those. And yes it was created in 2003.

[RobDog888]

Maybe your reference is corrupt.

Try creating a new workbook and save it as 2003 fileformat. Then open the vba ide and try your code.

[anhn]

Check to see if it has any bad reference with the word "MISSING:".

Beside that, to format a cell you should use .NumberFormat property of Range, that is a better way:

Sheet1.Range("A1").NumberFormat = "0.00%"

Noted that Format(Range("A1"), "0.00") returns a String that looks like a number, so it convert number to text then in cell that text may be converted back to number if the cell has "General" format.

[RobDog888]

Format is in the "Visual Basic for Applications" library reference. Its a core reference of Excel/Office so it can not be removed and shouldnt show "MISSING". It can get corrupt which more then likely be your issue.

Did you try checking a new workbook like I suggested? If it doesnt work in new then its probably the corrupt reference.

[anhn]

Format is in the "Visual Basic for Applications" library reference. Its a core reference of Excel/Office so it can not be removed and shouldnt show "MISSING". It can get corrupt which more then likely be your issue.

Agee with that, however, it looks like the same sympton with Chr() and orther core functions when one of other library MISSING, the compiler may confuse. I have seen this before when I open someone's workbook with a missing library even that is not used in the code at all, I just uncheck that MISSING library then it works. That maybe or maybe not in this case, but just have a check.

[primfran]

Thanks anhn,

I did have a "MISSING" reference. When I removed it, the problem went away.

[anhn]

Thanks anhn,

I did have a "MISSING" reference. When I removed it, the problem went away.

Glad to see that my experience about the "MISSING" can help in this case.

[RobDog888]

... you may have lost a reference.

Glad its settled then