Re: Need to automate the FTP of EXCEl file to Mainframes

On 17 Apr 2007 23:17:07 -0700, svpnunna@xxxxxxxxx wrote:

I need to automate the ftp of execl file to mainframes and read it
through a cobol program.
I am reading thru cobol program after saving it as a text tab
delimited file.
But now want this conversion of excel file to text tab delimited file
to happen wothout using a macro. can someone help me out?

Macros are how you automate exporting Excel data. I suppose you
could write a program using a different language to do the exact same
thing that a macro does, if you like the challenge of more work.
.

Relevant Pages

  • Re: Need to automate the FTP of EXCEl file to Mainframes
    ... I am reading thru cobol program after saving it as a text tab ... But now want this conversion of excel file to text tab delimited file ...
    (comp.lang.cobol)
  • Re: Need to automate the FTP of EXCEl file to Mainframes
    ... I am reading thru cobol program after saving it as a text tab ... But now want this conversion of excel file to text tab delimited file ... How do you expect the Excel spreadsheet to export itself as a Tab delimited ...
    (comp.lang.cobol)
  • Re: Need to automate the FTP of EXCEl file to Mainframes
    ... Use VB to extrat the excel into a Tab Delimited file. ... I am reading thru cobol program after saving it as a text tab ... But now want this conversion of excel file to text tab delimited file ...
    (comp.lang.cobol)
  • Need to create a tab delimited file that has comma seperated column headings
    ... I need to create a CL program that will take a PF, and create a tab ... delimited file that has comma seperated column headings as the first ...
    (comp.sys.ibm.as400.misc)
  • Need to save file for mainframe
    ... I have data that has been pulled in from a query in access and saved as a tab ... formatting this data into the proper specs for upload to a MainFrame. ... Excel I have created a custom filter to accomplish this task. ... I end up with a tab delimited file instead of being ...
    (microsoft.public.excel.misc)