Sticky Thread: Room Mode Calculator and Converter. - Problem

**MikeOates** · **06-06-06, 12:47 PM**

I have tried to use the Room Mode Calculator on the above tread, but no matter what figures are put in the room size, even leaving those in that are in the file, caused an error...

Run-time error '1004':
Application-defined or object-defined error

I presume the room sizes are in feet?

Mike

**Sonnie** · **06-07-06, 01:21 AM**

Hey Mike... did you enable macros?

I just downloaded it and it worked fine for me as long as I enabled macros. If I diable macros I get errors too.

Yes... the sizes are feet.

**MikeOates** · **06-07-06, 01:45 AM**

Sonnie,

Yes, macros are enabled. Could the version of Excel be a problem, I have Excel 2000 (9.0.3821 SR-1)

Mike

**Sonnie** · **06-07-06, 02:25 AM**

Yup... it's a 2003 version. I suppose I can save it in an older version, but I'm not sure which is which. Is 2000 version 2.1, 3.0 or 4.0. Looks like those are the only Workbook choices I have.

**MikeOates** · **06-07-06, 02:43 AM**

Sonnie,

Could you try version 4 as I have Excel 2000 (9.0.3821 SR-1) The numbering implies I have version 9. (I assume)

Mike

**Sonnie** · **06-07-06, 02:51 AM**

It wasn't acting right when I saved ... claims version 4 doesn't have all he features, but I saved it anyway and you can try it.

hardman might be able to fix it up in 2000.

roomcalculator_v4.xls

**MikeOates** · **06-07-06, 03:24 AM**

Sonnie,

It can't find two macro's 'roomcalculator_v4.xls!Clear' and 'roomcalculator_v4.xls!Merge' These message appear when I press the buttons 'Clear' and and 'Plot'. Also when opening the file it does not ask me if I want to enable macros, so they don't seem to be included in the file.

Don't worry about it, I don't want you spend too much time on it, I don't fully understand what it would tell me anyway, still a lot to learn.

Mike

**Sonnie** · **06-07-06, 10:43 AM**

I suppose those features that are missing are ones that could not be saved in version 4.0. I'll see if hardman can fix up a 2000 and 2002 version for us. I'm pretty much clueless with creating a workbook like he did.

**Sonnie** · **06-08-06, 01:52 AM**

Hey Mike... hardman saved it as an older version. Try it now from the sticky thread.

Advertisement