Define string in For Next loop

[Lyric]

I am trying to create a new worksheet in a separate workbook (Web Transfer Worksheet.xlt) for each instance of a unique cell D value and cell C value combination in the original workbook (strDate + "*_OmniTransferErrorReport.csv"). I imagine I will need to add an "If sheet already exists, skip to next" type of statement, but I am stuck on even getting it to work once. I am getting a type mismatch error on strNewSheetName = Cells(i, "D").Value + " " + Cells(i, "C").Value


Any thoughts?

Please Login or Register  to view this content.

[arlu1201]

Instead of "+", trying using the "&".

[111StepsAhead]

Please Login or Register  to view this content.

This won't solve your problem but will make things easier to work with possibly.
I moved some stuff around. You will have to play around with it a little bit but I added the code to work with the other workbook easier.

[Leith Ross]

Hello ,

There are seven deadly characters that can not be used in workbook name.

Illegal Characters in a Workbook Name

? / \ : [ ] *

[Lyric]

Instead of "+", trying using the "&".

Thanks arlu1202...

I updated to this:

Please Login or Register  to view this content.

And that part works now.

However, I am now getting caught on:

Please Login or Register  to view this content.

Leith, I wonder if you were referencing this statement. I am using * as a wildcard and it does work in a separate sub that I use to open that workbook:

Please Login or Register  to view this content.

Is the * in my activate code causing to error? If so, why would it work in the open statement?

[Lyric]

Still need help please. Thanks!

[Lyric]

I still need help on this one. Thanks!!

[arlu1201]

Will try something tomorrow if not will push it forward to the experts

[arlu1201]

However, I am now getting caught on:

Please Login or Register  to view this content.

Trying using the & again on the above line.