topic Re: Ucase?? in VBA Forum

Ucase??

Anonymous — Tue, 11 Apr 2000 04:59:24 GMT

I have a little program that runs fine for me, but two other
people have tried it and it hangs on this line

COLUMN.Name = UCase(COLUMN.Name)

They say it is highlighting the Ucase when it hangs. Ucase
appears to be a standard VBA function so does anyone have any
ideas why it might hang for some and not others on this?

--
Kent Keller
Check out the Mechanical Desktop FAQ @
http://webhome.idirect.com/~dfulford/

Re: Ucase??

Anonymous — Tue, 11 Apr 2000 11:08:29 GMT

I'm not sure but ucase returns a variant and ucase$ returns a string.
Could it be that COLUMN.Name only accepts strings?

--
Stuart Nathan @
http://www.office-manager.co.uk

Re: Ucase??

Anonymous — Tue, 11 Apr 2000 17:46:25 GMT

Kent,

Instead of using

COLUMN.Name = UCase(COLUMN.Name)

use this

COLUMN.Name =VBA>.UCase(COLUMN.Name)

Re:

Anonymous — Wed, 12 Apr 2000 15:59:43 GMT

Hi

Is the > a typo?? when I add it I get a invalid or unqualified reference.
What does the VBA do, I can't find anything in the help explaining it.

Unfortunately the program runs fine for me, and the people that it doesn't
work for aren't real quick about trying things so I don't yet know if this
fixed it or not.

--
Kent Keller
Strobe Data Inc.
www.strobedata.com

If only women came with pull-down menus and on-line help.

"MASMITH" wrote in message
news:eefe23e.1@WebX.SaUCah8kaAW...
> Kent,
>
> Instead of using
>
> COLUMN.Name = UCase(COLUMN.Name)
>
> use this
>
> COLUMN.Name =VBA>.UCase(COLUMN.Name)

Re:

Anonymous — Wed, 12 Apr 2000 20:49:38 GMT

Hiya,

Is the COLUMN object a control on a userform? If so... check the users machine to make sure the control is actually present.

I have found that on some machines, a control can get corrupted and if its not present, you will get similar errors in standard VBA functions.

Hope this helps!

Micah

Re:

Anonymous — Wed, 12 Apr 2000 21:00:04 GMT

Sorry Micah for the email, wrong button again!!!

Hi

No it isn't a user form control, it is a Mechanical Desktop part list column
definition.

Dim COLUMN As McadColumnDefinition

I wish I could get it to fail on my machine so I could try a couple of
things. Anybody running MDT and want to do a couple of quick tests on it??

--
Kent Keller
Strobe Data Inc.
www.strobedata.com

If only women came with pull-down menus and on-line help.

"mnerren" wrote in message
news:eefe23e.3@WebX.SaUCah8kaAW...
>
> Hiya,
>
> Is the COLUMN object a control on a userform? If so... check the users
machine to make sure the control is actually present.
>
> I have found that on some machines, a control can get corrupted and if its
not present, you will get similar errors in standard VBA functions.
>
> Hope this helps!
>
> Micah

Re: Ucase??

Anonymous — Wed, 12 Apr 2000 23:00:55 GMT

what runtime error do you generate when it hangs?

-phix

Kent Keller wrote in message
news:eefe23e.-1@WebX.SaUCah8kaAW...
> I have a little program that runs fine for me, but two other
> people have tried it and it hangs on this line
>
> COLUMN.Name = UCase(COLUMN.Name)
>
> They say it is highlighting the Ucase when it hangs. Ucase
> appears to be a standard VBA function so does anyone have any
> ideas why it might hang for some and not others on this?
>
> --
> Kent Keller
> Check out the Mechanical Desktop FAQ @
> http://webhome.idirect.com/~dfulford/
>

Re:

Anonymous — Thu, 13 Apr 2000 02:48:13 GMT

Hi phix

they say it says

Compile error: Can't find project or library. (as displayed in
dialogue box)

The VBA debugger screen displays and highlights "UCase" in the
following line in the program:

--
Kent Keller
Check out the Mechanical Desktop FAQ @
http://webhome.idirect.com/~dfulford/

"Phix" wrote in message
news:eefe23e.5@WebX.SaUCah8kaAW...
> what runtime error do you generate when it hangs?
>
> -phix
>
> Kent Keller wrote in message
> news:eefe23e.-1@WebX.SaUCah8kaAW...
> > I have a little program that runs fine for me, but two other
> > people have tried it and it hangs on this line
> >
> > COLUMN.Name = UCase(COLUMN.Name)
> >
> > They say it is highlighting the Ucase when it hangs. Ucase
> > appears to be a standard VBA function so does anyone have any
> > ideas why it might hang for some and not others on this?
> >
> > --
> > Kent Keller
> > Check out the Mechanical Desktop FAQ @
> > http://webhome.idirect.com/~dfulford/
> >
>

Re:

Anonymous — Thu, 13 Apr 2000 17:49:34 GMT

Hi Kent,

If thats the message they are getting then it is definitely a missing type library. Is that reference to the COLUMN object the first reference the code hits to an MCad object?

This has nothing to do with UCase I would say. Try the things I mentioned in my email, that should work.

Micah

Re:

Anonymous — Thu, 13 Apr 2000 20:23:35 GMT

"mnerren" wrote in message
news:eefe23e.7@WebX.SaUCah8kaAW...
>
> Hi Kent,
>
> If thats the message they are getting then it is definitely a missing type
library. Is that reference to the COLUMN object the first reference the code
hits to an MCad object?

No it is closer to the end of the code than the begining. There are lots of
other calls to the MCad objects before it.

>
> This has nothing to do with UCase I would say. Try the things I mentioned
in my email, that should work.

I am hoping to get someone to try it tonight. Thanks for all your help.

>
> Micah

--
Kent Keller
Strobe Data Inc.
www.strobedata.com

The horn of plenty is usually the one behind you in traffic!