Excel formatted template automation

[lenoj]

Hi all,

Happy new year.

Im new here in Tek-tips. Im using Microsoft excel 2007 which we need to automate the reports using visual foxpro 8 with free formatted template in excel. our client will download this excel report using (i think) using diff application.

Aattached example format


CONTENT LIST


DESTINATION MODULE TYPE: MODEL CODE: ORDER TYPE: DIMENSION(M) M'MENT(M3)
TAIWAN 1/3 355W MULTI-SOURCE PARTS 2.25 x 1.49 x 0.73 2.447

CASE NO. PACKING DATE: PACKER NET(KG) GROSS(KG) PART GROUP
C-D-0306 12/5/2008 177.54 257.54 Non-AICO

ITEM NO. BOXES PART NUMBER QTY PART NAME LOT NO. TOTAL QTY.

1 8 86101-0D190-00 200 CORD SUB ASSY ANTENNA . 200
2 4 86101-0D210-00 200 CORD SUB ASSY ANTENNA . 200
3 1 86396-0D020-00 500 NUT, ANTENNA . 500
4 13 89170-0D270-00 130 SENSOR ASSY AIRBAG . 130
5 3 89661-0DA81-00 30 COMPUTER, ENGINE CONTROL . 30
6 9 89661-0DA91-00 90 COMPUTER, ENGINE CONTROL . 90
7 13 89730-0D040-00 130 COMPUTER ASSY THEFT WARNING . 130
8
79
80
GRAND TOTAL: 1280




DESTINATION MODULE TYPE: MODEL CODE: ORDER TYPE: DIMENSION(M) M'MENT(M3)
TAIWAN 1/3 355W MULTI-SOURCE PARTS 2.25 x 1.49 x 0.73 2.447

CASE NO. PACKING DATE: PACKER NET(KG) GROSS(KG) PART GROUP
C-D-0307 12/5/2008 170.04 250.04 Non-AICO

ITEM NO. BOXES PART NUMBER QTY PART NAME LOT NO. TOTAL QTY.

1 8 86101-0D190-00 200 CORD SUB ASSY ANTENNA . 200
2 4 86101-0D210-00 200 CORD SUB ASSY ANTENNA . 200
3 13 89170-0D270-00 130 SENSOR ASSY AIRBAG . 130
4 4 89661-0DA81-00 40 COMPUTER, ENGINE CONTROL . 40
5 9 89661-0DA91-00 90 COMPUTER, ENGINE CONTROL . 90
6 12 89730-0D040-00 120 COMPUTER ASSY THEFT WARNING . 120
7
79
80
GRAND TOTAL: 780




any idea or help is very much appreciated.

thank you.

lenoj

 

[JRB-Bldr]

Rather than using a "free formatted template in excel" you might want to consider just doing this work via Excel Automation within your VFP application.

With Excel Automation you can write the VFP data to Excel in almost any manner you need.

For a good reference book on doing Excel Automation within VFP you might want to look at:

http://www.hentzenwerke.com/catalog/autofox.htm

Good Luck,
JRB-Bldr