Importing Dates (Maybe one for Mr Hodgson)

Although I have never got around to using these.

They used to be on the installation cd, but I guess they may be on the website. The idea was that you could exchange data in VT via an Excel website running vt objects macros.  I never got very far with it, but would like to sometime.  Once working you should be able to e.g. import sales invoices, payments etc.  They would import by transaction rather than the import journal that's built into vt.  Because of the import journal facility, I get by with that, although the 'holy grail' would be to write information to the vt data file.  Which is I guess what you are after.

I suppose we should ask if anyone has any 'objects' that they have written to give us a bit of a start.

Somebody has:

http://www.accountingweb.co.uk/anyanswers/how-retrieve-vt-tranasaction-e...

It is obviously a good idea but we have a lot of other priorities. See http://www.vtsoftware.co.uk/support/roadmap.htm

Philip Hodgson
VT Software

It baffles me too, but I think it is a case of trial and error.  Thousands of years ago I had a bit of knowledge of Basic and so I think I could grasp it.  Like most people I don't have enough time.  I would still like to get to grips with it as I can see the potential.  Ho hum back to tax returns...

Didnt really know about these.

I have the similar problems - clients using CahBook or spreadsheets that I need to get into VTT+.

Have just had a play with the examples and managed to extract all of the transactions from CashBook into an excel spreadsheet

Will now try and import them back into my VTT+ files

Will let you know how I get on if of any interest

You can open cashbook files (.vcb) in VTT+. Simply right click the file and select 'open with VT Transaction+'.

Do you have any specific reason for extracting from cashbook and then importing to VTT+?

HI

Yes - I have a couple of clients who just process their bank transactions etc which I then pick up and load into VTT+ so that I can prepare the accounts and do adjustments etc ete etc whilst they can carry on with their entries.

End of next period/year I can do the same thing

Hope that makes sense

Trevor

Could do but means that I would have to get the accounts sorted straight away and that they would have to stop processing until I was ready.

Hi,

Have just completed a macro to import transactions from a spreadsheet into a VT file send me an email if your interested in it still.

Trevor White