MVSFORUMS.com

[pvaraju]

I need to send a email attachment as an excel format thru JCL and the excel should be in password protected.Is it possible?.If its possible can you please post the process.

Thanks in advance.

Thanks,
Sri

[dbzTHEdinosauer]

well,
you tell me what application on the mainframe will create an excel formatted file,
and I will ask microsoft where the password is contained in the excel file and you can
just plug it in there.
_________________
Dick Brenholtz
American living in Varel, Germany

[semigeezer]

You'll probably have to transfer the file to a PC and use some sort of key/mouse simulator software to bring u excell and add a password. I'm assuming that a password encrypts the data. I haven't looked.
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

[jhandu]

pvaraju, can you please post the process to generate an excel file in mainframe?

[jim haire]

I have done this in a couple of different ways.

If you know that the data you want to put to Excel does not contain commas, separate the fields in your file with commas on the mainframe.
Then FTP your file to your PC and open as a .CSV (comma-separated values).

If your data does contain commas, you can separate the fields with a TAB
(hex 05). Then FTP your file to your PC and open as a .PRN file.

[Terry_Heinze]

I think Sri wants to go in the opposite direction, Jim. I think he wants to send an Excel file from an e-mail attachment to the mainframe and have the mainframe recognize it as an encrypted, password protected Excel file.
_________________
....Terry

[semigeezer]

I was under the impression that the data would come from MVS and be generated into an Excel spreadsheet that should be password protected and then sent via email or FTP or whatever to another system. My thought was to create a CSV file on the mainframe, download that to a workstation, start excel using a mouse+keyboard scripter like AutoHotKey (wonderful tool) and do the conversion to excel + add password at the PC then upload it to the host again and do the email/FTP/whatever. No?
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

[papadi]

Speaking of impressions, mine was that the goal was to have a password-protected, excel-ready file created on the mainframe and sent to wherever as an e-mail attachment.


_________________
All the best,

di

[pvaraju]

My requirement is to generate a report in cobol and send that report as email attachment in excel and that attached excel should be password protected.

I am able to send it as an email attachment (excel) by creating a .csv file and then in next step used sasemail step(which used in our shop).But not able set the password protect for the excel.

Thanks for all ur responces.

Thanx,
Sri

[papadi]

While it can be imported into Excel, a .csv text file is not an Excel file (which are often .xls or .xlsx).

If a password is really needed, it could be added on the target system. If a file is sent to "Fred", is the id/pswd associated with Fred's e-mail not sufficient?
_________________
All the best,

di

[petluri]

Why don't you use PKZIP with a password?

[semigeezer]

zip passwords are extremely weak. They can usually be cracked in a minute or so with commonly available freeware. I don't know if excel passwords are as bad -- they may be.
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

[kolusu]