#1
|
|||
|
|||
Split function not working as I expect??!!
In Excel VBA, the Split function takes at least two arguments, namely a string to be tokenised and a token delimiter.
Coming to Word VBA, the Split function seems to take only one argument ("label") and doesn't seem to do what the Excel VBA version of Split does. And this is within the SAME Office release. What gives? How can I get excel's Split functionality in Word, without writing my own function? |
#2
|
||||
|
||||
I don't know where you're getting your information from. According to the Word VBA help file:
Split Function Description Returns a zero-based, one-dimensional array containing a specified number of substrings. Syntax Split(expression[, delimiter[, limit[, compare]]]) The Split function syntax has these named arguments: Part Description expression Required. String expression containing substrings and delimiters. If expression is a zero-length string(""), Split returns an empty array, that is, an array with no elements and no data. delimiter Optional. String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. limit Optional. Number of substrings to be returned; –1 indicates that all substrings are returned. compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. Settings The compare argument can have the following values: Constant Value Description vbUseCompareOption –1 Performs a comparison using the setting of the Option Compare statement. vbBinaryCompare 0 Performs a binary comparison. vbTextCompare 1 Performs a textual comparison. vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database. If you care to look at some of the numerous VBA posts I've made here, you'll see plenty of implementations.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
It's what the VBA code editor is telling me. See screenshots attached!
|
#4
|
||||
|
||||
This works for me:
Code:
Sub Demo() Application.ScreenUpdating = False Dim SArr() As String, i As Long SArr = Split("The.quick.brown.fox.jumps.over.the.lazy.dog.", ".") For i = 0 To UBound(SArr) MsgBox SArr(i) Next Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
... but not for me ... (just tried it in Word - works fine in Excel, just not in Word)
|
#6
|
||||
|
||||
Try re-starting Word. If that doesn't work, try repairing the Office installation (via Programs & Features > Microsoft Office > Change in the Windows Control Panel).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
I went for the repair in the end, that worked!!! Many thanks
|
#8
|
|||
|
|||
Really? Word is so bloody sloppy that it can get buggered up enough to screw up the Split function???? I am shocked. Documents? Yeah I know Word (or even sloppier add-ins do) screws up documents. But internal VBA functions? Enough that Repair is needed...and works?
I mean I am happy that Repair worked, but yikes. Shocked and appalled. What the heck happened that something could rewrite an internal function in VBA. It has to be a rewrite because the function still works, but no longer accepts the proper number of parameters. |
#9
|
||||
|
||||
No need to get so worked up Gerry - it could have been something as simple as a damaged dll (caused, perhaps, by a minor disk imperfection), which is why a repair could work.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
I am, I admit a little worked up. "damaged dll". Yeah OK, but it is still sloppy that a dll can get so specifically "damaged". But sure, OK. It just seems like I read so much about Repair; much more than it used to be. I have never, ever, needed to use Repair, not even once. It is not like I do not, have not, used Word a fair amount. I wonder what is so different for others.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Signature function not working? | prroots | Outlook | 6 | 08-17-2015 07:18 AM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
Wrap Text function not working? | mhays | Excel | 1 | 11-21-2012 05:03 PM |
Can't get AND function working | Scaffold | Excel | 6 | 07-09-2010 01:41 AM |
My weekday function aint working | FraserKitchell | Excel | 12 | 05-25-2010 04:42 PM |