World: r3wp

Anyone have a source for some code that is supposed to generate prime 
numbers?  I'm curious what the standard formulas are for that.

You could take a look here:

http://www.scriptol.org/sieve.php#rebol

Thanks Sunanda.  I have worked with primes before and decided to 
revisit some work I did in the past and started a hunt for certain 
primes that exhibit a bit different behavior.  I found what I term 
as scalable primes.

I'm trying to find more and if there is other patterns.

Not just relevant to Christianity --->  http://www.nytimes.com/2008/07/06/world/middleeast/06stone.html?_r=1&partner=rssyahoo&emc=rss&oref=slogin

Paul, regarding primes, take a look in the Puzzles group at 17-Oct-2005 
and the Answers group from that date and a few days ahead.

The REBOLers Yahoo Fantasy football league has been made open for 
public participation.

http://football.fantasysports.yahoo.com/f1/78924

Anyone use REBOL with excel or Microsoft Exchange?

Just Excel.

Is there anyway to access an excel "cell" via REBOL and retrieve 
its contents?

I have to automate a process of retrieving contents of certain cells 
and comparing them to other cells and then emailing the information 
to persons found in certain cells.

Have you checked the Library? This might help:


http://www.rebol.org/cgi-bin/cgiwrap/rebol/ml-display-message.r?m=rmlLHMQ

I'll look into it.

thank.

Of course, it's no where near so difficult if you can export a CSV 
file from Excel first.

Actually, I find it not difficult at all with a tab-delimited text 
file but not sure I can get the file brought to me in that format 
and not sure if I can automate the conversion to that type.

I did an Excel automation dialect with Robert Muench a few years 
ago.

It was for Excel 9 I think.

Yeah I actually found that but it seems more tailored to creating 
excel spreadsheets wasn't it?  Maybe I misunderstood what it was.

Using the comlib allows you to access indivdual cells in an Excel 
spreadsheet

It was for programmatic control. You can read and write cells and 
ranges, etc.

Do keep in mind, recent copies of Excel "are" simply XML.

where is the comlib found at?

I just looked over comlib but looks like you gotta know comlib functions 
already and the documentation was a bit lacking for me.

I'll have to doublecheck tomorrow Reichart.

Where do I find COM commands or reference materials.  I know nothing 
about COM but want to try Anton's COMLIB stuff.

MSDN

ok. I see if I can find it there.

The main thing to remember is that the only thing you do with COM 
is tell other things to do stuff. Look to the developer's documentation 
for the things you want to do stuff.

I want to be able to read cells data from EXCEL.  Could I do that 
with COM?  I can't find a way to automate the conversion of excel 
spreadsheets to tab deliminated format so I think I gotta work directly 
with the spreadsheet data.  Which sucks.

I pitched the idea and now I gotta make it work.  LOL.

Yup, you can do that with COM. There are standalone conversion tools 
you can download that can do it too.

Yeah but I can only use REBOL - we can't introduce any software other 
than what we already have.  I see a ton of conversion mods out there 
but that wont  be allowed.

Can you use other scripting tools? Not that they would be better 
to use than REBOL in general, but COMLib may not be as good as a 
language with ActiveScripting support.

Good excuse to learn COMLib though :)

We have access to other scripting tools but not allowed on this project 
because I said I would only be using REBOL and the application (EXCEL)

I'm looking at MSDN in the COM section and browing thru - I look 
days away from learning how to do this.

Well, there you go. Look in MSDN in the Office API section.

Which version of Excel?

2003

Start here: http://msdn.microsoft.com/en-us/library/aa272254(office.11).aspx

I'll check it out.

Thanks Brian.

The VBA object model is the COM object model, just friendlier.

Ok, this is all GREEK to me at this point but checking into it.

Gotta go. Good luck!

Heh, thanks.

Brian, I got this code for VBA stuff: