Re: add gridlines automatically to an openend xxx.html

From: Claude Allard (cbjma53_at_rogers.com)
Date: 11/29/04 

Date: Sun, 28 Nov 2004 22:34:18 -0500

David,
Thanks for the suggestion. The main problem with that method is that
the user has to do this. I'm looking for a way for Excel (or some other
process) to automatically do it for the user.

David McRitchie wrote:
> 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 *** 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
>>
>
>
>

Quantcast