Search found 429 matches

by PepsiHog
Fri Jan 10, 2020 6:40 pm
Forum: Technical / Scripting
Topic: Help with VBS, Please
Replies: 2
Views: 99

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: 355

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: 355

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: 355

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: 355

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: 333

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: 333

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: 297

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: 99

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: 297

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: 297

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
by PepsiHog
Sun Dec 01, 2019 3:24 pm
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 297

Re: IECreate

OK. It has something to do with the structure. Has nothing to do with IECreate.

PepsiHog
by PepsiHog
Sun Dec 01, 2019 2:32 pm
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 297

Re: IECreate

Grovkillen,

Yea, I tried that. Didn't work.

Thanks for helping,
PepsiHog
by PepsiHog
Sun Dec 01, 2019 6:51 am
Forum: Technical / Scripting
Topic: IECreate
Replies: 7
Views: 297

IECreate

Hello All, I have a subroutine that uses IECreate>IE[0]. I have a list of multiple folders. For each folder it needs to Gosub the routine with IECreate>IE[0]. It works the first time, but then it just stops execution when the sub is called again. I thought I might have to us IEQuit. Tried that, didn...
by PepsiHog
Thu Nov 28, 2019 5:45 pm
Forum: General Discussion
Topic: StringGrid 101
Replies: 4
Views: 368

Re: StringGrid 101

Hi JRL, Are you kidding? Do you really believe I would own an establishment that didn't have Pepsi and Pepsi products? And there would be a "Happy Hour"! Not that it's needed. I'm happy any time I drink Pepsi. If left to me, it would be a nightmare. Get the blood flowing. Plus, during those life and...