Oututting Multiple lines with Formula to Excel

[AidenMc]

Hi,
I was hoping someone could help me with this, I have a report to finish off for a client they want to be able to output it to excel.
The report contains information about time, expenses and income,
They want to output time first, followed by totals, then headings for expenses, followed by the data and then totals and then income headings followed by data and totals.
I have outputted to excel before with the very basic copy file to myfile.xls type xls, but I dont have much experience with loExcel = Createobject([Excel.Application]), is there any examples of what i am looking for anywhere or does anyone have any suggestions

Regards

Aiden

 

[Mike Lewis]

Aiden,

If you already have the report as an FRX, it would be easier to use a third-party tool such as XFRX (from

http://www.eqeus.com)

or FRX2ANY. These will let you output the report directly to an Excel file, with very little code.

If you just want the report's data to be sent to Excel (that is, without the page layout, headers, page numbers, etc), you can just use COPY TO with the report cursor.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[AidenMc]

Mike,
I have the report working after a fashion ie I am using VFP 6 and i output the three different lines in the detailed band but it is not really what the customer wants, they want it in an excel format

Aiden

 

[Mike Lewis]

Aiden,

So what exactly are you asking?

If you have the report in a state where you can preview or print it, then the tools I suggested will allow you to output it to Excel. Isn't that what you wanted?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[AidenMc]

Mike,
I guess i was looking for pointers for trying to do it myself, I have download the software you suggested so I will give that a go,
Thanks

Aiden