Software

Ask something
Discussion Locked

VBscript question using Excel 2002

0 helpful
3 replies

by bmohr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a script which uploads data from an AS400 system directly into an Excel5 file...my question is that script is written to write to an Excel5 type file....how would I define it to write to an Excel 2002 file....here are the lines of code:

Const typeExcel5 = 15

xfer.Download sysName, fileName, pcFile, typeExcel5

Thank You

3 replies

by bristar

You need to consult your script documentation to see if you can change the "typeExcel5" to another option such as "typeExcel97" or better. Probably, there is nothing in there about Excel 2002 since it is so much newer than anything developed with an AS/400 screen. You may have to live with converting it the old fashioned way -- when you load it.

You can also try to creat a DDE Exchange in where you access an open Excel file and input information directly. I use this with some of my scripts.

This discussion is closed to new replies.