Can I use Word built-in dialog in Excel macro?

I am missing change case function of MS Word in Excel. I would like to
import Word's built-in wdDialogFormatChangeCase box in an Excel macro. Is
there a way or I have to create may own dialog?

MS Office XP (2002)

Not sure what this Word dialog does, but you can easily use the VBA function
LCase & UCase to change the case of strings.
If you must use Word then you will need to use automation to create an
instance of Word, send your send to the dialog and return the value to
Excel.

What are you trying to achieve ?

NickHK

"Bracha" <Bracha@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:7C6E4948-E71C-4006-9737-8ED4C19E7EDE@microsoft.com...
>I am missing change case function of MS Word in Excel. I would like to
> import Word's built-in wdDialogFormatChangeCase box in an Excel macro. Is
> there a way or I have to create may own dialog?
>
> MS Office XP (2002)

Thank you for your help. This dialog box allows choosing between sentence,
lower, upper, title and toggle case.
That way I could tie it to individual functions that you mentioned. I thing
your isanswer is no and I will have to build the dialog myself.
Thanks again

bracha

"NickHK" wrote:

> Not sure what this Word dialog does, but you can easily use the VBA function
> LCase & UCase to change the case of strings.
> If you must use Word then you will need to use automation to create an
> instance of Word, send your send to the dialog and return the value to
> Excel.
>
> What are you trying to achieve ?
>
> NickHK
>
> "Bracha" <Bracha@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:7C6E4948-E71C-4006-9737-8ED4C19E7EDE@microsoft.com...
> >I am missing change case function of MS Word in Excel. I would like to
> > import Word's built-in wdDialogFormatChangeCase box in an Excel macro. Is
> > there a way or I have to create may own dialog?
> >
> > MS Office XP (2002)
>
>
>

Found this, at the bottom of the page:
http://www.xcelfiles.com/Downloads_01.html
Says it is to replicate that functionality in Excel. no idea how good.

NickHK

"Bracha" <Bracha@discussions.microsoft.com> wrote in message
news:673BA4A2-0D17-4B48-A439-573D995449D8@microsoft.com...
> Thank you for your help. This dialog box allows choosing between
sentence,
> lower, upper, title and toggle case.
> That way I could tie it to individual functions that you mentioned. I
thing
> your isanswer is no and I will have to build the dialog myself.
> Thanks again
>
> bracha
>
> "NickHK" wrote:
>
> > Not sure what this Word dialog does, but you can easily use the VBA
function
> > LCase & UCase to change the case of strings.
> > If you must use Word then you will need to use automation to create an
> > instance of Word, send your send to the dialog and return the value to
> > Excel.
> >
> > What are you trying to achieve ?
> >
> > NickHK
> >
> > "Bracha" <Bracha@discussions.microsoft.com>
¼¶¼g©ó¶l¥ó·s»D:7C6E4948-E71C-4006-9737-8ED4C19E7EDE@microsoft.com...
> > >I am missing change case function of MS Word in Excel. I would like to
> > > import Word's built-in wdDialogFormatChangeCase box in an Excel macro.
Is
> > > there a way or I have to create may own dialog?
> > >
> > > MS Office XP (2002)
> >
> >
> >