DTF to Excel in Batch file

Slmutone

10 pts.

Tags:

Batch files

DTF

Microsoft Excel

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

Asked: January 25, 2013 7:20 PM Last updated: January 25, 2013 7:28 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Discuss This Question: 1 Reply

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

TomLiotta Jan 26, 2013 1:43 AM GMT

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

125,585 pointsBadges:

report