testing Forum Tools downloaded today August 12, 2019
Results 1 to 9 of 9

Thread: testing Forum Tools downloaded today August 12, 2019

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default testing Forum Tools downloaded today August 12, 2019

    Looks perfect in the 'Preview Post'... Fingers crossed that it will look as good when I submit the post...


    Excel 2016 (Windows) 32 bit#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #B6AAA6">#E0E0F0 " />#E0E0F0 ;text-align: center;color: #201116">
    BCDE
    2Summary Analysis Grand Totals
    3
    4Total accommodation $ 7,910.23
    5Average per day $ 50.06
    6Average per day in Canadian $$ $ 66.09
    7
    8Total groceries $ 2,199.80
    9Total alcohol $ 935.65
    10Total pet food $ 471.64
    11Total dining out $ 1,189.87
    12Total golf $ 1,001.28
    13Total miscellaneous $ 2,788.38
    14
    15Total fuel $ 3,004.92
    16Total fuel in Canadian $$ $ 3,966.49

    #E0E0F0 ;color: #201116">totals



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #B6AAA6">#E0E0F0 ;color: #201116">
    CellFormula
    #E0E0F0 ;color: #201116">E4=SUM('2018'!I237,'2019'!I188,'2020'!I237,'2021'!I237)
    #E0E0F0 ;color: #201116">E5=SUM(E4/(DATEDIF('2018'!C2,'2018'!D2,"d")+DATEDIF('2019'!C2,'2019'!D2,"d")+DATEDIF('2020'!C2,'2020'!D2,"d")+DATEDIF('2021'!C2,'2021'!D2,"d")))
    #E0E0F0 ;color: #201116">E6=SUM(E5*AVERAGE(1.29,1.35))
    #E0E0F0 ;color: #201116">E8=SUM('2018'!I241,'2019'!I192,'2020'!I241,'2021'!I241)
    #E0E0F0 ;color: #201116">E9=SUM('2018'!I242,'2019'!I193,'2020'!I242,'2021'!I242)
    #E0E0F0 ;color: #201116">E10=SUM('2018'!I243,'2019'!I194,'2020'!I243,'2021'!I243)
    #E0E0F0 ;color: #201116">E11=SUM('2018'!I244,'2019'!I195,'2020'!I244,'2021'!I244)
    #E0E0F0 ;color: #201116">E12=SUM('2018'!I245,'2019'!I196,'2020'!I245,'2021'!I245)
    #E0E0F0 ;color: #201116">E13=SUM('2018'!I246,'2019'!I197,'2020'!I246,'2021'!I246)
    #E0E0F0 ;color: #201116">E15=SUM('2018'!I248,'2019'!I199,'2020'!I248,'2021'!I248)
    #E0E0F0 ;color: #201116">E16=SUM(E15*AVERAGE(1.29,1.35))


  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,950
    Post Thanks / Like
    Mentioned
    80 Post(s)
    Tagged
    18 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    I'm not an expert on Forum Tools, but that doesn't really look like the latest Forum Tools code to me.
    In any case, what about trying the MrExcel HTML Maker to see how that goes? It is quite similar to Forum Tools.

    Also, can you set up a sheet exactly like this and generate and post the Forum Tools code in this thread?
    When you preview your post, do you see the pink colour like in this screen shot?

    Excel 2016 (Windows) 32 bit
    A
    11
    22
    33
    46

    Sheet1



    Worksheet Formulas
    CellFormula
    A4=SUM(A1:A3)

    Last edited by Peter_SSs; Aug 13th, 2019 at 06:05 AM.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    As per your request. The color I am seeing is not light pink but a light blue(ish)/grey...

    Excel 2016 (Windows) 32 bit#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #B6AAA6">#E0E0F0 " />#E0E0F0 ;text-align: center;color: #201116">
    A
    11
    22
    33
    46

    #E0E0F0 ;color: #201116">Sheet1



    #FFFFFF " >
    Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #B6AAA6">#E0E0F0 ;color: #201116">
    CellFormula
    #E0E0F0 ;color: #201116">A4=SUM(A1:A3)


  4. #4
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    It did look perfect in the Preview. I will try using the HTML Maker as you suggested.

    Cheers!

  5. #5
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,950
    Post Thanks / Like
    Mentioned
    80 Post(s)
    Tagged
    18 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    Quote Originally Posted by leopardhawk View Post
    As per your request. The color I am seeing is not light pink but a light blue(ish)/grey...
    Then that would suggest to me that you haven't correctly removed an old version of Forum Tools.

    Here is the code behind your post

    <b>Excel 2016 (Windows) 32 bit</b><table cellpadding="2.5px" rules="all" style=";background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ;border: 1px solid;border-collapse: collapse; border-color: #B6AAA6"><colgroup><col width="25px" style="background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] " /><col /></colgroup><thead><tr style=" background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] ;text-align: center;color: #201116"><th></th><th>A</th></tr></thead><tbody><tr ><td style="color: #201116;text-align: center;">1</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #201116;text-align: center;">2</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: #201116;text-align: center;">3</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #201116;text-align: center;">4</td><td style="text-align: right;color: rgb(51, 51, 51);;">6</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #B6AAA6;border-top:none;text-align: center;background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] ;color: #201116">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] " ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ;border-collapse: collapse; border-color: #B6AAA6"><thead><tr style=" background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] ;color: #201116"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] ;color: #201116">A4</th><td style="text-align:left">=SUM(<font color="rgb(255">A1:A3</font>)</td></tr></tbody></table></td></tr></table><br />

    .. and here is the code behind mine.

    <b>Excel 2016 (Windows) 32 bit</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255, 255, 255);border: 1px solid;border-collapse: collapse; border-color: rgb(182, 170, 166)"><colgroup><col width="25px" style="background-color: rgb(240, 224, 224)" /><col /></colgroup><thead><tr style=" background-color: rgb(240, 224, 224);text-align: center;color: rgb(32, 17, 22)"><th></th><th>A</th></tr></thead><tbody><tr ><td style="color: rgb(32, 17, 22);text-align: center;">1</td><td style="text-align: right;background-color: rgb(255, 255, 0);;">1</td></tr><tr ><td style="color: rgb(32, 17, 22);text-align: center;">2</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: rgb(32, 17, 22);text-align: center;">3</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: rgb(32, 17, 22);text-align: center;">4</td><td style="text-align: right;;">6</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(182, 170, 166);border-top:none;text-align: center;background-color: rgb(240, 224, 224);color: rgb(32, 17, 22)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255, 255, 255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255, 255, 255);border-collapse: collapse; border-color: rgb(182, 170, 166)"><thead><tr style=" background-color: rgb(240, 224, 224);color: rgb(32, 17, 22)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(240, 224, 224);color: rgb(32, 17, 22)">A4</th><td style="text-align:left">=SUM(<font color="rgb(255">A1:A3</font>)</td></tr></tbody></table></td></tr></table><br />

    Notice all the FFFFFFF, B6AAA6 etc in yours versus the rgb(182, 170, 166), rgb(32, 17, 22) etc in mine. Changing how the colours were implemented is one of the things that changed in the latest version.
    Last edited by Peter_SSs; Aug 13th, 2019 at 10:09 AM.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  6. #6
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    This is with MrExcel HTML Maker... Preview looks good... submitting now.

    A
    11
    22
    33
    46

    Sheet1



    Worksheet Formulas
    CellFormula
    A4=SUM(A1:A3)


  7. #7
    Board Regular
    Join Date
    May 2007
    Location
    North Vancouver, BC, Canada
    Posts
    311
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    How would I go about removing an older version of Forum Tools? I may have used it years ago but can't recall. I thought the new version would overwrite any older versions anyway.

  8. #8
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,950
    Post Thanks / Like
    Mentioned
    80 Post(s)
    Tagged
    18 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    Quote Originally Posted by leopardhawk View Post
    How would I go about removing an older version of Forum Tools? I may have used it years ago but can't recall. I thought the new version would overwrite any older versions anyway.
    No, the new does not necessarily automatically over-write the old. For your first question, there is some help on that in this thread, otherwise I suggest trying some Googling.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  9. #9
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    307
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: testing Forum Tools downloaded today August 12, 2019

    Testing

    Code:
    Dim rngWhole As Range, vGrid As Variant, vWBnms As Variant, vWSnms As Variant    Dim strOutput As String
        Dim objData As DataObject
        Dim rngFormulas As Range, rngTemp As Range, ar As Range
        Dim lngRows As Long
        Dim blnHasNames As Boolean
        Dim i As Long
        Dim FormulasToParse As String
    Sam_D_Ben

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •