smozgur

XL2BB - Excel Range to BBCode 2.1

No permission to download
That is a good idea, editing the minisheet. Thanks.

I edited your article. Please let me know if you post other Excel Articles which contain Data Table, so I can manually fix them like this one.

Thanks for the heads up. I will bookmark your report post.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I edited your article. Please let me know if you post other Excel Articles which contain Data Table, so I can manually fix them like this one.

Thanks for the heads up. I will bookmark your report post.

Thank you very much.
 
I need assistance please.
Deleted old version with no problem and now after attempting downloading new version I have been unable to do .
In fact I have the situation where xl2bb no longer shows in Add in Box.
The attached shows some of the messages I am getting
V=
1599084717147.png

1599084746832.png

1599084768042.png

At this stage i need to get the "xl2bb" added to add-ins available , which i inadvertently deleted so assistance here appreciated.
Next i found it impossible to locate file when i browsed so that appears to be my main problem.
Any assistance greatly appreciated to be able to use this most useful add in
 
@pedro-egoli - Could you please try the downloading the add-in file by right click on the download button and "Save as" instead, then save the file on Desktop and unzip there? This way, you'll make sure that it was not unzipped into a temporary location.

1599085980883.png


Then you can alternatively put the unzipped add-in file into XLSTART folder as explained in XL2BB Overview page if the add-in installation method doesn't work.

Please let us know if it still doesn't work.
 
Finally fixed thanks .
I traced the file to "Temp" and downloaded from there.
Thanks for your quick response.
 
smozgur, I thought I had it fixed however, as soon as I closed Excel "Mr Excel" disappeared from sheet , though the add-in box was ticked
II can get "Mr Excel" to show on sheet and use it by locating it in Documents and double clicking.
However, when i close and reopen sheet it disappears and to get it back I need to repeat this process.
Having said that after active excel sheets are closed a blank sheet remains and it shows "Mr excel" and when I click on capture range it shows "there is no active workbook"
Have tried everything to overcome without success.
At the moment the file is in Temp as well as documents and a shortcut is on desktop
Pop up windows with xl2bb.xlam (Small).jpg

When opening I get message "sorry we couldn't find temp fle" (see image below)
The image below also shows other messages
Any suggestions on what i am doing wrong.
 
Last edited by a moderator:
smozgur, Perseverance won out and ADD-IN seems to be installed correctly.
As I had mentioned there had been several attempts by me to uninstall and reinstall without luck.
It turns out that I had installed add-in in 2 different places and this was causing problem
Deleted the oldest and unblocked the newest and "Mr Excel" now appears on excel sheets when opened.
Thanks for the add-in .
 
smozgur, Perseverance won out and ADD-IN seems to be installed correctly.
As I had mentioned there had been several attempts by me to uninstall and reinstall without luck.
It turns out that I had installed add-in in 2 different places and this was causing problem
Deleted the oldest and unblocked the newest and "Mr Excel" now appears on excel sheets when opened.
Thanks for the add-in .

Great! (y)
 

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top