HI
I want to be able to create a XLAM file using Vbscript that will do 2 things
1 = Set formula calculation to manual and calculate before save to True
2 = Disable Multi thread calculation
I can get the disable multi thread calc to work using this script and placing he xlam file in the XLStart
Private Sub Workbook_Open()
' Disable MultiThreaded Calculation '
Application.MultiThreadedCalculation.Enabled = False
' Other options '
' Automatic Mode '
' Application.MultiThreadedCalculation.ThreadMode = xlThreadModeAutomatic '
' Manual Mode '
' Application.MultiThreadedCalculation.ThreadMode = xlThreadModeManual '
' Use 2 CPU '
' Application.MultiThreadedCalculation.ThreadCount = 2 '
End Sub
But when I try to add in the manual formula part using this script it does not work
Application.Calculation = xlManual
Application.CalculateBeforeSave = True
Can you help me as I am not at all good with VB script
Thanks Marcus
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.