Search found 493 matches

by PepsiHog
Sat Jan 25, 2020 9:25 pm
Forum: Technical / Scripting
Topic: Remove blank lines when there are more than one of them
Replies: 10
Views: 1803

Re: Remove blank lines when there are more than one of them

@ 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...
by PepsiHog
Sat Jan 25, 2020 8:55 pm
Forum: Technical / Scripting
Topic: Abbreviated dialog definitions
Replies: 2
Views: 716

Re: Abbreviated dialog definitions

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...
by PepsiHog
Sat Jan 25, 2020 8:01 pm
Forum: Technical / Scripting
Topic: Abbreviated dialog definitions
Replies: 2
Views: 716

Re: Abbreviated dialog definitions

@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...
by PepsiHog
Sat Jan 25, 2020 7:29 pm
Forum: The Water Cooler
Topic: DelArray / DelVariable
Replies: 6
Views: 4495

DelArray / DelVariable

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...
by PepsiHog
Fri Jan 10, 2020 6:40 pm
Forum: Technical / Scripting
Topic: Help with VBS, Please
Replies: 2
Views: 784

Re: Help with VBS, Please

@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...
by PepsiHog
Fri Jan 03, 2020 4:36 pm
Forum: The Water Cooler
Topic: Separate
Replies: 6
Views: 4537

Re: Separate

@All,

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

Am I the first to post this?

PepsiHog
by PepsiHog
Fri Jan 03, 2020 4:24 pm
Forum: The Water Cooler
Topic: Separate
Replies: 6
Views: 4537

Re: Separate

@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, ...
by PepsiHog
Fri Jan 03, 2020 2:31 am
Forum: The Water Cooler
Topic: Separate
Replies: 6
Views: 4537

Re: Separate

@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 ...
by PepsiHog
Mon Dec 30, 2019 9:43 pm
Forum: The Water Cooler
Topic: Separate
Replies: 6
Views: 4537

Separate

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...
by PepsiHog
Mon Dec 30, 2019 8:54 pm
Forum: The Water Cooler
Topic: Enhancement Suggestion
Replies: 7
Views: 4912

Re: Enhancement Suggestion

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

PepsiHog
by PepsiHog
Mon Dec 30, 2019 8:52 pm
Forum: The Water Cooler
Topic: Enhancement Suggestion
Replies: 7
Views: 4912

Re: Enhancement Suggestion

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
by PepsiHog
Mon Dec 30, 2019 5:50 pm
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 1464

Re: IECreate

So........

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

PepsiHog
by PepsiHog
Mon Dec 30, 2019 5:45 pm
Forum: Technical / Scripting
Topic: Help with VBS, Please
Replies: 2
Views: 784

Help with VBS, Please

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...
by PepsiHog
Sun Dec 01, 2019 4:30 pm
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 1464

Re: IECreate

Hey! Wait just one second!

Why did it work the first time with IEShowIE>1,1? It only produced an error the second time around.

Maybe, Marcus needs to pluck his brain out and...... :lol:

PepsiHog
by PepsiHog
Sun Dec 01, 2019 4:07 pm
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 1464

Re: IECreate

[Solved]
I am using IEShowIE. The reference is IE[1]. But I had IEShowIE>1,1.

Sometimes, I just want to pluck my brain out, and beat it silly! :lol:

PepsiHog
Sign up to our newsletter for free automation tips, tricks & discounts