customized ribbon to run the macros created for a Summary Sheet

Hi all,

I have had loads of help from Weebellah to process and delimit a csv order sheet which creates a workbook with a tab for each order.
I now want to create a summary of all the orders with a total of each type of wine for a stock check. I have created 5 macros: one call the macros; one to create a Summary Sheet; one to collate the orders from every other worksheet; one to then total the different types of wine and then delete the duplicates except one with the new total and finally a macro to put in some heading lines to tidy up the Summary Sheet.

I then created a custom ribbon with the two groups - one which only has a link to the macro to call all the macros and another to open a worksheet and do some sorting or emailing.

However, I have tried to save as an Add-in, export the customUI and nothing works if I try to send in a zip file to another computer. I have to then copy the macros and create the ribbon all over again with the link to the call all macro.

I have attached a copy of the workbook with just two orders and the vba script for the macros if anyone can help me - NOTE: please forgive my vba - most I could only do via recording a macro but it does work!

Thank you so much everyone

Originally Posted by Zer0Cool

How are you creating the ribbon? If your just doing it from the Excel GUI thats not gonna cut it.
The basic process I use to create my addins (xlam) is to start with a xlsm file, write my code, use the UI editor to create my ribbon and then save as xlam. The addin is then self contained with all the code required to run the macros and the ribbon to load for it.

Exact same process I did and use. I have an Addin file that contains all of the RibbonX code done with CustomUI Editor with callbacks to the actual VBA code in the modules contained in the Addin file. And when you get better at it, you can learn how to also add custom images and other 'cool' things to it.

then you just share the Addin File with others as needed.

Dear Weebellah,

Thank you so much - I am going to see how to embed into the xlam file as you said. Please now find attached the worksheet with Jane Smith having one more order than John Doe. This is when I get a runtime error1004

When you Debug it is in the Public Sub ProcessOrders()- the section for iRow = 3 - highlighting the part "Selection.TextToColumns Destination all the way down to TrailingMinusNumbers:=True"

Angelique

Dear Keebellah,

Sorry about that - typo error - you should see how people try to spell Angelique though lol.

That is amazing - I am having great fun with Custom UI Editor for Microsoft Office

By the way, just one last thing. Ages ago Keebellah you said that if I enable a part of your script I could get the folder
option to work for the target for each customer to go into individual folders. I am not one hundred percent sure where though.
Would you mind pointing me in the right direction please?

I just want to say I am so grateful for all the time and effort you have put into helping me. It has helped a lot
so that I can practice and learn which is wonderful.

Angelique

Dear Keebellah,

Yes I tried that, I selected the tick box - the button underneath then changes appropriately but when it
processes it comes out as one workbook still with the customers on tabs.

So I thought there was something to do with 'wbNew.SaveAs FileName:=targetFold if Not allInOne' in the orderProcessingModule to enable the script to utilize this.

Angelique

or actually is it the Private Sub CheckBox1_Change() ? in the WineOrderprocessingForm coding for that tick box?

Well .... what can I say. I am really happy - it works like a dream. This is just amazing, thank you so much Keebellah. I am going
to spend a lot of time looking through and trying this out.

Again, thank you very much Keebellah. You are my hero

Kindest regards

Angelique