A very kind soul did up an XL2K sheet which is incredibly fabulous. It was
a gift to our group and so I feel I can't go back and ask for more in terms
of what it will generate. This file is really kewl. You enter a quotation,
etc., into the box and it generates a word puzzle called a Quotefall.

The difficulty lies in the solution grid since one has to do it manually and
that is surprisingly time-consuming. Last night, it actually took me 25
minutes to get the letters placed just so because after each time I'd be
part-way through typing in the individual letters for the solution, I'd see
that the placement of the original quotation needed adjusting so would have
to fix the quote and re-generate the puzzle which would mean having to start
all over re-typing in the solution.

Since it so easily generates the puzzle was hoping someone would know how to
fix this file so that a solution grid could also be generated.

I know it is a lot to ask but I know my limitations and this is too far
advanced for me. So I thought I'd ask.

I'm in the process of setting up a website for free Stargate word puzzles
and Quotefalls will be one type that I'll create.

So if anyone is interested in this small challenge, pls go here for the
Excel file.

http://www.angelfire.com/art2/hypati...uotefalls.html



The direct links are these --
The XLT file:
http://www.angelfire.com/art2/hypati...sGenerator.xlt

Puzzle in 10k GIF format:
http://www.angelfire.com/art2/hypati...rgate_01_p.gif

Solution I did up manually in another 10k GIF file:
http://www.angelfire.com/art2/hypati...argate_01a.gif
This is what I hope can be added to the coding (on another button maybe?) so
that it generates the same puzzle but filled in. In other words, so that it
dumps the same quotation in the boxes that the original puzzle show. Hope
that's clear (?).

Thanks so much in advance for anyone's help. I know it's an imposition but
I don't know anyone who can do this. And I thought someone might get a kick
out of doing this <g.

I'll give full credit at all times to those who helped and who'd like me to
do so. Cheers. :oD

A very kind soul did up an XL2K sheet which is incredibly fabulous.
It was a gift to our group and so I feel I can't go back and ask for
more in terms of what it will generate. This file is really kewl.
You enter a quotation, etc., into the box and it generates a word
puzzle called a Quotefall.

The difficulty lies in the solution grid since one has to do it
manually and that is surprisingly time-consuming. Last night, it
actually took me 25 minutes to get the letters placed just so because
after each time I'd be part-way through typing in the individual
letters for the solution, I'd see that the placement of the original
quotation needed adjusting so would have to fix the quote and
re-generate the puzzle which would mean having to start all over
re-typing in the solution.

Since it so easily generates the puzzle was hoping someone would know
how to fix this file so that a solution grid could also be generated.

I know it is a lot to ask but I know my limitations and this is too
far advanced for me. So I thought I'd ask.

I'm in the process of setting up a website for free Stargate word
puzzles and Quotefalls will be one type that I'll create.

So if anyone is interested in this small challenge, pls go here for
the Excel file.

http://www.angelfire.com/art2/hypati...uotefalls.html

The direct links are these --
The XLT file:
http://www.angelfire.com/art2/hypati...sGenerator.xlt

Puzzle in 10k GIF format:
http://www.angelfire.com/art2/hypati...rgate_01_p.gif

Solution I did up manually in another 10k GIF file:
http://www.angelfire.com/art2/hypati...argate_01a.gif
This is what I hope can be added to the coding (on another button
maybe?) so that it generates the same puzzle but filled in. In other
words, so that it dumps the same quotation in the boxes that the
original puzzle show. Hope that's clear (?).

Thanks so much in advance for anyone's help. I know it's an
imposition but I don't know anyone who can do this. And I thought
someone might get a kick out of doing this <g.

I'll give full credit at all times to those who helped and who'd like
me to do so. Cheers. :oD

So, basically you want a "cheat" routine that fills in the puzzle ?

NickHK

"StargateFanFromWork" wrote in message
...
A very kind soul did up an XL2K sheet which is incredibly fabulous. It
was
a gift to our group and so I feel I can't go back and ask for more in
terms
of what it will generate. This file is really kewl. You enter a
quotation,
etc., into the box and it generates a word puzzle called a Quotefall.

The difficulty lies in the solution grid since one has to do it manually
and
that is surprisingly time-consuming. Last night, it actually took me 25
minutes to get the letters placed just so because after each time I'd be
part-way through typing in the individual letters for the solution, I'd
see
that the placement of the original quotation needed adjusting so would
have
to fix the quote and re-generate the puzzle which would mean having to
start
all over re-typing in the solution.

Since it so easily generates the puzzle was hoping someone would know how
to
fix this file so that a solution grid could also be generated.

I know it is a lot to ask but I know my limitations and this is too far
advanced for me. So I thought I'd ask.

I'm in the process of setting up a website for free Stargate word puzzles
and Quotefalls will be one type that I'll create.

So if anyone is interested in this small challenge, pls go here for the
Excel file.

http://www.angelfire.com/art2/hypati...uotefalls.html



The direct links are these --
The XLT file:

http://www.angelfire.com/art2/hypati...sGenerator.xlt

Puzzle in 10k GIF format:

http://www.angelfire.com/art2/hypati...rgate_01_p.gif

Solution I did up manually in another 10k GIF file:

http://www.angelfire.com/art2/hypati...argate_01a.gif
This is what I hope can be added to the coding (on another button maybe?)
so
that it generates the same puzzle but filled in. In other words, so that
it
dumps the same quotation in the boxes that the original puzzle show. Hope
that's clear (?).

Thanks so much in advance for anyone's help. I know it's an imposition
but
I don't know anyone who can do this. And I thought someone might get a
kick
out of doing this <g.

I'll give full credit at all times to those who helped and who'd like me
to
do so. Cheers. :oD

"NickHK" wrote in message
...

