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: Last updated:
Related Questions

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
    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: