help combining several modules

[shootstill]

So I have mixed, matched, and customized several modules to fit my needs to a point, however - am having trouble tying the pieces together, to run all together.

Workflow Report Automation (EDIT).xls

First, I am cleaning up some data within my report:

Please Login or Register  to view this content.

Second - I am formatting the content of my report:

Please Login or Register  to view this content.

Third - Applying hyperlinks to my items in Column A (I can't figure out how to always apply to the cell if there is a value, and not if it is empty)

Please Login or Register  to view this content.

I would like to apply some sort of table-like formatting to this, like a colored header row, and banded rows, but can't figure that out so it maintains alternate shading when the next step engages.

Fourth - I create individual sheets for all of the teams in my report

Please Login or Register  to view this content.

Fifth - I autofit the columns, to prepare for sending the data to identified recipients

Please Login or Register  to view this content.

Sixth - This part is becoming very frustrating. I have 2 sets of code, and would like some help in consolidating if possible. My first set, Sub "SendReportSingle" Works great for sending a range to a defined email address in the code, and the Sub "SendReportBatch" works for sending the entire sheets (if it exists) to a coordinated recipient and allows for ad-hoc subject editing.
I would like to use the range functionality from "SendReportSingle" code, and incorporate that into the "SendReportBatch" code. Any advice on this?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

As you can see - lots of different pieces that I have put together, and could use some help lining it up.

I would like to have the macro run entirely to the send stage, and then run the send as a separate instance.

Workbook attached here: Workflow Report Automation (EDIT).xls

Thanks!

[JBeaucaire]

You seem to have far more problems than are appropriate for a single thread. I will address your stated issue of running subsequent modules in sequence.

Now that you have developed and can trust the success of individual modules, you can create a master module that simple calls those sub routines in order:

Please Login or Register  to view this content.

...etc.


Of course you could combine them all into a single module, but there's no real benefit to that, overall, and you've done the work to create the individual trusted modules. So use them.

[shootstill]

You reminded me of a question I had while compiling these - am I using any sort of conflicting codes?

Since I have compiled and customized from multiple sources, I haven't stuck to any sort of formats, and the portion I recorded and edited myself (probably very obvious to a trained eye) has no real structure as far as I can tell.

The main reason I have multiple modules is cause I don't know how to insert additional macros into a routine (but yes, I have come to trust them!)

I'll run the code you suggested, thanks!


Sent from my iPad using Tapatalk