XL2BB - Excel Range to BBCode 2.1

[Blasirl]

Is there a link to download xl2bb not zipped? No matter what I do, when I load it, Excel does not trust the file.

 

[Blasirl]

I think I stumbled onto the answer

XL2BB - Excel Range to BBCode

Just been trying XL2BB and works great. Drawback is I'm using European separators. Will they adapt ( to non European settings) when pasting to the board, and the other way round ? (I admit I did not read all the answers in this thread) I pasted from the board to my Excel version and had to do...

www.mrexcel.com

 

[MARK858]

This is covered in the link in the instructions (under Preparing to Install the Add-In)

I have posted the link again below, you can also put the file in a Trusted Location

Install an Excel Add-In - Peltier Tech

A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such as buttons on the ribbon or on context (right-click) menus, so you can access its features...

peltiertech.com

 

[Blasirl]

This is covered in the link in the instructions (under Preparing to Install the Add-In)

View attachment 88731

I have posted the link again below, you can also put the file in a Trusted Location

Install an Excel Add-In - Peltier Tech

A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such as buttons on the ribbon or on context (right-click) menus, so you can access its features...

peltiertech.com

I had read through that, but found a video and another explanation and between the three, figured it out. Also found I added to the wrong Add-in folder. So far no new error messages.

 

[MARK858]

Happy you got it sorted (btw this will be the same with any file containing macro's that you download from the Internet or from an email as it is a Windows security setting rather than anything to do with XL2BB)

 

[Blasirl]

Happy you got it sorted (btw this will be the same with any file containing macro's that you download from the Internet or from an email as it is a Windows security setting rather than anything to do with XL2BB)

I figured as much, but in the past, I chose not to use the file. This one is unique. I am not sure for my current issue that it will help due to the conversion limitations, but we shall. I am trying to formulat a coherent question so I can post it.

Thanks again.
R.

 

[ronny00789]

I am not able to paste the result from XL2BB. Is it a bug or I am doing it wrong ?

 

[RICH937]

Can someone tell me what I'm doing wrong here? I managed to get the add-in loaded, and the stuff for the toolbar, but I cannot figure out how to capture the range. the "mini sheet" icon the instructions indicate I should click on remains grayed out no matter what I do. Suggestions?

 

[smozgur]

Can someone tell me what I'm doing wrong here? I managed to get the add-in loaded, and the stuff for the toolbar, but I cannot figure out how to capture the range. the "mini sheet" icon the instructions indicate I should click on remains grayed out no matter what I do. Suggestions?

Have you tried the following?

1. Check the file properties and make sure you have selected the "Unblock" checkbox at the bottom of the General tab.
2. Save the xl2bb.xlam file to a trusted location, or add the folder that you saved the add-in as the trusted location in Excel (Note that I wouldn't add general folders like Downloads folder as a trusted location)
3. Try using the XLSTART folder, as explained in the add-in installation steps.

 

[Peter_SSs]

the "mini sheet" icon the instructions indicate I should click on remains grayed out no matter what I do

FYI: This is also covered in this Sticky at the top of the About This Board forum