Trying to prevent calculating a temp workbook - Problem with PublishObjects.Publish

[MacGyver7640]

Good afternoon,

I have a very clever function (below), created by Ron de Bruin, that copies tables into emails. This is great for daily reporting! However, it has a quirk where right as the .Publish (True) command executes it starts to calculate the temp workbook that was created to store the table. If I push escape and tell it to save without calculating, no problem, it goes on the create the email correctly. But if I don't manually do this it adds minutes onto the run time of the macro, very annoying! Particularly because I have multiple tables.

Application.Calculation =xlManual does not seem to have any effect. Any thoughts? Thank you for your help!

Please Login or Register  to view this content.

[shg]

Maybe set the EnableCalculation property for the worksheet to false.

[MacGyver7640]

shg! That worked!

Revised code is below. I'll shoot an email over to Ron too. Thanks so much!

Please Login or Register  to view this content.

[shg]

That's not what I suggested, but if it works, fine -- though you probably want to set calculation back to automatic before exiting.