| Author |
Message |
| Registered: March 14, 2007 | Reputation:  |  Posts: 1,029 |
| | Posted: | | | | I'm planning to make my own Credits Editor publicly available. However, it is based on Excel 2000, and I don't know if it is compatible with newer Office/Excel versions.
So before I go through the hassle of polishing up the UI and writing documentation, I need some people who can do a basic functionality test with Excel 2002, Excel 2003, and/or Excel 2007. If you have any of these versions and if you are willing to do some testing, please let me know.
You may wonder, why bothering with another Credits Editor if there is already a pretty good one by TomGaines.
Personally, I think that an Excel-based Credits Editor has greater flexibility when it comes to moving or copying data around. The Office UI is quite sophisticated and any stand-alone application has a hard time matching up to this. Same goes for other Excel features like Outline (useful for structuring credits by dividers), AutoFilter (e.g. quickly find those entries that have a BY or CreditedAs), etc. | | | | Matthias |
|
| Registered: March 29, 2007 | Reputation:  |  Posts: 4,479 |
| | Posted: | | | | Quoting goodguy: Quote:
I'm planning to make my own Credits Editor publicly available. However, it is based on Excel 2000, and I don't know if it is compatible with newer Office/Excel versions.
So before I go through the hassle of polishing up the UI and writing documentation, I need some people who can do a basic functionality test with Excel 2002, Excel 2003, and/or Excel 2007. If you have any of these versions and if you are willing to do some testing, please let me know.
You may wonder, why bothering with another Credits Editor if there is already a pretty good one by TomGaines.
Personally, I think that an Excel-based Credits Editor has greater flexibility when it comes to moving or copying data around. The Office UI is quite sophisticated and any stand-alone application has a hard time matching up to this. Same goes for other Excel features like Outline (useful for structuring credits by dividers), AutoFilter (e.g. quickly find those entries that have a BY or CreditedAs), etc. I think it is a very good idea. Generally what you do is very useful, and will help many users. I also use Excel 2000, but I'm anyway ready to do some tests if you want. | | | | Images from movies |
|
| Registered: March 14, 2007 |  Posts: 2,366 |
| | Posted: | | | | I very much like this idea but I also only have Excel 2000 so I can not help you I'm afraid.  | | | Martin Zuidervliet
DVD Profiler Nederlands |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Quoting surfeur51: Quote:
I also use Excel 2000, but I'm anyway ready to do some tests if you want. Thank you (and to Martin as well). However, there is no real need for testing it with Excel 2000 - I have extensively used this version since DVDProfiler 3 came out. I'm mainly concerned about compatibility issues with newer Office versions, that's why I specifically asked for people who use them. BTW, If anyone is wondering what it currently looks like:  | | | | Matthias |
|
| Registered: March 13, 2007 | | Posts: 793 |
| | Posted: | | | | goodguy, I have both Office XP and Office 2003. You can send me the files and I'll test it out. Just outline what specific things you need tested first though. |
|
| Registered: March 14, 2007 | | Posts: 273 |
| | Posted: | | | | Hi goodguy,
I'd be willing to test it with Excel 2007 (German and English language pack). I'll PM my mail address...
I might not find much time before the weekend though. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Thank you, RossRoy and detlefs. I will contact both of you via PM when I have a testing scenario ready. | | | | Matthias |
|
| Registered: March 13, 2007 |  Posts: 519 |
| | Posted: | | | | I also have excel 2007 that I can test with. | | | | Stuart |
|
| Registered: March 15, 2007 |  Posts: 1,982 |
| | Posted: | | | | Matthias, if you are intested to test for this too I use OpenOffice 2.2
Just send me a PM if you want to test this one too. |
|
| Registered: March 13, 2007 | | Posts: 775 |
| | Posted: | | | | I'm on 2007 too, count me in! |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,436 |
| | Posted: | | | | Quoting AESP_pres: Quote:
Matthias, if you are intested to test for this too I use OpenOffice 2.2 I also use OpenOffice (although I upgraded to 2.3 already...  ) I am not very hopeful on this, as the macros from Excel don't usually carry over very well, but I would be very happy if this would work! | | | Achim [諾亞信； Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative) |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 1,029 |
| | Posted: | | | | Re: OpenOffice 2.2/2.3
Is this supposed to be compatible with VBA and the Office/Excel Object Model? If yes, there might be a chance to get it working in this environment as well, if not, then there is nothing I can do, since I don't have OpenOffice.
Anyway, the main goal is to ensure compatibility with newer MS Office versions. If that succeeds, I will make a public version including source code available, and, in case I'm unable to do it myself, I can provide assistance to anyone who feels up to the task of making it work on OpenOffice. | | | | Matthias |
|
| Registered: March 23, 2007 | | Posts: 317 |
| | Posted: | | | | Apparently Novell has done some work to get OO supporting VBA and the Excel Object Model, but I'm not sure how well it works ATM. I'd say 'give it a try'.
Stuart | | | This is a sig... ... ... yay...
Don't understand? Maybe DVDProfilerWiki.org does! |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| | Posted: | | | | Quoting goodguy: Quote:
You may wonder, why bothering with another Credits Editor if there is already a pretty good one by TomGaines.
Personally, I think that an Excel-based Credits Editor has greater flexibility when it comes to moving or copying data around. The Office UI is quite sophisticated and any stand-alone application has a hard time matching up to this. Same goes for other Excel features like Outline (useful for structuring credits by dividers), AutoFilter (e.g. quickly find those entries that have a BY or CreditedAs), etc. My editor also started out as a Excel sheet in the beginning. But soon people were asking for a version which does not require Excel or will work with OpenOffice. At the time I looked into OpenOffice and its makro language. It is totally different to VBA and I also did not find any converters online. The porting would have to be done manually which did not look trivial. | | | 
 |
|
 | JonM | | Registered 28 Dec 2000 |
| Registered: March 13, 2007 | | Posts: 343 |
| | Posted: | | | | I know Excel 2000 is completely interchangeable with 2003. Not so sure about 2007; I know it isn't backwards compatible, but that isn't an issue. If it's any help, my Access 2000 database, heavy with VBA, runs in 2007 with no issues whatsoever. | | | Jon
"When Mister Safety Catch Is Not On, Mister Crossbow Is Not Your Friend."
 |
|