Enum problem

[Jim Carlock]

I created a spreadsheet with a Module. Inside the module,
there is a statement as follows:

Public Enum ezFormState
Quote = 1
Revision = 2
PO = 3
End Enum

This works fine on a Win2k system with Excel 2K/XP.

However, on another system, which is running Windows 98, it
doesn't run at all. It quits with an error message highlighting the
Enum statement. I forgot to email the exact message to myself
and I won't be able to get to it until tomorrow.

Hoping someone might have a quick answer. In the meantime,
I'll search google.

Thank you in advance.

 

[Dave Peterson]

I don't think it's a windows version problem. Enum was added with xl2k.

Maybe you could just use constants???

 

[Jim Carlock]

It's quite possible that the machine it was installed upon has
Excel 97 installed. I didn't check that. Microsoft seems to
indicate that Enum became a keyword with the advent of
Excel 97.

I was digging around the Microsoft website and noticed some
information about using typedef enum in IDL files. Found
the midl.exe compiler, found some preprocessors cl.exe.

I'm now wondering about how IDL files are used and I've
noticed that Microsoft talks about IDL files actually being
compiled, which makes me wonder what kind of file are they
being compiled into. Anyways, it's too late for me to explore
this any further for the night.

I also noticed VBScript installed with Excel. I've only used
VBScript to do some simple things like rebooting a remote
computer though by sticking a script into the Scheduler.

There seems to be a built in SQL syntax and protocol for
gaining access to networking info, user info and computer
info.

Just wouldn't know how to tie DAO or ADO into VbScript.
Or if it's viable.

Forgive me. I'm digging at things here and there and and I
don't expect answers to everything, just little tidbits here
and there.

Thanks!

 

[Dave Peterson]

I don't recall Enum in xl97, but I don't have that anymore, so I can't check.

..IDL = .DLL ????

If there's a question in there, I'm not smart enough to answer it correctly.

You may want to check Ole Erlandsen's site for more info:

http://www.erlandsendata.no/english/vba/addins/comaddins.htm
http://www.erlandsendata.no/english/vba/adodao/

It's quite possible that the machine it was installed upon has
Excel 97 installed. I didn't check that. Microsoft seems to
indicate that Enum became a keyword with the advent of
Excel 97.

I was digging around the Microsoft website and noticed some
information about using typedef enum in IDL files. Found
the midl.exe compiler, found some preprocessors cl.exe.

I'm now wondering about how IDL files are used and I've
noticed that Microsoft talks about IDL files actually being
compiled, which makes me wonder what kind of file are they
being compiled into. Anyways, it's too late for me to explore
this any further for the night.

I also noticed VBScript installed with Excel. I've only used
VBScript to do some simple things like rebooting a remote
computer though by sticking a script into the Scheduler.

There seems to be a built in SQL syntax and protocol for
gaining access to networking info, user info and computer
info.

Just wouldn't know how to tie DAO or ADO into VbScript.
Or if it's viable.

Forgive me. I'm digging at things here and there and and I
don't expect answers to everything, just little tidbits here
and there.

Thanks!

 

[Tom Ogilvy]

Enum was not introduce until VBA6 in Excel 2000. It wasn't supported in VBA
5/Excel 97.