I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data.
PROBLEM: How can I format the spreadsheet with headers and column fonts and colors, etc. and just load the data beginning in cell A2? I can manually run the same DTF through add-in feature to keep formatting but I need this completely automated.
Software/Hardware used: excel 2007 / IBM iSeries Access 6.0
I can manually run the same DTF through add-in feature to keep formatting but I need this completely automated.
So, why can't you automate it? A macro can run the download.
Tom
Discuss This Question: 1  Reply