Re: add gridlines automatically to an openend xxx.html

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 11/29/04 

Date: Sun, 28 Nov 2004 19:31:00 -0500

Hi Claude,
I never use the builtin HTML but did you try using borders
instead of gridlines.
   Select cells (Ctrl+A), Format, cells, border, ...
   or use the toolbar icon for the formatting of selected cells. 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"claude allard" <cbjma.53.at@rogers.dot.com> wrote in message news:wvudnRlsVfCM9jfcRVn-1Q@rogers.com...
> Greetings,
> I have an html file that displays data in a table format.  I can open
> this file with Excel and it will display all the data in the proper
> format.  I would like to automatically apply grid lines to this data as
> I open the file.  The html file name will vary (generated by Webview
> table generating tool).  Is it possible to do this?  I have a macro that
> will apply the grid lines to the spread sheet but I have to go to
> tools/macro/VBE and then add the code and run it.  I have general users
> opening these html files with Excel and they just want to see the data
> with grid lines around it.
>
> Any help would be greatly appreciated.  TIA.
>
> Claude Allard
>

Relevant Pages

  • Re: Picture object retrieval in a word table
    ... would it be possible to parse the html file as follows: ... there will be other tags values in between but we can ignore ... >> each cells where there is an image perfectly. ...
    (microsoft.public.word.vba.general)
  • Re: Picture object retrieval in a word table
    ... would it be possible to parse the html file as follows: ... there will be other tags values in between but we can ignore ... >> each cells where there is an image perfectly. ...
    (microsoft.public.word.tables)
  • Re: Picture object retrieval in a word table
    ... would it be possible to parse the html file as follows: ... there will be other tags values in between but we can ignore ... >> each cells where there is an image perfectly. ...
    (microsoft.public.word.vba.beginners)
  • Re: Form results chopped off in EMail
    ... It save the data to an HTML file but not send it in an HTML based email message. ... >>> truncated when I use any format OTHER THAN Formatted ...
    (microsoft.public.frontpage.client)
  • Importing this data in to Excel in Text format
    ... Attached is a html file sent to me by a data service. ... I highlighted all the cells in my worksheet and formatted them as Text. ... Excel change the format I define for any cell at all. ...
    (microsoft.public.excel)