Html Excel question.

[SirFrank]

I know some Html but not Excel. Can anyone answer this for a U.S. Army soldier overseas.

I have a very large excel list that must be referenced frequently. So I made it html and put a find in page Java script in it. But when I email it to my colleges it does not work for them. Is there a solution?

Thanks Guys!!

[DocEvi1]

I'm not sure why you are telling us you're a "U.S. Army soldier", it makes no difference to me who you are...

I'm presuming you've simply saved the Excel document as a HTML document? Open it up and have a look at the code and try and recognise most of the tags - suffice to say MS Office stuff makes HTML very, very badly!

The solution is to copy the Excel data into WordPad and then into FrontPage (I'm assuming you have this)... that way you get much cleaner code...

What are you requiring "javascript" to do? and why can't you just send the excel doc?

[bassman]

Select the whole table (Edit menu -> Select All or Ctrl+A), hit copy (Ctrl+C) and paste all of it into a new page in Frontpage. Save that HTML page (the one you created on Frontpage) and either put it online or send it by e-mail (Winzip will help on this later option).

[DocEvi1]

bassman if you do that, Frontpage will put a **** load of it's own tags & style sheet type stuff in - much better to go via something like WordPad.

[bassman]

I know that, I was aiming at simplicity :)

[SirFrank]

I'm not sure why you are telling us you're a "U.S. Army soldier"
Its not me Doc. I just made a Statement who it was for.
I think your statement about the Ms Office making bad Html says it all.
I have no Idea about the Java script he used. He originally sent the the Excel Doc
but some couldnt bring it up. I think thats because of Different Versions of Excell.
Thanks again Doc and Bassman!:t

[bassman]

Originally posted by SirFrank
but some couldnt bring it up. I think thats because of Different Versions of Excell.
Will they be interested in what the Excel table contains or on the HTML code that the webpage may contain?

Anyway, you can use Excel's Save As option to save the document in a format eveyrone can read.

[ScaryBinary]

Originally posted by bassman
Will they be interested in what the Excel table contains or on the HTML code that the webpage may contain?

Anyway, you can use Excel's Save As option to save the document in a format eveyrone can read.

Ya, I don't get why you're converting it to HTML in the first place. Excel has a "Find" feature. If your buddies don't have the full-blown Excel program, they can download an Excel viewer from Microsoft (http://www.microsoft.com/downloads/results.aspx?productID=&freetext=Excel+Viewer&DisplayLang=en) (for free) or you can save the file as a comma-separated list or something that anyone with Textpad (or other basic text editor) can read.

On a side note, I've never used the Excel Viewer...I don't know if it has the "Find" feature or not, if that's a must.