RotoGuru Hockey Forum
| 0 |
Subject: HTML Lessons???? Posted by: J - [2908318] Mon, Jan 31, 13:54 OK, so I am possibly (although I doubt it) the only here who knows nothing about html.... If anyone gets some time (not necessarily anytime REAL soon) can someone teach us (me?) how to go from the standings I post now (straight cut and paste from excel) to the html type standings that are so much nicer!!!!. Hint - I know NOTHING, and I mean NOTHING about html. Then again I knew NOTHING about macros until Richard & QB and the gang came along!!! So there is definitly hope for me yet!!! Thanks! J | |||||||||||||||||||
| 1 | philliephan ID: 1607316 Mon, Jan 31, 14:45 | I was going to try to post something, but all HTML just gets interpreted so I can't show you what to do here. I will try to email you something tonight. | ||||||||||||||||||
| 2 | Code Cracker ID: 420183110 Mon, Jan 31, 14:54 | What version of Excel are you using?
You may be able to simplify the creation of a table if you have Excel 97 or 2000. | ||||||||||||||||||
| 3 | J ID: 470183114 Mon, Jan 31, 15:16 | I have excel 97, I think my problem may be is that I cant get the "Save as html" thing in excel. I tried the help function and it was telling me to click on "add-ons" so is it possible that the way excel was installed on my computer that it cant be done?????
I dont know | ||||||||||||||||||
| 4 | Frank p ID: 4050293 Mon, Jan 31, 15:23 | J, I'm with you. I did learn a little about HTML last semester but I seem to have forgotten it.
I would like to know how to include a photo that will link to another site or just put in a regular link. | ||||||||||||||||||
| 5 | Code Cracker ID: 420183110 Mon, Jan 31, 15:26 | You need the Web Connectivity Kit for Excel to be able to do this.
Go to http://officeupdate.microsoft.com/downloaddetails/webcnkit.htm and download the web connectivity kit. Then a menu item called 'Save as HTML' will appear under your File menu in Excel and you can save stuff in tables automatically. Or you can cut and paste by hand. This will require some knowledge of html to do this. This is probably what philliephan is referring to. Let me know if you download the kit and I can help you with it. | ||||||||||||||||||
| 6 | Code Cracker ID: 420183110 Mon, Jan 31, 15:40 | Images are not hard. They go something like this:
IMG SRC="http://www.webhostme.com/images/bbuggyani.gif" Just add a less than sign to the left of IMG and a greater than sign at the end and a bee should appear. Just substitute your web address where the image is in the place where it says src above. You can also add width and height parameters to size the image. I'll put the image below to see if it works:  | ||||||||||||||||||
| 7 | J ID: 470183114 Mon, Jan 31, 15:44 | I downloaded the kit, I can read that document that comes with it, but I'm not sure how I get it hooked up with excel... | ||||||||||||||||||
| 8 | Code Cracker ID: 420183110 Mon, Jan 31, 15:47 | OK, there should be a file called webcnkit.exe that you saved somewhere on your pc. Find that file and double click it and it will install everything that you need.
Then start excel again and to to Tools, Add-Ins and there should appear several items that can be installed. Choose Internet Assistant Wizard. | ||||||||||||||||||
| 9 | Mario LeMoose ID: 520543115 Mon, Jan 31, 15:54 |  | ||||||||||||||||||
| 10 | Code Cracker ID: 420183110 Mon, Jan 31, 15:56 | Mario, it's you!
You should put that on all your posts. | ||||||||||||||||||
| 11 | J ID: 2908318 Mon, Jan 31, 16:07 | I went to tools...add-Ins, but everything in there is the same as before...no sign of internet assistant wizard. Is there a certain spot I need to install that file into???? | ||||||||||||||||||
| 12 | Code Cracker ID: 420183110 Mon, Jan 31, 16:08 | J, I've got to leave now but I'll be back later tonight if you have any questions.
| ||||||||||||||||||
| 13 | Code Cracker ID: 420183110 Mon, Jan 31, 16:10 | Did you exit out of excel and restart it? | ||||||||||||||||||
| 14 | J ID: 2908318 Mon, Jan 31, 16:12 | yep, even restarted the whole computer...we can pick this up tomorrow or whenever, I'm in no real rush. | ||||||||||||||||||
| 15 | philliephan ID: 59072820 Mon, Jan 31, 16:12 | J, I sent you an email, to your hotmail account let me know if don't receive it. | ||||||||||||||||||
| 16 | J ID: 2908318 Mon, Jan 31, 16:17 | ok, I got it, time to go play, thanks p-phan, hopefully this will get me on my way!!!! | ||||||||||||||||||
| 17 | Code Cracker ID: 420183110 Mon, Jan 31, 16:20 | J
Look in c:\Program Files\Microsoft Office\Office\Library directory for a file called html.xla. If you don't have it, I can send it to you. If you do have it then select Add-Ins again and browse for this file. | ||||||||||||||||||
| 18 | Matt S ID: 43043290 Mon, Jan 31, 16:20 |
woohoo!! | ||||||||||||||||||
| 19 | Richard ID: 36024318 Mon, Jan 31, 16:24 | Oh, Mario LeMoose - I never knew that you were such a cutie. Where did you ever get tha animated picture. LOL ROFL PIMP
Richard | ||||||||||||||||||
| 20 | J ID: 470183114 Mon, Jan 31, 16:30 | I dont have that file Code Cracker!!
Thanks alot for all your help by the way! | ||||||||||||||||||
| 21 | Code Cracker ID: 5002298 Mon, Jan 31, 19:18 | J - I sent you the file. | ||||||||||||||||||
| 22 | Frank p ID: 4050293 Tue, Feb 01, 01:16 | I still can't get the image. I seem to have forgotten everything. Oh well :( | ||||||||||||||||||
| 23 | Teddy ID: 32032294 Tue, Feb 01, 02:46 | Testing....
Watch out......Ooooops!!! Teddy | ||||||||||||||||||
| 24 | Willix ID: 20010319 Tue, Feb 01, 15:59 | OK, forget the damn basketball boards!! I'm missing out on good stuff over here on the hockey boards.
J, I'm in the same boat as you, but probably know even less. Gary started teaching us (me) html during baseball last year on the baseball boards. I need to revisit the lessons I printed out. The pictures are cool guys. Are you referencing the pictures when you type your response on the message boards, or do you type it in excel or notepad then copy and paste it to the message boards? This is much more fun than the basketball boards! And Walk if you're over here, what's going on old friend? Can't wait for baseball to start to see some of you guys again! Thanks for the html help in advance! Willix | ||||||||||||||||||
| 25 | Matt S ID: 43043290 Tue, Feb 01, 16:25 | When you find an image you want to put on, you copy the address you got it from, put it in IMG SRC="web adress here" with < > around the beginning and the end. I just took a look at Gary's lessons again too. I keep learning.
 | ||||||||||||||||||