So, basically you want a "cheat" routine that fills in the puzzle ?

Yes, that's it! That way, the solution would be easy to generate, too.
See, I can't tell easily if the puzzle follows the right rules until I've
typed the solution letters in. So like what happened the other day, it took
me about 9 tries before the finished puzzle was right and that took about 25
mins which would take only a minute or two with the vb coding. Here's the
type of thing that happens:

- there must be a black box between words, so sometimes one inadvertently
has one word on one line to the end, and the next word begins on the next
line with no space. The puzzler doesn't know there are actually two words
without that black box. I miss the odd one until I actually type up the
solution manually each time.

- or, after generating and then typing in solution I see that I should shift
the words around for a better jumble of letters.

- I've put in extra spaces between words sometimes, which again I don't
seem to catch till typing up the solution and then have to re-generate the
puzzle again.

All the above plus the time it actually takes to type in the letters mean
that it takes a heck of lot longer than desired to actually create a puzzle
<g.

.................................................. ...........................
.......................................
However, there is one thing I'm not sure of -- is the that is puzzle
generated each time the same if the text isn't changed? I'd have to test
that. So what occurred to me today to worry about is if it's wise to
generate a puzzle then to generate a solution since they might not
correspond. Perhaps something simpler, though manual would be better (and
would be easier to code):

To modify this quotefalls generator's code to at the same time dump the
correct letters down into right boxes rather than leaving the boxes blank.
So it would jumble up the letters at the top as per normal, but would put
the solution down below at the same time. Then I'd save the entire thing
like this as the solution and then could delete the solution letters and
save that to bitmap and that would be the puzzle. _That_ deletion code is
something I believe I could do because I'd just record the keystrokes. So
that part is okay <g.

Anyway, though the rest of the vb in this file that would need modifying is
way beyond my limited abilities, I hope that - it seems that in theory at
least - it might not be too difficult (?). Well, here's hoping that it's
something someone wouldn't mind playing with. <g

Thanks. :oD

NickHK

"StargateFanFromWork" wrote in message
...
A very kind soul did up an XL2K sheet which is incredibly fabulous. It
was
a gift to our group and so I feel I can't go back and ask for more in
terms
of what it will generate. This file is really kewl. You enter a
quotation,
etc., into the box and it generates a word puzzle called a Quotefall.

The difficulty lies in the solution grid since one has to do it manually
and
that is surprisingly time-consuming. Last night, it actually took me 25
minutes to get the letters placed just so because after each time I'd be
part-way through typing in the individual letters for the solution, I'd
see
that the placement of the original quotation needed adjusting so would
have
to fix the quote and re-generate the puzzle which would mean having to
start
all over re-typing in the solution.

Since it so easily generates the puzzle was hoping someone would know
how
to
fix this file so that a solution grid could also be generated.

I know it is a lot to ask but I know my limitations and this is too far
advanced for me. So I thought I'd ask.

I'm in the process of setting up a website for free Stargate word
puzzles
and Quotefalls will be one type that I'll create.

So if anyone is interested in this small challenge, pls go here for the
Excel file.

http://www.angelfire.com/art2/hypati...uotefalls.html



The direct links are these --
The XLT file:


http://www.angelfire.com/art2/hypati...sGenerator.xlt

Puzzle in 10k GIF format:


http://www.angelfire.com/art2/hypati...rgate_01_p.gif

Solution I did up manually in another 10k GIF file:


http://www.angelfire.com/art2/hypati...argate_01a.gif
This is what I hope can be added to the coding (on another button
maybe?)
so
that it generates the same puzzle but filled in. In other words, so
that
it
dumps the same quotation in the boxes that the original puzzle show.
Hope
that's clear (?).

Thanks so much in advance for anyone's help. I know it's an imposition
but
I don't know anyone who can do this. And I thought someone might get a
kick
out of doing this <g.

I'll give full credit at all times to those who helped and who'd like me
to
do so. Cheers. :oD

A very kind soul did up an XL2K sheet which is incredibly fabulous.
It was a gift to our group and so I feel I can't go back and ask for
more in terms of what it will generate. This file is really kewl.
You enter a quotation, etc., into the box and it generates a word
puzzle called a Quotefall.

The difficulty lies in the solution grid since one has to do it
manually and that is surprisingly time-consuming. Last night, it
actually took me 25 minutes to get the letters placed just so because
after each time I'd be part-way through typing in the individual
letters for the solution, I'd see that the placement of the original
quotation needed adjusting so would have to fix the quote and
re-generate the puzzle which would mean having to start all over
re-typing in the solution.

Since it so easily generates the puzzle was hoping someone would know
how to fix this file so that a solution grid could also be generated.

I know it is a lot to ask but I know my limitations and this is too
far advanced for me. So I thought I'd ask.

I'm in the process of setting up a website for free Stargate word
puzzles and Quotefalls will be one type that I'll create.

So if anyone is interested in this small challenge, pls go here for
the Excel file.

http://www.angelfire.com/art2/hypati...uotefalls.html

The direct links are these --
The XLT file:
http://www.angelfire.com/art2/hypati...sGenerator.xlt

Puzzle in 10k GIF format:
http://www.angelfire.com/art2/hypati...rgate_01_p.gif

Solution I did up manually in another 10k GIF file:
http://www.angelfire.com/art2/hypati...argate_01a.gif
This is what I hope can be added to the coding (on another button
maybe?) so that it generates the same puzzle but filled in. In other
words, so that it dumps the same quotation in the boxes that the
original puzzle show. Hope that's clear (?).

Thanks so much in advance for anyone's help. I know it's an
imposition but I don't know anyone who can do this. And I thought
someone might get a kick out of doing this <g.

I'll give full credit at all times to those who helped and who'd like
me to do so. Cheers. :oD