A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

To Ian Thanks!



 
 
Thread Tools Display Modes
  #31  
Old September 30th, 2005, 01:19 PM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

Ross,
The problem's now solved.
We're back in action with our good computer and Eric has uploaded
MySongBuilder2.xls
to http://hanjohn.customer.netspace.net.au/

One other problem I've noticed when you do a transpose is when chords
are in adjacent cells and the chord on the left changes from a natural
to a sharp or flat. This chord is then partly obscured by the chord to
its right. I'm thinking about a macro that could be used to increase
the number of spaces between words in a line that suffers from this
problem so that chords can be spaced further apart to avoid their
overlapping.
Ken Johnson

  #32  
Old October 1st, 2005, 01:32 AM
Ross
external usenet poster
 
Posts: n/a
Default

Hey Ken,
Well, I tried to enter your address into Google Earth and found that I could
It would only accept "Roseville Australia" and give results. I tried
putting your street address in con****ion with the above numberous ways but
always got the message "your serach returned no results.
Is this --- http://www.ssor.net/pics/Roseville.jpg Roseville? If so I
found that, but I can't figure out how to find you.
Ross

Ross
hnson" wrote in message
oups.com...
Ross,
68 William Street, Roseville 2069. Maybe the postcode will make a
difference.
Thanks for the hyperlink tips. I noticed on yours that when the cursor
changes to the pointing finger the hyperlink address that appears
included C drive and I thought this could be a problem if the file is
being used on another machine at a different address. However, the
hyperlink that I inserted, following your instructions, used an address
that did not include the file's location, so I guess I needn't worry.
Ken Johnson



  #33  
Old October 1st, 2005, 02:38 AM
Ross
external usenet poster
 
Posts: n/a
Default

