XL2BB - Excel Range to BBCode 2.1

[TheJay]

How do we use this to import replies to threads generated with XL2BB?

 

[MARK858]

There is a Copy icon in the top left corner of the screenshot, click that then click the same cell in your spreadsheet as the top left cell in the XL2BB screenshot and press Ctrl + V

 

[TBud1981]

I can't seem to past the mini sheet after copying. the dialogue comes up stating it's been copied to the clipboard, but when I come back to past in the forum it acts as if I didn't copy anything

 

[TBud1981]

I can't seem to past the mini sheet after copying. the dialogue comes up stating it's been copied to the clipboard, but when I come back to past in the forum it acts as if I didn't copy anything

Never mind! I don't know what I did...but I got it to work! LOL

 

[smozgur]

I can't seem to past the mini sheet after copying. the dialogue comes up stating it's been copied to the clipboard, but when I come back to past in the forum it acts as if I didn't copy anything

Your Excel in your operating system doesn't work well with the clipboard via VBA and XL2BB has nothing to do with it.
However there is a workaround. Please check the "Manually copy the generated code" and retry.

 

[TBud1981]

Your Excel in your operating system doesn't work well with the clipboard via VBA and XL2BB has nothing to do with it.
However there is a workaround. Please check the "Manually copy the generated code" and retry.

View attachment 100889

thank you! you just solved how I fixed it! LOL

 

[smozgur]

thank you! you just solved how I fixed it! LOL

 

[Asbestos_Jen]

My XL2BB menu is substantially smaller than the one in your post. Is that because my Excel is painfully old (2007)? I couldn't run XL2BB v2.1, but have been okay with v2.0. I'm only asking because I can't get conditional formatting to copy into my posts, and would really like to have that feature.

Mine looks like this:

Your Excel in your operating system doesn't work well with the clipboard via VBA and XL2BB has nothing to do with it.
However there is a workaround. Please check the "Manually copy the generated code" and retry.

View attachment 100889

 

[RoryA]

I suspect that the code in XL2BB uses a property introduced in 2010 that allowed direct reading of formatting applied through conditional formatting. Prior to that it was quite a convoluted process to do.

 

[zero269]

smozgur updated XL2BB - Excel Range to BBCode with a new update entry:

v2.1 Bug fixes, changes, and new features



Read the rest of this update entry...

Hi smozgur,

Just an FYI, but I noticed the software version still shows 2.0.0 and not 2.1 in the File Properties.
I'm confident the add-in is the version specified in the forum based on the "Date last saved" is 2023-09-17.
I often keep several versions of software and add-ins on hand and need the files to reflect their version numbers and noticed this just now.
Best regards,