Hello,

I want to create (or fill) Excel file from Arev 3.12. Now I use dBase-bond and then convert dBase-table in Excel-form in Window Excel, but I need create more sophisticated Excel-file. What ways are available ? Can I create Excel-file from Arev, or use any bonds in Arev ?

Thanks.

Maria Cramer.

Maria,

If you want to get really fancy about it, there are books available on the Excel file format (BIFF, I believe). I have seen utilities that will actually scan an Excel file and give you information out of it.

With a little (more like a lot, methinks) hard work and ingenuity, there is no reason you could not write your own ARev - Excel export utility.

Matt Sorrell

[email protected]

For a Quick and dirty routine do the following:

F5

PDISK C:\TEMP\FILENAME.TXT

LIST FILENAME ….. FIELDNAME, other fieldnames, (ID-SUPP) (P)

Then go into excel and open the FILENAME.TXT

You will then be prompted for delimiters - use space

After the file comes in remove the page break lines etc.

Dale

For excel 97 or 2000:

Create an HTML table as a flat ascii file in Arev.

save it (osbwrite) as "export.htm" or "export.xls"

Alt tab to excel, open your file

If you want to open excel directly from Arev, download windows scripting host. Write a piece of script (openxl.vbs) to open an excel file, then you can use SUSPEND EXIT CSCRIPT OPENXL MYFILE.XLS to open the file from Arev. You can open word or send e-mail this way too.

In Excel you can create tables, formulas, and crosstabs using html.

See the book 'Excel 97 Developers handbook' from microsoft press.

hth

Bob

Or, you could simply export it as Tab-delimited ASCII, or a DBase or Lotus file.

Excel reads them all,and handles tabbed files nicely. Just drag the file and drop it on an Excel Shortcut.

View this thread on the forum...