Thanks Thanks:  0
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 31

Thread: MrExcel HTML Maker Update

  1. #21
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,406
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by MrKowz View Post
    Looks like it's time for me to download the Forum Tools addin and work out the kinks.
    I think that is a good idea, rather than us trying to explain all the steps we took. At least that way you might get most of it sorted. Then if there are isolated things that affect individual users after that they can be worked on then.


    Quote Originally Posted by MrKowz View Post
    I do greatly appreciate the information and assistance debugging this!
    .. and many forum users will appreciate your efforts!
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - 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

  2. #22
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,359
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by Peter_SSs View Post
    .. and many forum users will appreciate your efforts!
    Seconded
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #23
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    29,974
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    I'll also have a look at it when I'm back. I didn't really review the commandbar code when I incorporated it, and it would be good to update it for RibbonX for 2010 and later.

  4. #24
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,589
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by Peter_SSs View Post
    I deactivated MrE & Forum Tools by removing the ticks in Options -> Add-Ins
    Closed Excel & re-opened.
    Neither Add-In appears in vbaProjects nor had a ribbon tab created - all good in that regard. However, a right-click menu option still appears and, if used, opens Forum Tool vbaProject and generates the required code. That may not be relevant to your work, though you did mention having a right-click menu. If Forum Tools and MrE are both going to have a similar right-click menu, you might consider re-labelling to be "MrE Generate HTML (Use Default)" or similar so that users know which Add-In they are using.
    Peter,

    I think I may have figured out what is going on with the issue you describe above. The Forum Tools add-in isn't consistently cleaning up its commandbars when it's being disabled. I noticed a similar issue with the (old) HTML Maker where workbook_open() and workbook_beforeclose() events weren't firing; this is what initially prompted me to go the route of XRibbon instead of having the code create/clean up command bars.

    Here is how I was able to replicate the issue:
    Code:
    * Disable Mrexcelhtmlmaker20170804
    * Before disabling Forum Tools add-in, run the macro "CleanUp" from Forum Tools (found in the mUI module).  
      Confirm before disabling add-in that all right-click context menus related to HTML Maker/Forum Tools are removed.
    * Close/Open Excel
    * Enable Forum Tools add-in
    	* Here is where I experience the issue that the right-click context menus are not created, 
    	  as for some reason the workbook_open event isn't firing.
    * Close/reopen Excel here, the menus will get properly created.  I assume that enabling an add-in
      while Excel is open does not trigger the workbook_open() event.
    * Deactivate Forum Tools add-in
    	* Because the add-in is being deactivated, similar to the workbook_open() event not firing, the
    	  workbook_beforeclose() event isn't firing.  Because of this, the macro "CleanUp" is never running.
    	* This is where the latent right-click menus are sticking around.
    	* Closing/Reopening Excel does NOT clear these out.  They must be cleared using the CleanUp macro.
    	* If you try clicking one of these, Excel appears to hang.  If I press Esc, it goes to the Forum Tools addin code.
    Can you please verify on your end if this testing is consistent with what you have experienced?
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  5. #25
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,406
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by MrKowz View Post
    Can you please verify on your end if this testing is consistent with what you have experienced?
    Yes, I replicated what you have described.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - 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

  6. #26
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,589
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by Peter_SSs View Post
    Yes, I replicated what you have described.
    With that in mind, do you still get errors with my menus or are you having issues with my menus generating? I have not been able to replicate the issue with menus not generating on my end.
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  7. #27
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,406
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by MrKowz View Post
    With that in mind, do you still get errors with my menus or are you having issues with my menus generating? I have not been able to replicate the issue with menus not generating on my end.
    My problem is (still) that if I have Forum Tools installed and I then Activate MrExcelHTMLMaker20170804 everything seems okay, but as soon as I close Excel and re-open the following happens
    - The MrExcel ribbon tab does not appear
    - The MrExcel right-click menu does not appear
    - And yet in File->Options->Add-Ins MrExcelHTMLMaker20170804 is still shown as ticked
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - 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

  8. #28
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,168
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Hello Peter
    Did you check the option/permission for this add-in

    C\:\Users ....
    right click HTML maker
    Properties
    check the option to permit use ( This may be in Advanced)

    N.B. Some of my wording may be incorrect; the option no longer shows.

  9. #29
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,359
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: MrExcel HTML Maker Update

    It is under the general section as blocked in the properties but I suspect Peter has his addins folder as a trusted location which would allow it to run.

    I might be wrong about the last bit though
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  10. #30
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,406
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: MrExcel HTML Maker Update

    Quote Originally Posted by Dave Patton View Post
    Hello Peter
    Did you check the option/permission for this add-in

    C\:\Users ....
    right click HTML maker
    Properties
    check the option to permit use ( This may be in Advanced)

    N.B. Some of my wording may be incorrect; the option no longer shows.
    Dave, I think you may have it. Thank you!
    I had originally unblocked the Add-In but, after having some troubles, deleted everything and started right from the beginning again.
    It appears that I forgot to unblock the second time.
    The odd thing is that I got the new MrExcel HTML Maker up and working the first time on each of my two 'installation attempts', even when I forgot to unblock. It was only after I subsequently closed Excel & Re-opened that the Add-In failed to load. Since it had worked once, the unblocking didn't occur to me.

    Anyway, in very limited testing now, it seems to be working. I have two identical right-click menus though, which is quite confusing.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - 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

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
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com