Solved

Excel Multi Threading and Manual formulas VB Script

Posted on 2016-08-08

VB Script

1 solution

67 Views

Last Modified: 2016-09-10

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

Comment

Question by:nathantrevor

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 18

Accepted Solution

by:xtermie

xtermie earned 500 total points (awarded by participants)

ID: 417652542016-08-22

Try doing it before you disable multi thread calcs

Private Sub Workbook_Open()
 Application.Calculation = xlManual
 Application.CalculateBeforeSave = True
 ' Disable MultiThreaded Calculation '
 Application.MultiThreadedCalculation.Enabled = False
....
End Sub

Open in new window

LVL 18

Expert Comment

by:xtermie

ID: 417924492016-09-10

Provided code based on question but no feedback from author

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enable UserID and Password Prompt in VBScript

Article by: SavindraSingh

When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…

VB Script

Use VBScript to Ping Sweep and Check Office Version

Article by: David

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.) Creates log file in the directory the script is run from (if it doesn't already exist) 2.) Sweep…

VB Script

Introduction to using the Windows 10 Snipping Tool

Video by: Andrew

In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

How to view most utilized nodes in your network?

Video by: AdRem

Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…