5 replies to this topic

[mmeneses]

Hi to all!

I have a problem dumping data to excel spreadsheet. I came across with this problem when the program tries to dump a record of more than 65000 (excel maximum number of rows per spreadsheet).

Any idea how to dump the data to the next sheet once I reached this maximum number of rows?

p.s. I call a batch file to open an excel template.


Thanks,
Mike

[Mike Schoen]

#STAT = DDE_POKE('EXCEL',$SHEET,$RC,$$A)

Keep a row counter, and change the $SHEET to a new sheet name as needed.

[mmeneses]

When I UMSG the value of the variable $SHEET it was blank. How can I change it to a new name.

thanks and I really appreciate that.

p.s. I call a batch file to open an excel template. Does it make any difference from opening the excel directly from pro-iv?

-Mike

[SteveHoughton]

You could also try using Corel Office which allows a considerably larger number of rows in its spreadsheets than Excel.

[mmeneses]

thanks for all the reply.. I already figured it out...

[Fabiano Giannetti]

Hi,

what is the right sintax to change the sheet name.


Thank you.