When to use this installer


This installation is recommended when running MYOB AE or MYOB AO, whether or not the user is in a single desktop or terminal server environment. When documents are opened from MYOB AE or AO, MYOB opens Excel with raised privileges, i.e. opens Excel in Admin mode, which requires the installation of a multi-user 'administrator' level addin.


(For the normal Add-In installation instructions use this link.)


Step 1

Please click on the following link to download the Installer and then follow the instructions in the Wizard before moving to Step 2.

Multi User Installation Setup File



Step 2

Register the XLL Add-ins.


Excel requires that XLL Add-ins be registered on a per user basis. If you are the only user on this machine you can skip this step.


In Terminal Server environments our recommendation is to add the following line to all User's login scripts:

"C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers\adxregistrator.exe" /install="Workpapers.Next.Addin.dll" /privileges=user




NOTES On Previous Installations

  • Previously the Add-in installed into C:\Program Files (x86)\Business Fitness. If you uninstall the Add-in first, the new Add-in will create and install into the new filepath C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers.


NOTES On Uninstalling

  • Our recommendation is not to Uninstall this Add-in. However if your process requires this step, prior to TS uninstalling the Add-in needs to be deregistered for each user. This can be done by running the login script with a /uninstall on the end of the script. This will remove the Formula Add-in from the registration.

    "C:\Program Files (x86)\Business Fitness\HowNow Smart Workpapers\adxregistrator.exe" /uninstall="Workpapers.Next.Addin.dll" /privileges=user

  • Then you can safely uninstall the HowNow Smart Workpapers Add-in through Programs and Features.    




After the installation has completed open Excel and confirm it has been installed correctly.

Select >File >Options >Add-ins. You should now see the following:




Full Uninstall

(when no longer using Smart Workpapers)


On Admin User:

Open Excel as Administrator

Go to ‘Excel’ / ‘Options’ / ‘Addins’ / ‘Manage – COM Addins’

Select ‘HowNow Smart Workpapers’ from the list and click ‘Remove’


This will remove the Terminal Server COM add-in “HowNow Smart Workpapers”  for all users.


Login Script:

Next, modify the login script for each user to the following (note that the line: OfficeVersion=16.0 needs editing to match the version of Excel you are running)


------------------------------------
::**NOTE** Set Office version below to match what is installed
set OfficeVersion=16.0
::Remaining script will delete the appropriate key
set rkey=OPEN
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN1
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN2
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)
set rkey=OPEN3
set regvalue=reg query HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey%
set swptext="adxloader.Workpapers"
if not "x!regvalue:%swptext%=!"=="x%regvalue%" (reg delete HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\%OfficeVersion%\Excel\Options /v %rkey% /f)

------------------------------------


This will remove the XLL addin “HowNow Smart Workpapers Formulas” for all users


Final Uninstall (on Admin User):

Once you are sure all users have run the login script at least once, do the following:

1) Remove the login script

2) Perform a normal uninstall on the admin account by going to Control Panel / Uninstall Programs / Select ‘HowNow Smart Workpapers’ and uninstalling.


Please call the Business Fitness Support Team on 1300 333 424 if you have any questions or need assistance.




Other Notes


If a user has previously performed a Local User Installation, this will take priority over any subsequent Multi User installation for all users. The user will need to uninstall their normal copy of HowNow Smart Workpapers, which can be done through the normal Programs and Features menu of the Windows Control Panel, prior to registering the Terminal Server Installation.