3 issues hindering CSV File Creation - Modification Help Request

Good day!

I am stuck in a bit of a problem despite of a brilliant code that was provided by a Forum Guru. It has got absolutely nothing to do with the code but the way my data gets generated. With due respect to the previous assistance. I need a little customization in this code to take care of my data related inevitable issues> that I have been struggling with over the last few days…

Really appreciate all your help and guidance….

The code works well with sample2 but doesn’t with sample3 due to the following reasons:

Issue: Column D values (ID) / Time / Phone or values are missing
Modification Requested: Ignore the entries where the - Column D values (ID) / Time / Phone or values are missing and generate the file

Issue: Time format isn't correct in Column O
Modification Requested: Format the time to general. To make the code work. (I do this manually by: text-to-column" - Delimited - Next - Next – General)

Issue: Some of the cells in column U (example U7 and U12) appear to be blank, but they aren't
Modifications Requested: On filtering the blank cells in Column U and pressing delete the code works – If the code can do this as well please..


Some background on what the code does:

• Creates a CSV file
• The macro searches the non-blank cells in column U of the source report (similar to the attached sample2)
• For all non-blank cells from Column U. It picks the numbers in column H and paste them into Column A of a CSV file after formatting so a number like 1-111-111-111 becomes 1111111111
• In the next step, it picks the numbers for the same rows from Column D of the source file and pasts them as they are in Column B of the CSV file
• In the last step, it appends the current days date in Column C of the CSV file and concatenates it with the Time values in Column O of the source file as after formatting as “Text” (Example: 5/23/2013 10:49:25 AM)

Thank you well in advance to help me sort this puzzle.


Warm regards,
ILI

Need some assistance please. I am totally stumped on this. Such an irony a brilliant solution can't be used due to some formatting issues, just hoping someone could help on this.....

Little tweak needed. Please help modify.

Thanks a bunch in advance.

Could anyone please advise on this. I'll be greatful. The data format has put a break on my project completeion.

Please help modify.

ILI,

Updated code to account for mentioned discrepancies:

Please Login or Register  to view this content.

Sorry It just did. Perhaps the CSVs need to be saved in a different folder. I was trying to save them in the same folder as the destination files.

Sorry...I'll test more.

Thanks!

You can change where the CSV files get saved to by updating the italicized portion:
ActiveWorkbook.SaveAs folderpath\filename.csv, xlCSV

Responded in your other thread