Forum Tool add in bad code?

[xdriver]

I am running 2016 32bit Excel for OSX and when I add Forum Tools, I get the error

"Microsoft Visual Basic Run0Time error '5': Invalid procedure call or argument.

If I click abort or debug, it shows the ribbon in Excel for the add in.

When I select some cells and click copy in the add-in, I get the error:

"Compile error: Variable not defined (mCreateHTML 288:4)

It puts the cursor on a line:

#Else
tenp = temp & " 32 bit"


If I change "tenp" to "temp" the add in will work. Beyond what I did, I know nothing else, so maybe someone can modify the add in and repost it? Or is there simply something wrong with my version or computer? Thanks.

Also, how do you post photos?

 

[mole999]

which particular forum tool ?

 

[Caleeco]

If i were to hazard a guess... I think he's referring to the one listed in Section B
http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

'Forum Tools Add-in"

Regards
Caleeco

 

[xdriver]

If i were to hazard a guess... I think he's referring to the one listed in Section B
http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

'Forum Tools Add-in"

Regards
Caleeco

That is the correct link, yes.

 

[mole999]

Rory is not on at the moment

 

[RoryA]

I've just uploaded a revised version - can you test it and let me know?

 

[shg]

Did SOMEBODY not use OPTION EXPLICIT??

ʅ_(ツ)_ʃ

 

[RoryA]

Conditional compilation.

 

[Caleeco]

Did SOMEBODY not use OPTION EXPLICIT??

ʅ_(ツ)_ʃ

LOL I actually laughed out loud!

 

[xdriver]

I've just uploaded a revised version - can you test it and let me know?

Rory, this worked great, thank you.

I unchecked and deleted reference to the previous install. Downloaded the updated version and put it in an add in folder in "My Documents" and added the new version to excel. It seems to work with no errors as long as what I just pasted below works. It is a straight copy paste of default settings.

Unknown 32 bit


[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

86​

[/td][td]5 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

87​

[/td][td]7 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

88​

[/td][td]11 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

89​

[/td][td]13 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

90​

[/td][td]6 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

91​

[/td][td]8 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

92​

[/td][td]10 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

93​

[/td][td]12 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

94​

[/td][td]14 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

95​

[/td][td]16 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

96​

[/td][td]18 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

97​

[/td][td]20 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

98​

[/td][td]22 Sheridan St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

99​

[/td][td]2 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

100​

[/td][td]4 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

101​

[/td][td]6 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

102​

[/td][td]12 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

103​

[/td][td]14 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

104​

[/td][td]16 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

105​

[/td][td]18 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

106​

[/td][td]3 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

107​

[/td][td]7 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

108​

[/td][td]9 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

109​

[/td][td]11 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

110​

[/td][td]13 Avon St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

111​

[/td][td]5 Chester St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

112​

[/td][td]7 Chester St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

113​

[/td][td]12 Chester St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

114​

[/td][td]16 Chester St[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

115​

[/td][td]20 Chester St[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: over[/td][/tr][/table]