smozgur

XL2BB - Excel Range to BBCode 2.1

No permission to download
Where is the download Link?

Please go to the top of this page and look for the topic title (XL2BB - Excel Range to BBCode 1.2.7) then you'll see the right aligned orange download button.

1594689345113.png
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Hi How can you use XL2Bb if one needs to capture more than one sheet fo a questio on teh forum?

Thanks
 
Just use it twice and paste the 2nd one below the first. Like the below....

xxxbbb.xlsb
ABCDE
1Order IDSiteProduct NameShip ToQuantity
2110-14-N22On SiteGudbrandsdalsostBrazil30
3105-20-F75Off SiteVegie-spreadGermany6
4103-3-N20On SiteFløtemysostAustralia30
5108-14-N32On SiteKonbuFrance3
6109-19-F61Off SiteLakkalikööriBrazil60
7109-10-N38On SiteCamembert PierrotGermany49
8104-16-N17On SiteOriginal Frankfurter grüne SoßeGermany35
9104-14-N47On SiteFløtemysostBrazil2
10105-28-N19On SiteIkuraSweden16
11108-5-N14On SiteChocoladeFrance8
12104-19-N79On SiteWimmers gute SemmelknödelUSA30
13105-1-F85Off SiteZaanse koekenBrazil15
14103-20-N11On SiteSingaporean Hokkien Fried MeeFrance6
15106-25-F43Off SiteRössle SauerkrautGermany15
16106-15-N33On SiteTarte au sucreGermany80
17107-19-F47Off SiteJack's New England Clam ChowderGermany35
18106-10-N64On SiteIkuraUK24
19104-14-F75Off SiteGorgonzola TelinoFrance35
20107-28-N58On SiteOutback LagerSweden40
Sheet3


xxxbbb.xlsb
ABCDE
1SiteCategory NameProduct NameQuantityCust Name
2On SiteCondimentsLouisiana Fiery Hot Pepper Sauce10Daniele
3Off SiteSeafoodJack's New England Clam Chowder30Jon
4Off SiteDairy ProductsCamembert Pierrot84Micheal
5On SiteDairy ProductsMascarpone Fabioli20Omar
6On SiteSeafoodJack's New England Clam Chowder20Dortha
7Off SiteBeveragesOutback Lager20Haywood
8Off SiteConfectionsPavlova3Carlee
9On SiteCondimentsLouisiana Fiery Hot Pepper Sauce12Lashawn
10On SiteCondimentsGrandma's Boysenberry Spread20Sandee
11On SiteBeveragesChai35Corrina
12Off SiteDairy ProductsGorgonzola Telino20Tory
13On SiteProduceLonglife Tofu21Raguel
14Off SiteSeafoodRöd Kaviar50Ian
15Off SiteSeafoodJack's New England Clam Chowder13Orlando
16On SiteBeveragesChai3Goldie
17On SiteBeveragesGuaraná Fantástica30Isidro
18On SiteDairy ProductsFløtemysost35Walton
19Off SiteSeafoodEscargots de Bourgogne30Piedad
20On SiteDairy ProductsMozzarella di Giovanni1Fredrick
21Off SiteGrains/CerealsSingaporean Hokkien Fried Mee4Alise
Sheet4
 
This is great!
Thank you.
 
@excel_1317 if you are still having issues then post as much detail that you can (especially exactly what the error states) and I am sure @smozgur will have a look at it.
 
smozgur updated XL2BB - Excel Range to BBCode with a new update entry:

v1.2.8 - Bug fixes, and new features added.

Bug fixes:
  • Data validation in merged cells (#1)- There is no applicable fix since data validation should be applied to all cells in the merged area prior to range capturing but warning message displayed in such cases.
    • Excel doesn't apply the same data validation automatically to the merged cells when the merge applied after setting data validation for a cell in the...

Read the rest of this update entry...
 
Appreciate instructions to uninstall the previous version of XL2BB so I can load the new version. Thank you
 
@grampygrumpy First disable it in Excel by in your Excel file click the File Tab - Options - Add-Ins - Make sure the Manage Addins is set to Excel Add-ins - click Go - find the Addin in the list and clear the checkbox - click OK.

Now find it's file location (normally something like C:\Users\YOURUSERNAME\AppData\Roaming\Microsoft\Addins) and do a straightforward right-click and delete the file.
 

Forum statistics

Threads
1,216,503
Messages
6,131,022
Members
449,616
Latest member
PsychoCube

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