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

	A​
86​	5 Sheridan St
87​	7 Sheridan St
88​	11 Sheridan St
89​	13 Sheridan St
90​	6 Sheridan St
91​	8 Sheridan St
92​	10 Sheridan St
93​	12 Sheridan St
94​	14 Sheridan St
95​	16 Sheridan St
96​	18 Sheridan St
97​	20 Sheridan St
98​	22 Sheridan St
99​	2 Avon St
100​	4 Avon St
101​	6 Avon St
102​	12 Avon St
103​	14 Avon St
104​	16 Avon St
105​	18 Avon St
106​	3 Avon St
107​	7 Avon St
108​	9 Avon St
109​	11 Avon St
110​	13 Avon St
111​	5 Chester St
112​	7 Chester St
113​	12 Chester St
114​	16 Chester St
115​	20 Chester St

Sheet: over