PostTrans Common Questions/Answers

The page is split in to the following sections:

Installing PostTrans

1. Get COM Toolkit unlocked

2. Download Installation program

3. Make sure everyone is out of Exchequer

4. Run setup program, and point it to MAIN Exchequer directory.  Ignore message about directory already exists

5. If our download page includes an update of COM Toolkit then extract this to Exchequer directory

6. Open Excel and add PostTrans.xla add-in, add PostTransLookup.xla if needed.  Answer "NO" to copy message.

7. Examples are added to "Start >> All Programs >> PostTrans"

8. Please browse the web site for demonstration videos, etc.

Installation Issues

I get error 5 or 8 when I open the spreadsheet?

Reason  

The software has been installed when logged in as a different user, and the software cannot access the registry keys for the current user.

Answer

Exchequer is not in your PATH Statement

Reason  

Your installation of Exchequer must be in the PATH statement

Answer

1. Right click on "My Computer" then select properties

2. Select "Advanced Tab"

3. Press [Environment variables] button

4. Select "path" in the bottom list 

5. Press [Edit] button

6. Add Exchequer directory to list.  Note you should already have a reference to the BIN sub directory.  Remove unwanted references to Exchequer

Or

Remove any unwanted references to Exchequer in PATH using above method and then run SETPATH.EXE from the "wstation" sub directory of Exchequer

and tick all tick boxes

 

In a dealer environment this message may need suppressing.  If the word "EXCHPATH" is in the path, even though the directory may not exist, then the message is suppressed.

I have upgraded PostTrans but it is the same version?

Nothing makes sense, how can I un-install and reinstall PostTrans

Reason  

If you have more than one installation of Exchequer, you may have installed PostTrans in a different place

Answer

1. Open DOS prompt

2. Navigate to the Exchequer directory

3. When in Exchequer directory type "RegSvr32 PostTran.dll" this should then say

   

4. Now open excel, go to "Tools >> Add ins" untick all references to PostTrans

   

5. Press [OK]

6. Next go to "Tools >> Customize" menu:

   

7. Select "Post Transaction" entry then press [Delete] button to delete toolbar

8. Close Excel

9. Open Excel

10. Now open excel, go to "Tools >> Add ins", now press [Browse] button

11. Find Exchequer directory and select "PostTrans.xla"

12. Answer NO to next question

13. Add PostTransLookup.xla if you use it, in a similar fashion

14. Close Excel

15. PostTrans has now been re-installed to new directory

When I post a transaction I get an error 3 on Client/Server system.

Go into registry and delete "HKEY_LOCAL_MACHINE\Software\Btrieve Technologies" and "HKEY_LOCAL_MACHINE\Software\Btrieve Technologies" from the tree.  Then run EntReg.exe in the Exchequer directory to re-configure.  Problem should now be fixed.

When I start Excel I get an Automation error with a large negative error number.

Reason

The PostTrans COM object cannot be found.  Each COM object is registered in the registry, but your settings in the registry are wrong.

Answer

Firstly be very careful!

Run “regedit”.

Make sure the cursor is at the top of the tree on the left hand pane of the window

Click on “Edit” menu and select “Find”

Enter “PostTran” in the find window.

Press [OK]

RegEdit will then move to the first entry for this key.  Select the large key on left hand side:

This should end in “0559C83}”

Right click and select “Delete”.

Now press [F3], to search again.

RegEdit should now find another entry:

This should read in “PostTrans.Exch

Right click and select “Delete”.

Now run Excel and use PostTrans, problem should now be fixed.

PostTrans needs at least version x of the Exchequer DLL toolkit, but you have version y

When installing, PostTrans should upgrade your DLL Toolkit automatically (EntDLL32.dll).  But PostTrans could be seeing the wrong version because:

Reason  

Other software has down graded it

Answer  

Reinstall PostTrans

    OR

Reason  

The file was locked when you installed PostTrans

Answer  

Reinstall PostTrans

    OR

Reason  

You have more than one installation of Exchequer, and your PATH statement points to more than one installation of Exchequer. 

Answer  

Edit PATH statement to point to your current copy of Exchequer

Right click on "My Computer" then select properties

Select "Advanced Tab"

Press [Environment variables] button

Select "path" in the bottom list 

Press [Edit] button

Remove unwanted references to Exchequer

You should leave a reference to the main Exchequer directory and the BIN sub directory

PostTrans needs at least version x of the Exchequer COM toolkit, but you have version y

Reason  

The version of PostTrans you are using, requires the very latest version of the COM Toolkit, which may not be included in your installation of Exchequer.

Answer  

Get hold of the latest version of the COM Toolkit, either from Exchequer or it may be on our PostTrans download page, and install in Exchequer directory

    OR

Reason  

You have multiple installations of Exchequer and the resistery is pointing at the wrong version of EntToolk.dll.  

Answer  

To resolve run EntReg.exe from Exchequer directory and tick register COM Toolkit

 [ Home ] [ Up ] [ More about Exchequer Software ]  [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: January 24, 2008