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 '
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