VB - Split command?

[Vik Rubenfeld]

I understand that on the PC there's a Visual Basic command called Split
that can be used like this:

strArray = Split(strTestString, ",", -1)

I can't find it yet on Mac VB help. Is the VB Split command available on
the Mac?

-Vik

 

[Steve Rindsberg]

I understand that on the PC there's a Visual Basic command called Split

that can be used like this:

strArray = Split(strTestString, ",", -1)

To be a bit more specific (ok, maybe a bit pedantic too? what the heck,
it's Krayzee Bonus Dayzz):

On the PC, not necessarily.
In Windows Visual Basic 6 and Office 2000 (and up) VBA, yes.

I can't find it yet on Mac VB help. Is the VB Split command available on
the Mac?

There isn't any Mac VB;
Split seems not to be available in Office 2001 VBA.
I don't know about PPT X

 

[Vik Rubenfeld]

There isn't any Mac VB;

Split seems not to be available in Office 2001 VBA.
I don't know about PPT X

That explains it!

Steve, I really appreciate all your advice on this. I actually have a
macro now that will read a text file into MSGraph.

My current anomaly is this: The first file works fine. It reads in, gets
its data inserted into MSGraph, and the chart on the slide shows the new
data. The macro then adds a 2nd slide and opens a second file - which
also reads in fine - except, when I go back to the first slide, its data
has been replaced by the data from the 2nd slide.

I tried calling

oGraph.Application.Quit

....after the 1st slide, but it didn't correct the anomaly.

How do I get slide 1 to not lose its data?

-Vik

 

[Vik Rubenfeld]

Dang, you're crankin' here. Good work.

Thanks! Your advice has been much appreciated.

oGraph.Update

It worked! My macro did 18 of 72 files, and then MSGraph crashed. When I
reviewed the slides it had produced, I noticed a lot of them were gray,
as if they were still open in MSGraph. I wonder if MSGraph ran out of
memory. Do I have to do a command to close them out of MSGraph?

-Vik

 

[Steve Rindsberg]

It worked! My macro did 18 of 72 files, and then MSGraph crashed. When I

reviewed the slides it had produced, I noticed a lot of them were gray,
as if they were still open in MSGraph. I wonder if MSGraph ran out of
memory. Do I have to do a command to close them out of MSGraph?

I'd .Quit Graph after each update and set the object variable = Nothing

 

[Vik Rubenfeld]

I'd .Quit Graph after each update and set the object variable = Nothing

Everything's working well. MSGraph crashes repeatably after about 20
files - but then it did the next 50 without crashing. I think I'll try
this on a machine at the local Kinko's, and if that crashes too I'll try
to notify MS Tech support.

Thanks for all your great advice, Steve.

-Vik

 

[Vik Rubenfeld]

No problem, Vik. See, I'll toss in the bits I can, you become the

newsgroup's leading authority on automating Graph and then you can answer
questions on it too. I can go out for coffee. And maybe a cheese danish.
<g>

Thanks Steve. Coming from you, I consider that quite a compliment.