Thanks very much. I was really waiting for that. Not yet fully tested, but it looks great.

Thank you very much, it's really appreciated, even if I have a love-hate to Excel 

Thanks, Matthias.  I have long enjoyed using Tom Gaines program, but I am quite familiar with Excel and have a problem working with Tom's program, since it has the look of Excel but hasn't implemented all of Excel's features.  It's frustrating to try to do something and not remember that Tom's program won't do it.  Plus, you've added some of the features that Tom doesn't (credited as, BY, etc.)

I still appreciate Tom's work - especially since he was there first.  But I think your Editor will be something I am more comfortable using.  Especially since I already have Excel.  Of course, if I didn't have Excel, Tom's program would be the way to go.

Quoting Dr. Killpatient:

Quote:
Quoting goodguy:

Quote:
intuitive Office user interface

Wait, what?

       

Quoting richierich:

Quote:
Is there any way to import my whole collections actor or crew list in to the CreditEditor? I want to see how many have birth years allocated for example.

I do this with a SQL query in CCViewer:

SELECT Title, Name, Role, BirthYear, IsCast FROM Profiles p INNER JOIN CastCrew c ON p.ProfileID = c.ProfileID WHERE BirthYear <> 0  ORDER BY Name, BirthYear

Quoting kdh1949:

Quote:
I still appreciate Tom's work - especially since he was there first.  But I think your Editor will be something I am more comfortable using.  Especially since I already have Excel.  Of course, if I didn't have Excel, Tom's program would be the way to go.

You also have to remember, that my tool was created while Profiler 2 was current. I only implemented partial Profiler 3 support because of the many requests 
I never planned extending my editor as I myself edit my cast and crew in the Viewer and transfer from there (advantage: It automatically sets common names, if the same alias has been already assigned a common name in another profile), so I appreciate that Matthias has taken on the editor and probably will replace my old editor.

Quoting goodguy:

Quote:
Quoting richierich:

Quote:
I want to see how many have birth years allocated for example.

...
However, you can export your collection to XML and run it through an XSLT script to search for these data. I posted a quick & dirty implementation in this thread in the TechSupport forum.

If, on the other hand, you want to investigate names with multiple or partial birth years: Those will of course show up when you run a Name Variants report.

Matthias,

I have tried your Credits Editor with both Excel 2003 (here at work) and Excel 2007 (at home).  When I open the worksheet I get a security warning about the macros.  In Excel 2003 a window opens up and I have an option to enable macros.  This is fine.  But in Excel 2007, I get a message that macros are disabled.  So far, I've seen how I can enable macros for ALL worksheets, but not one for just the worksheet I'm running (i.e., your Credits Editor).

Can you (or anyone) tell me how to enable macros for this worksheet without enabling them for ALL worksheets?  I trust you haven't written something that will bollocks up my computer, but I don't know if I can say that about every worksheet I get.

[I thought I was fairly proficient in Excel, but I'm just beginning to use 2007.  I bought the program for home use thinking that they'd soon upgrade our software at work, but it looks like this time I'm far ahead of the decision-makers at my workplace.]

While I haven't had a lot of time to work with Credits Editor yet, what I've seen I like.  It's another useful tool you've given us, Matthias.