Name Requirement Source Applied on
Michelle AA Vendor 12/1/2015 0:01Validity Expired
Michelle BB Jobsite 12/1/2015 0:02Duplicate Submission
Michelle CC Vendor 4/14/2015 0:00Valid Submission
Michelle DD Referral 12/3/2015 0:02Duplicate submission
Nathan ee Referral 12/4/2015 0:02
Name Requirement Source Applied on
Michelle AA Vendor 12/1/2015 0:01Validity Expired
Michelle BB Jobsite 12/1/2015 0:02Duplicate Submission
Michelle CC Vendor 4/14/2015 0:00Valid Submission
Michelle DD Referral 12/3/2015 0:02Duplicate submission
Nathan ee Referral 12/4/2015 0
>
> Hi Paul, and thank you for your assistance
>
>
Turns out Excel has a 30 character naming limitation for Sheets hence the
reason for the unnamed sheets.
I have updated the code to reflect your suggestions as well as
ActiveSheet.Name = Left(cVal, 30).
Works a treat now.
Thanks again.
Mark.
CSV files are funny animals.If I open/read the file as a text stream, and try
to parse each line using a comma (,) delimiter,I get a different result than if
I were to open the .csv file in excel.
Consequently, what I've done in the past is read the file and write the line to
another .csv file w
I'd give this a try:
first of all (irrelevant to the problem)renaming the sheet should work as:
Activesheet.name = cVal
as for the problem itself,I suspect there's another error occurring that is NOT
Error 1004.I'd suggest changing the section to:
On Error Resume Next
