VB Code to copy content of each sheet and save in notepad

[rizmomin]

Hello:

Please refer to attached file.

I need VB Code to perform following task.
Copy content of each sheets except Sheet "Payroll" into Notepad and save each at C:\Temp as NameofSheet.iif
In this case the file saved at C:\Temp would be

LJ.iif
EL.iif
PayrollTaxes.iif



Let me know if you have any questions.
Thanks.

RIz

[WideBoyDixon]

Give this a try:

Please Login or Register  to view this content.

WBD

[rizmomin]

Hello WideBoyDixon

Thanks a lot, it works

Riz