Really nice fix Bruno! I've taken a different approach here entirely, and I may need to lean on someone's VBA expertise as well, but I'm REALLY happy with the potential of v2.0. I should have a working version later this aft.

Based on the code of Excel2BBTable, I added some significant modification and conversions to make it work with this hack.

Now, Excel formatting as seen on screen is automatically translated on a cell-by-cell basis. So font, font color, bold, italic, underline...pretty much all the basic styling this hack supports! I would like to add colspan support...and that'll be a work in progress.

To run, just create any data here and format it the way you like. Select the range you want as a table, click on the button (or toolbar) and generate the code for pasting to your post.

One minor issue...because of how this hack is written, it adds an extra column because of the pipe "|" at the end of the rows. To remove that column, you can just delete the end pipe in the first row before you submit your post.

War.Frog, this should be released as an "add-on" modification to this mod or something. This is a HUGE help for folks wanting to work on really complicated or detailed tables! :up:

Thanks for the help on this! :D

Thanks MTP! You're welcome, and I was motivated myself because I just get overwhelmed when the table exceed three rows. :D

This approach definitely eases things because it's a virtual WYSIWYG translation to BB Code. In fact, the macro could be used on ANY Excel range in any table (not just this one), as long as you manually entered the "head", sort and other detail into the code after the fact.

I'm going to continue playing with it to see if I can get colspan to work among other things.

Big Thanks also from my side :). Works on 2007 with a small "Bug":
- Header has CRs after each cell:
and a real bug:
according the code you wanted "If iSize <> 2 Then [inserte Code-Tag]"

Nice work!! Thanks again!
Bruno

And solved the empty column on the right:
Greetings, Bruno

Awesome Bruno. Hmm, very strange about the extra CRs after the header...this is what frustrates me so much about Excel versions!

Can you try posting your fix in both .xlsx and a down-saved .xls version to see if it translates properly? I can't do anything for > 2002.

Thanks!

Bruno/War.Frog,

Great work for the two of you. This is going to help our community tremendously. :up:

Does that 'empty column on the right' fix work for all versions of Excel? If so, will one of you share the 'corrected' version?

I never use xlsx, perhaps in 10 years when 2002 died :). Here always my latest xls-version in german (for my users): table.xls (Thread)

Greetings, Bruno

Edit:

• Interesting: The CR-Bug disappeared! Perhaps has something to do with my above workaround or with multiple saving the document :).
• Yes, should work in all Excel-Versions. I think War.Frog will soon post his new english version :)

LOL Bruno...good for you not using xlsx! :D Sadly I'm stuck with 2002 because of corporate hesitation. :rolleyes:

For whatever reason, this doesn't translate well back to 2002. I'm going to look at this to try and understand why - it's now adding MORE columns to the end and a column to the beginning. C'mon Microsoft! lol.

Thanks for your nice words too MagicThemeParks. Hopefully, we can get this ironed out 100% for all versions of Excel, or at least separate ones for each.