+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 24 of 24

Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

  1. #16
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    14,546

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    Hi Alan.

    I use I.E. 11 (version 11.0.16) with Compatibility View set to on.

    In Post #8 I see two screen shots of the rogue EF site, along with a bit of writing by you.

    In Post #12 I see some HTML code, then a screen shot (the .jpeg image), but for the .png image I only see a place-holder. As Kyle reported in your earlier thread, .jpegs seem okay but .png files are usually just showing the placeholder - this has happened since about August last year, and a few other problems also started then (like not being able to use the enhanced file uploader). I think it also depends on how the image has been uploaded to the site.

    I generally do not post images - on the few occasions that I have, I have used .jpegs or .pdf files. As for others who do post .png files (usually screen shots), I can only assume that the tools they use to get those files default to .png types.

    I've attached a file that I have occasionally used to try to discourage the posting of images, with the response "please see attached".

    Hope this helps.

    Pete
    Attached Files Attached Files

  2. #17
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    Quote Originally Posted by Pete_UK View Post
    Hi Alan.

    I use …..

    In Post #8 I see ……

    In Post #12 I see ………

    Pete
    Thanks Pete for all the info
    .. Ties up generally with what I have been reading. Helps to clarify the general “picture” (if you forgive the pun ) of the situation. . Much appreciated.
    .
    . I see exactly as you do on some of my computers, so that means I can’t see the last “.png” from Post #12. On a few computers I “get lucky” and see all 4 Images….(2 from post #8 + 2 from post #12)
    .
    . So looking at Post # 8, second Image.:…. That may give a roundabout way to get a “.png” to come up in Excel Forum Threads when using IE 11. But it involves getting that IMG shown in the HTML code. That means having to use a free Uploading site with all the extra work and bombardment with ads that that entails. So no great use I guess - You could just as well do a quick conversion from “.png” to “.jpeg”…

    . Thanks again
    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  3. #18
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    . Hi.
    . An Add-In which does BB Code screen shot was discussed in some length in a very long Thread:
    http://www.excelforum.com/suggestion...-and-data.html
    To
    http://www.excelforum.com/suggestion...d-data-14.html
    …… one outcome from this was an “ all in one” Forum Screen Shot Tool. I reference it in my signature and use it extensively. – Here the current version as of July 2015
    https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0

    Here are some versions of mine with minor modifications to the original
    https://app.box.com/s/oa1zouz1ksm68yevndee6yi1v1o0qmmm
    https://app.box.com/s/7v5no8t18qqzjwyfqtv1xo5elsyba3o6
    https://app.box.com/s/boxjrj2wmlren3tgqqnamzxknnpwyaut

    …. I wrote some „Beginners type” Notes on how to get these Add-Ins working, referenced in my signature, again here the link:
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    . I am sure many Regulars do not need those notes, but possibly beginners like me wishing to use the Add-In may find them useful. Here they are given again below - Appologies that the images are in German. Hopefully the Pictures are still helpful in confirming the steps

    (. The Tool is discussed from time to time in the test Area Sub Forum an ExcelForum, most recently:
    http://www.excelforum.com/developmen...6398-test.html
    .. )
    Alan

    .....................................................................

    Notes on Typical Download procedure for Forum Tool “Add – Ins” (such as Code copying or Spreadsheet Range “Screen Shots”)

    .-- Just general “average” procedures. May vary a bit from add-in to add-in

    . R1) Usually you are given a link. There are lots of them about recently…Where the link it goes and how many things are there can vary from time to time

    . R2) Try to read through as much information given at least once quickly complete. Usually it is worth it in the long run. Maybe copy a few parts of instructions to a text or Word File – can come in handy if any instructions vanish as you start downloading.

    . R3) Be careful exactly wot you check or need to uncheck in any boxes when options are given.

    ForExample ( XL 2007 2010 Windows Vista (also for mac) ) Rory Download:

    . R3a). Here: -
    http://excelmatters.com/

    . R3b). Here: - (Here is probably best to check out updates / versions etc. --see bottom of the page (Win & Mac).)
    http://excelmatters.com/excel-forums/

    . R3c). And / OR
    (Here also direct without the other two)
    https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0


    http://i1065.photobucket.com/albums/...pstkjztxiu.jpg



    . R4). - Download and Save. (Preferably in something like ……..\Microsoft\AddIns if you can find that Folder####. If not save anywhere initially and make a note of where). If the file is “zipped”, it is sometimes a good idea to “unzip it”. Often that just means open the Zipped folder and then maybe make a copy of the add-in file in that is in the Zipped Folder. Paste the copy somewhere, such as where the Zipped File ended up.

    . R5). – Open Excel if not already. It may or may not be better to have Excel already open. Can vary from download, I think.

    . R6) – Click somewhere left upper (i.e. Vista XL 2007 Office button ; Vista XL 2010 First Tab in Ribbon (Datei or Data or File))

    . R7) – Look for, or scroll down to, Excel Options – Click

    . R8) - Click add-ins shown in a list to the left in the Excel-Option Window



    http://i1065.photobucket.com/albums/...psrvtc9u3c.jpg


    . R9) ..This is Bit tricky to explain.. – “invoke the Add-in's dialog Box Window” i.e.
    . - R9a) Usually somewhere near middle bottom of the Excel-Option Window is drop down box. To the right of that box is another box with something like “Go To” written on it.



    http://i1065.photobucket.com/albums/...pstpyzs09o.jpg


    Click that.

    . - R9b) You should have the Add-in dialogue Box Window now open.
    . If the add-in is there, place a check-mark beside the add-in, if not already checked.




    http://i1065.photobucket.com/albums/...psdhd6hhxk.jpg

    ……………………………………..








    . – 9c) (####If you do not see the Add – In there then click browse and locate the add-in.




    http://i1065.photobucket.com/albums/...pswjmmfkps.jpg

    Once found, Click on it and it should then be added to list. Place a check-mark beside the add-in, if not already checked.)

    . R10) – Click OK

    . R11) – Usually that is enough and a new Tab comes up with maybe a Title like “Forum Tools”



    http://i1065.photobucket.com/albums/...psqdcb9col.jpg


    ( If it is not there or any other problems crop up along the way, then this may help:
    “. - Click the Office button at the top left of the Excel window -> Excel Options -> Trust Center -> Trust Center Settings... -> Macro Settings -> Tick "Trust access to the VBA project object model" -> OK -> OK “ ) . – If this is necessary then closing and reopening Excel may or may not also be required before the new stuff is displayed or available


    . R12) - Once it is “There”, Click on that Forum Tools Tab to get various options shown in a small window that may pop up. The latest does most that the Mr Excel Spreadsheet HTML Maker does. AND It has the extra function of a full encompassing BB Code Generator that can be posted in most Forums supporting BB Code. This BB Code Generator has most of the features of the MrExcel Spreadsheet HTML Maker and in addition by the extra option of removing the Headers, the tool gives an alternative method for inserting a simple Table into a Forum Post, that is to say using any spare area in a spreadsheet and then copying using the Forum tool with headers disabled…




    http://i1065.photobucket.com/albums/...psi8n9jgph.jpg

    …………………………



    http://i1065.photobucket.com/albums/...psocn9hwzw.jpg


    . R13) – Do a bit of experimenting in Forum Test Sub Forums, pasting in the various HTML and / or BB Code options. One small Tip – Sometimes different results are obtained by different combinations of Browsers and / or whether you paste in with Ctrl V or by right mouse click Insert……
    .
    . R13) – To actually Copy part of the spreadsheet to the Clipboard in a form which will paste into a Forum Thread:
    . R13a)- Select The Spreadsheet Range or code you are interested in.
    . R13b)- Click on something like Copy icon in the window obtained from clicking on a new option as discussed in 12), or from a selection should it be given by right mouse click
    .-R13c) Select option you want in to copy to the clipboard. If you have a choice of HTML or BB Code make sure you select the one relevant to wot you are doing or try them all initially.
    .-R13d)– Paste in a forum editor that supports BB Code or HTML Code.

    ………

    Alan
    Last edited by Doc.AElstein; 07-07-2015 at 03:50 PM.

  4. #19
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    Code version from
    http://www.excelforum.com/tips-and-t...-a-thread.html
    .. that works for me in XL 2007 and XL 2010.
    http://www.excelforum.com/developmen...ml#post4115901
    . Thanks to JBeaucaire and sktneer at ExcelForum and Jan Karel Pieterse here
    http://www.jkp-ads.com/articles/apideclarations.asp
    ……Copied to post #1
    http://www.excelforum.com/tips-and-t...um-thread.html
    by JBeaucaire

    ==============
    How I create a PERSONAL.XLSB for the first time:

    ……see post #2
    http://www.excelforum.com/tips-and-t...um-thread.html
    by JBeaucaire

    ........................................................................................................

    JBeaucaire’s instructions again how they worked for me in XL 2007 and 2010:

    ….. Copied to post #2
    http://www.excelforum.com/tips-and-t...um-thread.html
    by JBeaucaire
    =====================
    ADD a button to ribbon XL 2010:

    1) Right-click an anywhere on the current ribbon and select Customize the Ribbon

    2) On the right side of the Excel Option Dialogue Box that should come up, select in the upper right Dropdown list ,(Customize the Ribbon ), Main Tabs if it is not already selected.

    3) On the large box below, Right-click a main tab, ( for example the Developer), and select Add New Group

    4) Right click on this New Group which should come up and rename it , for example MyTools ( There appears to be an option to select the icon also, but it is ineffective here.. )

    5) On the left upper drop down box ( Choose Commands from) select - Macros, if it is not already selected.

    6) The large box below should now show all available Macros. Find your macro and select it, then click the ADD button in the middle

    7) Your macro should be now on the right in the new MyTools group in the large box. Right-click on it and select Rename to give it a unique toolbar name and select your icon ( Selecting an icon appears to work at this stage )

    8) Select finally OK below in the main Excel Option Dialogue box.

    ==============
    ADD a quick access symbol XL 2007 and XL 2010:

    1) Right-click in the upper command Tab Bar XL 2007, anywhere on the current ribbon XL 2010 and select customize Quick Access Toolbar

    2) On the right side of the Excel Option Dialogue Box that should come up, select in the upper right Dropdown list ,( customize Quick Access Toolbar), For all documents if it is not already selected.

    3) On the left upper drop down box ( Choose Commands from) select - Macros, if it is not already selected.

    4) The large box below should now show all available Macros. Find your macro and select it, then click the ADD button in the middle

    5) Select finally OK below in the main Excel Option Dialogue box.





    Data Range
    A
    B
    1
    Thanks
    Jbeaucaire and sktneer
    2
    at
    ExcelForum
    3
    and
    Jan Karel Pieterse
    4
    at
    Last edited by Doc.AElstein; 06-29-2015 at 03:52 AM.

  5. #20
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    32,893

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    Doc, your code posted in #19 doesn't work when copied from the forum. The CODE tags are the problem.

    I've updated the original post to include all the dynamic tweaks, perhaps just link directly to that post rather than reposting the code that might change again in the future.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  6. #21
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    Quote Originally Posted by JBeaucaire View Post
    Doc, your code posted in #19 doesn't work when copied from the forum. The CODE tags are the problem.

    I've updated the original post to include all the dynamic tweaks, perhaps just link directly to that post rather than reposting the code that might change again in the future.
    OK. Just done the edits above

    . Please could you not delete that Post # 19 as I may have directed others there already
    Thanks
    Alan
    Last edited by Doc.AElstein; 06-23-2015 at 11:08 AM.

  7. #22
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    32,893

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    IN context with you collection of ways of posting HTML in a thread, post #19 as a link to the TIP looks fine to me.

  8. #23
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    BigMolly
    Row\Col
    A
    B
    C
    D
    1
    Name
    Tot
    Tot
    Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    68

    ......................................................

    #164 #160 http://www.excelforum.com/suggestion...d-data-11.html

    A
    B
    C
    D
    1
    Name
    Tot
    Tot
    Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    68


    Excel 2007
    Row\Col
    A
    B
    C
    D
    1
    Name Tot Tot Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    =(2*68)/2
    Sheet: Molly


    Excel 2007
    Row\Col
    A
    B
    C
    D
    1
    Name Tot Tot Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    =(2*68)/2
    Sheet: Molly

    Using Excel 2007
    Row\Col
    A
    B
    C
    D
    1
    Name Tot Tot Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    =(2*68)/2
    Molly


    Row\Col
    A
    B
    C
    D
    1
    Name Tot Tot Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    68




    A
    B
    C
    D
    1
    Name Tot Tot Tot
    2
    joe
    60
    52
    23
    3
    luis
    24
    100
    81
    4
    frank
    95
    74
    24
    5
    anna
    67
    58
    55
    6
    mike
    56
    63
    83
    7
    violet
    39
    49
    49
    8
    grace
    28
    26
    68
    Last edited by Doc.AElstein; 06-29-2015 at 03:49 PM.

  9. #24
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Just Testing IMG. (cannot do it in Test forum as IMG is "off" there) No Reply needed.

    ... Hi, Feeding back to this Thread....

    Quote Originally Posted by Doc.AElstein View Post
    ........
    . 2) The “thing” I see in the VB Development Window is empty, ????.
    .. all just a question of clicking somewhere in the big “thing” (UserForm) in the main Development Window, and then seeing what pops up at the left in the in a smaller window which shows lots of Properties for whatever you clicked in the big “thing” (UserForm) . – clicking in the “empty box” revealed that it was the list box , lstResults.
    ... further..
    .. A tool box is to be seen, ( or you can get it clicking on a Tool icon , or view >> Toolbox.....)
    .. you just drag things from it into the big “thing” (UserForm) in the main Development Window
    .. the 5th tool in the first row of the ToolBox was the List Box, put in by Rory.
    ..
    ............................


    .. As For my request .3) from post #6 and #8,
    Quote Originally Posted by Doc.AElstein View Post
    .......
    . 3) Now I see how this “Fixed” window idea implemented with a Userform works, I guess my idea of a “Button” on the form to turn on or off the code parts 2) to 5) ( which calculate/ refresh arrData is not really possible? ) – It would involve some Flag Boolean variable that would be “switched” from the Userform to True or False, and then the code would be modified thus: ( Pseudo Code )

    If Flag = True Then
    ‘Do Parts 2) to 5)
    Else
    EndIF


    . The problem I guess is that Flag is reset once the code stops. (I guess the only approach possible would be to remove those code sections and place them in a Sub which ran from a button, ( Possibly in” that Resultat / ufResults Userform ) . This Button would then be hit every time a refresh / update was necessary. )
    . ( I guess a “bodge “ solution would be that hitting the button assigns the .Value of some spare cell in the sheet to “True” or “False”...........
    .......... let me ‘ave a go now...

    .. Drag a couple of buttons across.. ( I will play around with the Properties shown when I click once on them later )
    .. Double click on one and I get the code “behind it” – that is to say I guess what happens when I click it....
    .. And modify those codes thus:

    Please Login or Register  to view this content.

    ( Rather than set a “Flag” as an arbitrary “True” or “False” value in a spare spreadsheet cell, use the Status bar as a “Flag”, - just a novel idea..! )

    .. Make some minor modifications to my Workshhets_Change code, including the If Then Else End If bit ( Psuedo Code ) :

    If Application.StatusBar = False Then
    'I have a radio ( option ) buttons on the UserForm and can makee status bar False, ( That is to say in it's normal state )
    Else 'Do parts 2) to 5) to calculate, update, display totals Arrays
    ........
    .........
    .......
    End If 'End of recalculating or not recalculating the Totals Arrays

    .... Results
    . a) Option Button1, type in 1 Orange, result : row updated , but not totals in UserForm



    .b) Option Button2, re type in 1 Orange, result : row updated and totals in UserForm



    ....................................................................

    .. So that is a “bodge” solution to my request .3)
    .. I mark the Thread as solved.
    .. But, If anyone can do a better, more professional solution, I would be grateful and it would make a nice contribution to the Thread. Here the current File:
    https://app.box.com/s/7dalx2amn8mm44jfzj11s8lc1gg8jvk8

    .. Otherwise, Thanks again for the help
    . Alan.
    Last edited by Doc.AElstein; 08-05-2015 at 08:53 AM.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1