Firstly,
OK, you were right, those chords do work better -- couldn't quite follow what you meant with all of them, but anyway here is
(I just switched to rich format, so you should be able to go there from that link, but if not then http://ssor.net/Sheet/MySongbuilder2.xls )
I also added a little bonus material
1. My trained squirrel sings for you
2. a print macro button that prints the song out for you.

Ross
Ross
"Ken Johnson" wrote in message oups.com...
Ross,
The problem's now solved.
We're back in action with our good computer and Eric has uploaded
MySongBuilder2.xls
to http://hanjohn.customer.netspace.net.au/

One other problem I've noticed when you do a transpose is when chords
are in adjacent cells and the chord on the left changes from a natural
to a sharp or flat. This chord is then partly obscured by the chord to
its right. I'm thinking about a macro that could be used to increase
the number of spaces between words in a line that suffers from this
problem so that chords can be spaced further apart to avoid their
overlapping.
Ken Johnson

  #34  
Old October 1st, 2005, 02:53 AM
Ross
external usenet poster
 
Posts: n/a
Default

I just realized, that if you click on the link, it will open the songbuilder
on the web and you can hear the little bonus I sent by clicking where
prompted, but not without being prompted as to whether you want to save
songbuilder, because it is closing it to open your windows media file. Not
sure how to embed the mp3 in the excel file itself-I could only link to it..
If you want them to work together at home you will need to download both
files to the same directory the mp3 file at ht www.ssor/Sheet/ I guess you
figured out that ssor is Ross backwards, huh?
Ross

"Ross" wrote in message
...
Firstly,
OK, you were right, those chords do work better -- couldn't quite follow
what you meant with all of them, but anyway here is
(I just switched to rich format, so you should be able to go there from that
link, but if not then http://ssor.net/Sheet/MySongbuilder2.xls )
I also added a little bonus material
1. My trained squirrel sings for you
2. a print macro button that prints the song out for you.

Ross
Ross
"Ken Johnson" wrote in message
oups.com...
Ross,
The problem's now solved.
We're back in action with our good computer and Eric has uploaded
MySongBuilder2.xls
to http://hanjohn.customer.netspace.net.au/

One other problem I've noticed when you do a transpose is when chords
are in adjacent cells and the chord on the left changes from a natural
to a sharp or flat. This chord is then partly obscured by the chord to
its right. I'm thinking about a macro that could be used to increase
the number of spaces between words in a line that suffers from this
problem so that chords can be spaced further apart to avoid their
overlapping.
Ken Johnson


  #35  
Old October 1st, 2005, 08:28 AM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

Ross,
It was a bit of a fiddle, but I finally got your strained squirrel to
sing. Our possoms don't sound that good. I bet you made the Squirrel
sing button by copying the Print I Will button. They were both assigned
to the print I Will macro. I've since fixed that. You probably have
too.
I had to get the mp3 off your site. Did you make that site? I don't
know the first thing about web development.
I took your test and only got one wrong. I didn't know Spot's name. I
said Andy. I was thrown by Kung Fu Andy. Is Kung Fu Andy a real dog?
(Could do some harmonies with the squirrel)
I had a look at the eye page and have learnt something. I wrongly
thought that the fovea and macula were the same thing. I now know the
macula surrounds the fovea.
My late mother suffered from age related macula degeneration. She was
an avid reader. The talking books eased her boredom. Her younger
sister, who is still with us, developed the same symptoms and had
successful laser treatment. I'm seeing her and my cousin tomorrow.
Last night I finished the changes I mentioned in my last post. It's
available as Mysongmaker3 at the now usual place:

http://hanjohn.customer.netspace.net.au/

We've now got different versions coming out our ears.
I think the two new buttons are self explanatory. They only affect the
one selected lyric line. I thought it wouldn't be necessary to expand
all lyric lines, just those that have a lot of chord changes.
Another change I made is not realy visible but might prove to be
useful. Before I made this change, the cell range that was worked on by
the transpose and enharmonic macros was A4:Z100. I've extended the
width of this range out to the last visible column. It now might be
possible to fit the whole song on the visible part of the screen with
parts of the song side by side (no scrolling). I've also made it easy
to increase the number of rows in the working range. It is currently 97
rows (row4 to row100). Towards the top of the code in the transpose and
enharmonic macros the variable LastRow is currently made equal to 100.
Change this value to suit the circumstances.
Are you happy with the Chords/bold, Lyrics/regular aspect of the whole
thing. I'm pretty sure it can be done away with. I sometimes
unwittingly apply unnecessary conditions and I think that is the case
here. The chords/even rows, Lyrics/odd rows is enough for the code to
recognise what is what.
Your Google Earth snapshot does show where I live. I'll try to upload a
picture.
Ken Johnson

  #36  
Old October 1st, 2005, 08:40 AM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

Ssor,
Yes, I had.
I used to teach with a John Flanagan. Most of us called him Naganalf
because he was a bit of an incessant talker.
I used to teach a girl by the name of Roopi Kalsi, her name backwards
is a social comment that I used for inspiring students to work harder.
Nek Nosnhoj

  #37  
Old October 1st, 2005, 09:14 AM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

Ross,
I have successfully uploaded a word doc "I live here"
http://hanjohn.customer.netspace.net.au/
Ken Johnson

  #38  
Old October 1st, 2005, 03:33 PM
Ross
external usenet poster
 
Posts: n/a
Default

Hey Ken,
I sent you a nice long email, complete with pictures, but apparently, the
message list doesn't like it, because I don't see it posted. Could you send
me a normal email address that we can communicate with using our inboxes?
Ross
"Ken Johnson" wrote in message
oups.com...
Ross,
I have successfully uploaded a word doc "I live here"
http://hanjohn.customer.netspace.net.au/
Ken Johnson



  #39  
Old October 1st, 2005, 04:11 PM
Ken Johnson
external usenet poster
 
Posts: n/a
Default

Ross,
I used to use our main email address for Google Groups and the kids
recommended I use a Gmail account instead, so Gordon set one up for me.
I never bothered to check it for messages though, I wasn't sure how to.
I just asked Gordon about it and we've received five messages. I
haven't read them yet, but I did see the Google Earth shot with your
annotations plus one of a mass of puppies. I'm about to have a look now
on this older computer. Wish me luck.
Ken Johnson

  #40  
Old October 2nd, 2005, 02:30 AM
Ross
external usenet poster
 
Posts: n/a
Default

Ken,
I have sent a few emails at the account you gave me. Have you got them.
What email program are you useing? You are using outlook express right? If
not, why not? ARe you accessing your mail through the web? If that is the
way you are going, you should really try outllook express. It is one hundred
times easier and you have more control over what you are doing. Outlook
express comes packaged for free with internet explorer -- also free. Are
you using XP? With outlook express, each time it is loaded in a series of
frames appear, it opens up with folders in the left frame, a list of
messages in the top right frame and the currently selected message in the
bottom right frame. You can easily ad links to web pages and attach things
like excel files, so you don't have to upload them to the internet, you can
send them directly to me. You can add pictures and make the text scroll
around them. The fact the I.E. and I.E. express reamin to be free, never
ceases to amaze me. Besides the inbox, outbox, saved, deleted, and whatever
other folders you create yourself, through outlook express, you can join any
one of the bajillion newsgroups out there and that is how I access the Ecel
newsgroup, by just switching to that folder.

Ross
"Ken Johnson" wrote in message
oups.com...
Ross,
I used to use our main email address for Google Groups and the kids
recommended I use a Gmail account instead, so Gordon set one up for me.
I never bothered to check it for messages though, I wasn't sure how to.
I just asked Gordon about it and we've received five messages. I
haven't read them yet, but I did see the Google Earth shot with your
annotations plus one of a mass of puppies. I'm about to have a look now
on this older computer. Wish me luck.
Ken Johnson



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.