Write Sub procedure to format excel and write case/if statement to text file

Are you asking how to write Select Case statement?

Upload a workbook and the text file that you want after the macro.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Yes, I do need a Select Case statement in Crystal Report Syntax.

Please see attachments

This is just a rough idea about the output.
You need to check it and comment...

Please Login or Register  to view this content.

Excellent! Thank You jindon!

vbronton

You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.