how to parse a string using VBA?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
Geoff said:
Never had this work with PPT 2003!
Click to expand...

Dunno what's up with that, but I have seen installs where you had to start
the VBA help manually. Also, sometimes, jerky admins don't even install the
VBA help.
When I look up Spilt and then Split function with MS Visual Basic
HelpI don't seem to get the version you used - do I?
Click to expand...

Version of what?
 
Also, does this work the way it is (I think) intended to work?

Dim iLength, i, count, newStart As Long

The datatypes of iLength, i, count, and newStart are (I think)
supposed to be long. But are they?
Click to expand...

No, only the last one is a Long. The others are the default datatype;
presumably Variant.
 
No, only the last one is a Long. The others are the default datatype;
presumably Variant.
Click to expand...

OK. I threw together some quick code and didn't check it carefully. Thanks
for the pointers. I'll be more careful next time.
--David
 
David said:
OK. I threw together some quick code and didn't check it carefully.
Thanks for the pointers. I'll be more careful next time.
Click to expand...

You "grew up" in C, right? <g>

VB is verbose. Not that that's a *bad* thing.

One last tip... With arrays, the very best habit to get into is to _always_
specify both the top and bottom bounds. IOW, using your previous example,
there's no way to have confused this declaration:

Dim aStrings(0 To 5) As String
or
Dim aStrings(1 To 6) As String

Maybe the best message I can convey is, don't trust defaults in VB. If
there's a way to say-so explicitly, it's absolutely worth the few extra
keystrokes.
 
I have only the 2003 version (with SP 2) and F1 does not work here
either.
Click to expand...

Thanks, Geoff. I can stop lashing myself for this. <g>

In the meanwhile, we'll both have to type what we want into the little box at upper
right of IDE. Note that copy/pasting the term you're after doesn't always work
either. Usually yes, but sometimes it pastes something entirely unrelated.

Then again, sometimes this machine's monitor spins round and spews nasty green
stuff. It doesn't like it when I get to close to it with cloves of garlic either.
 
Maybe the best message I can convey is, don't trust defaults in VB. If
there's a way to say-so explicitly, it's absolutely worth the few extra
keystrokes.
Click to expand...


What? And take all the fun and surprises out???
 
You "grew up" in C, right? <g>

Actually, a quick perusal of my bookshelf reminds me that my oldest
programming book is Fortran 77. C didn't come until much later.
 
Wait, I just remembered that I have 2003 with SP2 and F1 doesn't work for
me either. I always thought it was a stupid PC thing because it works on
my Mac.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
 
David said:
Actually, a quick perusal of my bookshelf reminds me that my oldest
programming book is Fortran 77. C didn't come until much later.
Click to expand...

Heh, yeah, F77 here too, but that was after whatever dialect of BASIC was
running on those teletypes I started with. <g>
 
David M. said:
Wait, I just remembered that I have 2003 with SP2 and F1 doesn't work for
me either. I always thought it was a stupid PC thing because it works on
my Mac.
Click to expand...

Welcome aboard. Misery loves company and at least you can bring classes, if
not class, to the group. ;-)
 
Back
Top