Can I use Word built-in dialog in Excel macro?
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" ...
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)
|