I have 3 workbooks that are intertwined with each other and I would like to
automate my macros and calculations.

The order of my sequences would be:
Calculate 1st workbook
Run sorting macro in 1st workbook
Calculate 2nd workbook
Run sorting macro in 2nd workbook
Calculate 3rd workbook
Run sorting macro in 3rd workbook

From here I need to save an HTML file of one of the sheets in the 3rd
workbook, but I don't mind doing that manually, unless this can be automated
as well.

Is there a relatively easy method of doing this? I am not very familiar with
VB, but I could probably get through it with some assistance here. Maybe
there is a simple way to do this, but I haven't been able to put my finger
on it. Any help would be greatly appreciated.

Chris

Hi Chris,

Try turning on the macro recorder and run the sesired sequence of operations
manually.

This should provide you with code that can be edited to generalise and
optimise it.


---
Regards,
Norman



"c" wrote in message
...
I have 3 workbooks that are intertwined with each other and I would like to
automate my macros and calculations.

The order of my sequences would be:
Calculate 1st workbook
Run sorting macro in 1st workbook
Calculate 2nd workbook
Run sorting macro in 2nd workbook
Calculate 3rd workbook
Run sorting macro in 3rd workbook

From here I need to save an HTML file of one of the sheets in the 3rd
workbook, but I don't mind doing that manually, unless this can be
automated
as well.

Is there a relatively easy method of doing this? I am not very familiar
with
VB, but I could probably get through it with some assistance here. Maybe
there is a simple way to do this, but I haven't been able to put my finger
on it. Any help would be greatly appreciated.

Chris