Trouble Shooting

DynaRod User's Guide Preface How to use DynaRod Trouble Shooting Table of Contents

Process Diagram of DynaRod 

The structure of DynaRod could be generally depicted as follows;
I/O screens carry a matching VBA program and the VBA program communicates with Excel program in back ground.  For one rod, possible maximum of 4 Excel output files are created by processing the rod with different functions.  Data are maintained within Access and the major output are written out to Excel output files.

One caution is not to use Excel while running DynaRod!
It is all right to open any Excel file when you are opening Archive screen.
When some functions of DynaRod is under execution, Excel might be compete with the user's Excel execution in back ground.  

The following DynaRod functions may compete with Excel program in back ground if running;

[Rod Balance]
[Deflection/Stress]
[Dynamic Deflection]
[Design/Deflection]
[Design/Stress]
[PF/NC Setting]

Zombie Excel

Under this structure of DynaRod, when an I/O screen (each panel of DynaRod) is activated, it kicks up Excel program in back ground.  After processing the defined functions, the VBA program writes output file via Excel and closes the Excel program.

In a successful completion of a series of processing, nothing wrong would happen.  But in  a case of an unexpected happening, or an abnormal termination in VBA code, though it is very rare I hope, some sets of Excel programs remain in the back ground in your PC.  These Excel programs are called "Zombie Excel", they are dead for a user but alive in your Personal Computer.

Symptom:

When zombie Excel is born, users may have a screen which shows several strange behaviors.  For instance, even if pressing a button to view a graph, it does not show any graph, eventually the graph window shows an odd big characters, nothing would work, etc..

Solution:

When you have these symptoms, you have to become a "Terminator" of zombie Excels with the help of Windows Task Manager.

  1. Press [CTL] + [ALT] + [DELETE] key at the same time to invoke Windows Task Manager.
  2. You will find "Process" tab in the task manager's window, open it.
  3. You will see a list of program names under the title of "Image Name".
  4. Find "EXCEL.EXE" in the list.  One or several zombie Excels must be there!
  5. Click on one of the zombie Excels once, then the line is highlighted.
  6. You will find a button "Terminate the Task" at the bottom of the window, then press the button.  One of zombie Excel must be erased by this.
  7. Erase all the existing "EXCEL.EXE" on the window.
  8. and close Task Manager.  You will be back to DynaRod screen after a few seconds.

If you miss to follow these steps, you have only to restart your PC after shut it down.

If you are running another Excel than DynaRod purpose, the Excel might also be erased by this operation.

PC Date and Time Trouble

When a user tried to change PC time toward past direction, DynaRod will terminate with a message, "Your computer time violates security requirements.  Process will terminate."
This happens only for Trial License and Annual License, not for Permanent License.  DynaRod is disabled by this.

This is a critical logic for DynaRod to protect from date cheating.  Some thoughtless trials to cheat the trial period need to be protected.

But in some occasion, it may happen for an ordinal user to have to adjust PC time backward for some reasons, such as return from summer time, etc..  When users happen to have encountered to this message, please be tolerant and wait for the same hours until the PC time clock will come back to the point of time and perform SetUpvnn.mde again.  If you set your PC time back one hour, come back one hour later to use DynaRod and set up your license via SetUpvnn.mde.  The exactly same license can be downloaded as far as it is effective.