| 26 | Team AA ID: 140202921 Tue, Feb 01, 16:35 | J & Willix & Frank p
I think the Netscape homepage and probably microsoft have web sites that can teach you some basic html. I had a class that taught me a little bit frosh year and if you can get the basics down you can try viewing the html souce on some pages and can see some of the stuff in action. I know that some people would say this is the hard way, but it's fun to learn how to build a web page from the ground up. I don't know the copy write laws regarding websites, but a little cut and paste goes a long way. All you need to learn are a few tags and you should be good to go. Maybe if I've got some time later I'll play around with some myself. But it's really easy- I used it to hand-write a website after 3 years. Just takes a little time. | ||||||||||||||||||
| 27 | Willix ID: 20010319 Tue, Feb 01, 16:52 |
Something like this? OK, so I just copied the line from above and pasted down here. If I go to a web page, can I post any picture I want, and how do you differentiate between a lot of pictures on one page? Cool stuff though. It actaully works! | ||||||||||||||||||
| 28 | Matt S ID: 43043290 Tue, Feb 01, 17:00 | I copied a whole bunch of these things from assorted sites, to a directory in my C drive. I then uploaded them all to pages at geocites that I created. | ||||||||||||||||||
| 29 | Willix ID: 20010319 Tue, Feb 01, 17:07 | That's what I figured Matt S. I was in the process of doing that now, but I will need help I can see already.
| ||||||||||||||||||
| 30 | Harkonnon ID: 40048295 Tue, Feb 01, 17:15 | Matt S
do I have to upload the pix somewhere or can I take them from my Computer directly ?? | ||||||||||||||||||
| 31 | Matt S ID: 43043290 Tue, Feb 01, 18:41 | To put the pics here, they have to come from a website. Putting "C:\gifs\dollar.gif" will result in a broken link. I learned that yesterday....
I feel so smrt. | ||||||||||||||||||
| 32 | walk ID: 13051316 Wed, Feb 02, 12:08 | Willix! Nice bee. What cool stuff, fellers!
- walk | ||||||||||||||||||
| 33 | Willix ID: 20010319 Wed, Feb 02, 13:39 | Hey Walk my man! Wait until I learn how to get the "good" pictures here! ;-)
Willix | ||||||||||||||||||
| 34 | Code Cracker ID: 420183110 Wed, Feb 02, 14:32 | Yeah!We're Number | ||||||||||||||||||
| 35 | J ID: 470183114 Wed, Feb 02, 14:36 | quick question---> how do you center the cells in the tables, or right align them????? | ||||||||||||||||||
| 36 | Code Cracker ID: 420183110 Wed, Feb 02, 14:41 | In a table you have cells designated by TD statements.
inside the TD you can specify alignment with the align keyword. So to center inside the cell you would say align=center To right align you would say align=right etc. Hope this helps | ||||||||||||||||||
| 37 | walk ID: 13051316 Wed, Feb 02, 14:51 | That code cracker sure is #1. He's kicking butt in the late season standings.
- walk | ||||||||||||||||||
| 38 | J ID: 470183114 Wed, Feb 02, 14:52 |
what am i doing wrong???? | ||||||||||||||||||
| 39 | Code Cracker ID: 420183110 Wed, Feb 02, 14:59 | To center the $$$ heading you would say:
ltTD align="center"gt$$$lt/TDgt I am using lt to mean the less than sign, <. I am using gt to mean the greater than sign, >. | ||||||||||||||||||
| 40 | Code Cracker ID: 420183110 Wed, Feb 02, 15:05 | If I actually put the statement that you should use in my message then the system will take it to mean an actual cell in a table and the code will not show up in the message window.
I have to use substitution in order for you to see the statements. | ||||||||||||||||||
| 41 | J ID: 470183114 Wed, Feb 02, 15:09 |
sweet!!! | ||||||||||||||||||
| 42 | Code Cracker ID: 420183110 Wed, Feb 02, 15:09 | J, I viewed the code that you sent in your message and you are not putting the align=center inside the TD statement.
align=center should go between the less than sign and before the greater than sign. You want me to send you some example code via email? | ||||||||||||||||||
| 43 | J ID: 470183114 Wed, Feb 02, 15:10 | now I just need some time to really play with this new toy we've got!!!!!!! | ||||||||||||||||||
| 44 | Code Cracker ID: 420183110 Wed, Feb 02, 15:12 | I think you've got it.
Walk, I'm expecting you to catch me before long. | ||||||||||||||||||
| 45 | J ID: 470183114 Wed, Feb 02, 15:13 | Thanks alot CC!!!!!! | ||||||||||||||||||
| 46 | Harkonnon ID: 40048295 Wed, Feb 02, 15:32 | Code Cracker how about that?
Damn still a lot of spacing ! Where is the fault ? | ||||||||||||||||||
| 47 | J ID: 470183114 Wed, Feb 02, 15:35 | Troublemaker!!!!!!!! | ||||||||||||||||||
| 48 | Harkonnon ID: 40048295 Wed, Feb 02, 15:38 | Sorry what happened that showed up quite normal in my preview !!!
:-((( Shame on me !!! | ||||||||||||||||||
| 49 | Code Cracker ID: 420183110 Wed, Feb 02, 15:45 | Hark - How did you get 444 trades left?
Or is that just an optical illusion? | ||||||||||||||||||
| 50 | Harkonnon ID: 40048295 Wed, Feb 02, 15:49 | I had some 1000 but I used them up to get 560 million roster ? ;-)))
I hope I caused no serious damage here !!! | ||||||||||||||||||
| 51 | Yohan ID: 50543112 Wed, Feb 02, 16:49 | Alright, can anyone give me some simple and easy instructions on how to use this html thing. I have NO idea how it works. I do have excel 97, if that helps. I've read this thread 3 times and iu still don't get it. I feel left out, please someone help. | ||||||||||||||||||
| 52 | J ID: 470183114 Wed, Feb 02, 16:54 | I'm gonna start a new thread, so we can stop posting to this one thanks to Mr. Harkonator!!!!
;) | ||||||||||||||||||
| 54 | philliephan ID: 36120218 Wed, Feb 02, 19:23 | Be sure to close all your tables! | ||||||||||||||||||
| 55 | Harkonnon ID: 40048295 Wed, Feb 02, 19:40 | You mean i should have put END in here and it would be ok ??
!-- "stats breakdown" table-- | ||||||||||||||||||
| 56 | philliephan ID: 36120218 Wed, Feb 02, 20:04 | I think you missed a [/TABLE] (except <> instead of [] around it. That might not be the only problem put that is a least part of it. | ||||||||||||||||||
| 57 | Frogger ID: 290152921 Sat, Feb 05, 16:47 | IMG SRC="http://www.webhostme.com/images/bbuggyani.gif"
| ||||||||||||||||||
| 58 | Frogger ID: 290152921 Sat, Feb 05, 16:50 | -IMG SRC="http://www.webhostme.com/images/bbuggyani.gif"+
How embarassing!! I bet I screwed up again | ||||||||||||||||||
| 59 | aiko aiko ID: 300233112 Sat, Feb 05, 16:53 | make sure you put a less than sign in front of img and a greater than sign at the end.
if you want the frog image, right click on it and it will give you the url address.  | ||||||||||||||||||
| 60 | QB ID: 52047292 Sat, Feb 05, 19:16 | I fixed everything that was wrong here... keep having fun
QB | ||||||||||||||||||
| 61 | Richard ID: 400372821 Sat, Feb 05, 19:28 | Okay - I guess I'll add one to the collection. Since my girls love to ride horses, here's my cute animation:
Richard | ||||||||||||||||||
| 62 | Harkonnon ID: 40048295 Sat, Feb 05, 20:44 | I'm watchin you dudes
| ||||||||||||||||||
| ||||||||||||||||||||
Post a reply to this message: | ||||||||||||||||||||