@Marcus, At present Macro Scheduler doesn't have native functions, just subroutines. Great idea! Is this in your to-do list? It should be. At the top, preferably. I mean, I'm just saying that's like the best idea in the last 5 minutes. Which raises the question, when do you think v15 might hit the m...

Goes to show what I know. I thought it was the tab order. So when I wanted to get rid of the highlight I'd place a "not visible" edit and change the tab order so the highlight would be in the unused edit. You skin your cat, I'll skin mine. However, I like how you skin, so I'm gonna do that from now ...

@ hagchr, I agree. I find this to work well between RegexBuddy and Macro Scheduler. [edit]- I just noticed you turn off 's'. I'll have to try that. regex>(?Usmi)pattern,text,,match,nom,0 i= ignore case m= ^ and $ match start and end of line s= . matches newline as well x= Allow spaces and comments J...

Here is an example of how to do browse. Dialog>Dialog1 object Dialog1: TForm Left = 428 Top = 122 HelpContext = 5000 BorderIcons = [biSystemMenu] Caption = 'CustomDialog' ClientHeight = 212 ClientWidth = 476 Color = clBtnFace Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11...

@bossydog9, It appears to be out-dated dialog script. In older versions that's how it was done. You pretty much would have to have an out dated version of MS to play around with it. I believe newer versions can still execute it, but it's so easy to create the same in the newer version, why bother? Y...

Hello All, I am curious about possibilities. I think an answer to this may give me some ideas. So far I can't seem to wrap my head around this. I am looking for some plausible examples. I was playing around and happened to use DelArray. It's pretty self explanatory what it does. The part that I am h...

@Marcus, Yep. I have as much knowledge about VB as you have about the loch ness monster. There is no way of passing mytext instead? Forgive me. Macro Sch uses VBS. And you gave me what I wanted, in vbs. I believe you were saying my errors based on it being VB. So my question is can it be passed in y...

@All,

I just realized.......HAPPY NEW YEAR!

Am I the first to post this?

PepsiHog

@Dorian, I suspect those quotes are from the conversation Marcus and I had. I do understand that. My vars are different. And I am still having the problem. But as JRL's script proved, something else is going on. @JRL, Working on it. Give me a couple of days and check back here, please. As they say, ...

@JRL, Interesting. Thanks. I am working on a script. At the start it reads a few datablocks. The names being separated are different. Marcus pointed that out and I changed them. Your macro works as you said. As far as what is going on, I clearly have no idea. Some how, some way, the original string ...

We all know that when you use the command Separate> that you are done using that string, so there is no reason to keep the original string. You would have to be NUTS, to separate a string and then STILL use the original string! Like some of you might use LabelToVar to get a DataBlock and then separa...

Oh! Now I get it. The men in white coats are delivering the straight jacket(s).

PepsiHog

If it tries to read my thoughts, it's not me that will be wearing the white coat.

Oh, I just realized, maybe you weren't referring to straight jackets. I was wondering why the men would be wearing them.

Funny, when you refered to white coats, it made me think of straight jackets.

PepsiHog

So........

The moral of this story is.....maybe.....don't try to change the format!

PepsiHog

Hello Everyone, Trying to get this vbs I got online to work in MS. It is giving an error, expected end of line. Will someone please show how to get this to work? VBSTART Sub Split_Example1() Dim MyText As String Dim i As Integer Dim MyResult() As String MyText = "My Name is Excel VBA" MyResult = Spl...