Some assistance required

[Gnarkill]

Coding guru's,

Can someone possibly offer their assistance with the following? I have an excel spreadsheet for recording tournament games against bowlers. I have a macro that, when I run it, exports certain cell ranges to an XML file that I call from a HTML file. The macro runs fine as is, but what I'd like to be able to do is exclude any entries that have a name value of 'vac' (representing a vacant bowler) from being entered into the XML file. Once the XML file is created, I'd then like to be able to sort by pinfall, highest to lowest, when called from the HTML file.
I'm unable to attach the files because of the file extensions so if anyone can help, let me know and I can email them to you.

Any assistance or guidance is greatly appreciated.

Keiran.

 

[Hooligan]

inStr will test if a string contains another string

inStr(CellToTest, "vac")

and returns 0 or 1

As for sorting, once you have the data minus vacants in array just use a sort algorithm. Try googling vb shell sort or vb bubble sort.

 

[Gary]

omg wtf i so

 

[mongoliantreesloth]

You could try posting this in the Whirlpool forums as well.

 

[Gnarkill]

Cheers guys, I've had success in removing the vacancies from the output, moving on to the sorting now.

 

[jhk67]

Finally something on this forum I understand