It is currently 19 May 2012, 04:54

News News of Arixcel forum

Site map of Arixcel forum » Forum : Arixcel forum

Discussions related to Arixcel products and Microsoft Excel.

Date format in QIF files

Hello Igor,

I think I might have discovered one more little bug. When I download QIF files from my bank (especially one bank in particular) and attempt to import the file, I get a small pop-up message asking me to select what "12/02/2009" means. I'm given 2 choices (1) 2 December 2009 (2) 12 February 2009. And I choose the option 1, 2 December 2009. Arixcel then imports the data using option 2, though I ...
Read more : Date format in QIF files | Views : 1405 | Replies : 3 | Forum : Arixcel Accounts support forum


Trial Balance

One thing that I would like to use this program for is to help me keep track of my balance. I know that it will give you the Closing balance for any accounts you have set up. I would like to be able to enter some possible transactions to see where my money stands if different amounts are paid to different people (separate of main information). All of this may be changeable to see how ...
Read more : Trial Balance | Views : 1011 | Replies : 1 | Forum : Feedback and wishes


Arixcel toolbar

Hi again, Igor,

I have seen this happen a couple of times now, so I thought I'd check and see if this is something you have encountered yourself.

This morning I had my account workbook and another Excel workbook open. I was working on my accounts workbook and then switched over to work on the other Excel workbook. After completing my work with the Excel workbook I closed it. However, I found that my Arixcel ...
Read more : Arixcel toolbar | Views : 1815 | Replies : 4 | Forum : Arixcel Accounts support forum


Copying the "Account" sheet

Hi Igor,

I have been playing a little bit more with the spreadsheets.

The question I now have is as follows:

I created two account books, the first one to give me a blue print of my 2008 financial statement and the second one to give me my blue print for 2009. While attempting to create the 2009 blue print, I wanted to copy the list of accounts that I had created in the 2008 ...
Read more : Copying the "Account" sheet | Views : 1286 | Replies : 2 | Forum : Arixcel Accounts support forum


Problem while creating a second account

Hi,

I downloaded your plug-in and created one account. I just followed the on-screen prompts without any problems. Things however started getting interesting when I went ahead and attempted to create a second account. Just following the onscreen prompts I filled in all the account details. When I clicked "Ok" I get a dialog box with an error message that says "Method '~' of object '~' failed (enACCreateRenameAccountSheet)". I tried creating the same accounts in ...
Read more : Problem while creating a second account | Views : 1029 | Replies : 3 | Forum : Arixcel Accounts support forum


How to sort a collection in VBA

We would like to share some standard code that we use in Arixcel when developing VBA or VB6 applications. Here is the first one - a procedure for sorting a collection of custom objects. It uses one of the fastest sorting algorighms with the efficiency of n * ln(n) (which is the best theoretically possible efficiency for sorting).


Sub QuickSortSortableObjects(colSortable As Collection, Optional bSortAscending As Boolean = True, Optional iLow1, Optional iHigh1)
Dim obj1 ...
Read more : How to sort a collection in VBA | Views : 8737 | Replies : 0 | Forum : Excel programming


How to allocate one transaction to many categories

One user asked the followng question:
I have just loaded bank statements from an ofx file. One of the transactions is :
Date : 19/08/09
Type : Bank statement
Description : CB CTRE LECLERC 18/08 PAU 64 // it is a comercial centre. I paid by CB card
Amount : -€64.12
Period : 2009 Aug
Category : ?

My problem is that I didn't buy only food : I bought also clothes (€14.45), scolar articles ...
Read more : How to allocate one transaction to many categories | Views : 4433 | Replies : 0 | Forum : Arixcel Accounts support forum


OFX file error ("Only one top level element is allowed...")

A small number of Arixcel Accounts users were getting the following message when trying to import an OFX bank statement:

"Error in reading OFX file (Only one top level element is allowed in an XML document)"

The problem should be resolved in version 1.25(3). If you get this error, please download the latest version of the program and install it on top of your existing installation.


 

Login  •  Register


Statistics

Total posts 75 • Total topics 34 • Total members 1117

cron