Ok folks...

Some of might remember that a couple of days back I was talking about 'how to make a nice hand-out of all music stored on the Empeg'. At the same time I was already playing around with VBA for MS-Office, and this weekend I've completed a macro for this. Its still very beta stuff, so keep me informed for bugs or extra features required.
Let me know how you think about this toy!

What is it
It's a MS-Word 6.0 (and up) document including a macro which uses the Empeg database file (in CSV-format) as input for generating a catalogue. This database file can be exported from Emplode or jEmpode (be sure selecting CSV-format).
On request the macro generates:
- Table of Contents
- Overview of albums with their title - artist
- Overview of artists with their songs

What does it need
- MS-Word 95/97 (6.0 and up)
- Excel (since its interfacing to Excel)
- A printer

How to use
Unzip the EmpegMusicCatalogue.zip and open the document inside Word. Next execute the macro by ALT+F8 and play the 'StartGeneratingCatalogue'-macro.

What do I want
Nothing
Just deliver me an e-mail if you like it with bug reports and recommendations.

Another request from me
Who can store this on www.riocar.org? I do not have a server to put my code there.

Sorry, but the download does not work...Maybe your file is to big!

bye

Seems that the attachment gives problems.
The size seems be the problem (313kB, while 200k is max), so stay in touch while I'm trying to fix the problem.

MS-Word seems to make itself crazy regarding picture handling and blowed the filesize. I've deleted and re-inserted the pictures and the size of the ZIP has now shrunk from 313kB to 91kB.

Give it a try..

It was indeed the size.
Have fixed it now by new attachement in a reply

I keep getting this error "The macros in this project are disabled. Please refer to the online help or documentation of the host appliucations to determine how to enable macros" any ideas?

nevermind figured it out, you must have excel running int he background

new situation, im getting an "Run-time erroe '1004;: Methond 'Range' of object '_Global' failed" any ideas?

Ditto.



Tom

ya kinda of a bummmer, hopefully u can get it fixed soon it looks really great from what i see, i could u a nice soild catalog thats for the effort you are making

Should we take up a collection for poor college student Justin, who apparently cannot afford the shift-key and punctuation upgrades for his keyboard?

Oh man...
I simply hate that VBA-stuff. They call it sometimes the programming language for dummies, but I prefer bare C/C++ programming.

About the problems you ran into:
I've executed this macro at my home place (Office97) and work (Office 97 + 2000), both running without problems. The excel problem sounds strange to me because windows should automatically shoots the excel object.

The other one (runtime error) seems to be related to the excel.

Question
What office package you are using

Give me a moment to investigate it. Unfortunately this will be this afternoon since I've a couple of customers looking over my shoulders at work.

Thanks anyway,

EiSl

Bitt, please take note of the time i wrote that post. Its clear that it was very early in the morning/late in the evening, and i was still a little bit drunk. Give me a break.

Im running The Office Xp Suite, that might have something to do with it. I updated all my VB Runtimes as well still no dice.

It only runs for me only with Excel closed prior to running (WinXP & Office XP). I've noticed that at times, Excel does not show on the taskbar but is present in task manager (not your problem but may explain why others are having problems and getting the 1004 error).

However, something isn't working properly for me......

The "Albums" page empty and on the "Artists" page I just get a single column of numbers (one per line, aligned to LH margin) which in fact are the track lengths (they also appear in column D "length" in Excel).

Hello all,

Seems that different people all have the same problem. I will suggest not download this until further notice.
I the meantime I will dive into the trouble.
To give you all an impression what this macro actually produces I've attached an example.

Sorry for this inconvenience, for me its of course a bad start...

You will hear soon something...

EiSl

Hope you get it fixed soon. I tried it (didn't work for me either on W2K), but the result looks promising!

Frank

I think any start is infinitely better than not trying at all. I'm impressed by what you've done so far. It's more than I could do.

Hello folks,

I've made some modifications. The range errors was because of different layouts of (j)Emplode CSV-files. I didn't checked that (ough) but I thought it was the same. Well... Emplode exports 30 columns, jEmplode only 17. So a small redesign is made.
I've also made a option making the interfacing to Excel visible. You can checkmark this. As a last test I've build myself a new catalogue using the CSV-files of both (j)Emplode -> works fine (for me )

OK lets try this one. Keep me in touch for other errors. If you get an error, then also try the other CSV-file. At the end I can provide someone the password to unprotect the macro so debugging is easier.

Cheers,

EiSl

I havent been able to get past the "Macros in this project are disabled..." error... I have excel open, i've tried with both files in excel, and excel closed. OfficeXP

edit: ok, I needed to reopen your file, but upon doing so, I still get a "could not load object because it is not available on this machine", VB?? Then I hit run, and get the error again, then when I get the screen to load my database, I get the visual basic error: "Compile error in hidden module: IntroDlg"

same message here...I am using also Office XP!

I have Office 2000 and I am getting the following attached error.

"System Error &H8000FFFF (- 2147418113).Catastrophic failure "

Where does the CVS file need to reside for the macro to find it?


This sounds like it is a great thing. I cannot wait use it.

looks like i got it working, its seems to be im getting the results now THANKS!

ok i got most of the way thru then i got a Run-Time Error '13' type mismatch. This ended on page 73, also no table of contents, and the 2 col check mark is greyed out on XP, im just gunna get a version of office 97 to run it, and stop complaing but i do love this it super cool. at least we are getting somewhere

also i can go ahead and host it for you on riocar.org

I don't think this is an error. Go to Tools click on macro, than security. Lower your security option to allow this macro to run.

It works for me. Thank You! Is it possible to sort Artist - Album - Title? Do you expect to add the Pin Number? Even if you do nothing else its very nice. Thank You for your hard work.

So did anyone figure out how to get by the "Could not load an object because it is not available on this machine." error in XP?

- Jon

That works MUCH better

It does however throw up a type mismatch (error 13) when it encounters a missing Artist name (column M in Excel).
Excel represents this missing field as a #NAME? - I think a fairly simple "on error do <something> resume next" in VBA would probably fix this adequately.

yeep, now it works! Thanks for your help!