Export Excel records to seperate text file & compress it to protecte ZIP file

Hi,

I have around 3000 customer records.

Each records contains fields such as " customer name, user name, email ID, phone number & comments". See the screen shot:

03-03-2012 12-19-35.jpg

Requirement:

1. I want to export each record to a seperate text file with user id being the name of the file.

2. The content of the Text file should be like below :

Customer name : Andrew Adamson
user Id : adam_123
Email ID : [email protected]
Phone : 34534534
URL : http://www.google.com
Comments : Comments1


The file name should be "adam_123.txt"


3. Each file should then be again compresed to a seperate password protected ZIP file

The file name should be "adam_123.ZIP"
password that need to beset should be prompted/ user input.


Kindly let me know if this can be acheived in excel.. & if you require any more information..

Thanks in Advance.

Regards,

Firedragon..

Yes this is possible. Try googling for "Excel file save as txt" and "zip file excel macro".

If on the other hand you want somebody to do this job for you I recommend you hire somebody.

As this is an excel help forum i.e. people getting stuck with an excel problems halfway through can expect to get help and hints in solving their problem.

Those who want somebody to do their job free of charge will seldom receive any response in this forum.

Alf