PDA

View Full Version : Opening 2010 .xlsm file in 2007 version of Excel



Rlb53
03-03-2012, 07:34 PM
Is there a DLL file or add in that I can download to allow Excel 2007 operate a Macro / Userform Driven workbook that was generated in Excel 2010?

I get the "Can't Find Project or Library" Message.

When it defaults to the VBA Manager the "FORMAT" command is highlighted in the code listed below.

TextBox1.Value = Format(Sheets("sheet2").Range("b3"), "$0.00")

Thanks.

Paul_Hossler
03-03-2012, 08:27 PM
In the VBE in 2007, go to Tools, References and see if any are #MISSING.

If there are, uncheck it and save it

You might have to check the corresponding 2007 Reference

Sometimes that happens to me

Paul