Excel Programming Support when you need it

At XLAutomation we provide ongoing support for all products and services. Our customers can be assured that when they need help we are there.

To find the support you need access any of the sections below. To show all Answers on this page select the "Expand all" link below to hide all Answers on this page select "Collapse all". To select a specific Answer then click on the Question that you are interested in and the Answer will be displayed.

Expand all | Collapse all

Frequently Asked Questions

This section provides answers to questions that are frequently asked by our customers.

Q: How can XLAutomation assist my business ?

A: At XLAutomation we provide customised software solutions for many different businesses. The solutions are most likely to be developed to deliver efficiencies within an existing business process. See our Services for more details on what we can offer your business

Q: What types of services does XLAutomation offer ?

A: Our Services include customised software development, office technology training and development, ongoing support, advice and consulting, project management. We can provide any or all of these services as part of a customers project.

Q: Do I need to spend alot money for customised software ?

A: Customised software doesn't need to be a signifcant cost for your business. Small projects can be completed for less than $500 (AUD). It depends on the complexity and type of work that you need us to complete. Contact us for a free apprasial and we will work together to meet your budget constraints.

Q: I am not receiving the XLAutomation Newsletter but I have subscribed ?

A: To ensure you receive our newsletters, please add the news@xlautomation.com.au email address to your "email safe list" or "white list".Click Here to find out how to do this.

Solutions to known Problems

This section provides solutions and answers to known problems in the use and implementation of our applications and services. Please report any problems not listed to our support team via Contact Us

Q: Office 2003 - How to enable a Digitally Signed workbooks ?

A: Almost all Excel Workbooks developed by XLAutomation will contain Macros. If that Workbook is Digitally Signed you will see the following dialog box

Q: Office 2003 - How do I enable Macros and Security in Office 2003 ?

A: When you open a workbook that contains Macros in Office 2003 you may be presented with either of the following dialog boxes depending on your current security settings.

If your security settings are on High or Very High and the workbook is not Digitally Signed you will see the following dialog box.

It provides a detailed description of the various settings for Macro security. In this case your Macro security needs to be adjusted to Medium which will allow you to choose whether you want to run Macros within a workbook or not.

To adjust your Macro security in 2003, you need to access Tools -> Macro -> Security. Then in the dialog box presented you need to select Medium from the available options. This will allow workbooks developed by XLAutomation to operate as designed. When you have changed the setting then exit Excel and attempt to open the workbook application again.

Q: Office 2007 - How do I enable Macros and Security in Office 2007 ?

A: With Office 2007 Microsoft significantly changed the way in which Macro security works within all applications. The following article has been sourced from the Microsoft website and provides a guide for users on Office 2007 in dealing with Macro security.

Guide to enabling or disabling Macro security in Office 2007

XLAutomation applications are almost always digitally signed and the following setting is the recommended option for your Office 2007 Trust Centre....

Disable all macros except digitally signed macros
This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.

Q: Office 2007 - Compatibility Checker do I need it ?

A: When saving a workbook in Office 2007 that has been developed by XLAutomation you may be presented with the following dialog box.

All XLAutomation applications have been developed to operate in Office 2003 and 2007, and as a result the Compatibility Checker is not required.

Simply uncheck the check box - "Check compatibility when saving this workbook" and then select Continue. The Compatibility Checker will no longer appear for this application

Q: Error when installation Lead Converter Distribution - DeleteFile failed; code 32

A: When attempting to install the Lead Converter Distribution component the following error dialog box is reported

To resolve this installation problem. Ensure that all Microsoft Office applications are not running include Outlook and then retry the installation. If that still fails then restart the machine and perform the installation before any applications are started.

Q: A certificate (signing or issuer) has expired

A: Most of the Excel applications and workbooks developed by XLAutomation contain a "Code Signing" digital certificate. The digital certificate is used to ensure that standard Macro Security tests that Excel enforces on the opening of a workbook are satisfied.

If you see the following Security Warning dialog box is means that the digital certificate supplied with your workbook has expired and can no longer be used on opening the workbook to satisfy the Excel Macro Security test.

The solution to this problem is to request an upgraded digital certificate from XLAutomation. Please use the Contact Us form on our website to advise us of your problem. Ensure that you identify the application that you are using and also the version.

To bypass this check and continue to use all the workbook functionality you can also select "Enable Macros" above and the workbook will open with functionality enabled. Note you will continue to see this dialog box each time you open this application until a new certificate provided by XLAutomation.

For 2007 users the Security Warning dialog should look like this

In this case the options are the same as described for 2003. The solution to this problem is to request an upgraded digital certificate from XLAutomation. Please use the Contact Us form on our website to advise us of your problem. Ensure that you identify the application that you are using and also the version.

To bypass this check and continue to use all the workbook functionality you can also select "Enable this content" above and the workbook will open with functionality enabled. Note you will continue to see this dialog box each time you open this application until a new certificate provided by XLAutomation.

Utilities to diagnose workbook Problems

This section provides access to some utility workbooks that have been developed to analyse and check the current settings within your workstation environment and if those settings are compatible with the workbooks developed by XLAutomation.

Q: Security and Macro Test - Digitally Signed

A: The most common problem when running workbooks with Macros are the security settings in place on the workstation. The following workbooks have been developed to analyse your existing settings and then provide assistance in setting the Macro security to the correct level for the workbook you have purchased from XLAutomation.

Depending on the type of workbook supplied it may be Digitally Signed, if it is Digitally Signed then download this workbook Security and Macro Test Digitally Signed.xls

Once it is downloaded to your workstation open the workbook. If your workstation environment is correctly configured you will see the following dialog box.

Almost all Excel Workbooks developed by XLAutomation will contain Macros. If you have not received a workbook from XLAutomation previously then the following dialog box will be displayed.

If you tick the option to Always Trust this Publisher and then select Enable...you will never be presented with the Enable Macros dialog box again for an XLAutomation Workbook that has been digitally signed. If you select Disable then the application will not operate as designed.

If you do not see either of these dialog boxes after opening the workbook then you may need to adjust your security settings. You should see the following worksheet instructions displayed which will point you back to this support page and the known solutions to macro security problems.

If none of the instructions and tips help resolve the problem then please contact our support team via Contact Us

Q: Security and Macro Test - Standard (Not Digitally Signed)

A: The most common problem when running workbooks with Macros are the security settings in place on the workstation. The following workbooks have been developed to analyse your existing settings and then provide assistance in setting the Macro security to the correct level for the workbook you have purchased from XLAutomation.

Depending on the type of workbook supplied it may be Digitally Signed, if it is Digitally Signed then download this workbook Security and Macro Test.xls

Once it is downloaded to your workstation open the workbook. If your workstation environment is correctly configured you will see the following dialog box.