EXCEL AND EXTRA

[FONTANDUVAL]

I start using Extra and I would like to write a macro that can read data in Excel and write it in an Extra screen ?
Thanks for any help
All the best,
Cedric

 

[calculus]

See previous post and FAQ.

Control Attachmate with VB(A)
How do I use VB(A) to manipulate attachmate (6.5+)? FAQ99-4069

Extra Basic Starter Functions
I'm ready for Extra Basic... now what? FAQ99-4087

Talking to Excel
How do I get data to Excel? FAQ99-4068

These will get you started. In truth, it's much better to go from VBA in Excel, and have Excel control Extra.

calculus

 

[FONTANDUVAL]

Hi,
Thanks for your reply.
In our problem, it is not "require" to use Excel.
So my question is better as this :
How, in an Extra macro, can I read read data in TEXT file and write it in an Extra screen ?
Thanks for your help.
Cedric

 

[calculus]

Look in the help files for "Open", "Close", "Input", "Line Input".

I use it like this:

Open "C:\windows\temp\" & LastVer & ".txt" For Input As #1

Line Input #1, Raw
-or-
Input #1, Raw
Test = InStr(Raw, "VERSION")
Close #1

calculus

 

[JonFer]

If your data are really records, I would import them into MS Access and control Extra from a VB module there. It is much easier to work with and you get the benefits of a relational DB environment.

John

http://www.interautomateconsulting.com