Roadrat's Ratogram

[Roadrat]

nice coding roadrat, r u a programmer by trade?

Not by trade, I'm self taught through need in my previous job. I did spend 18 months doing nothing but VB programming so you could say I was a professional programmer, for that period of time anyway.

[Roadrat]

I uploaded the file again with a fix which might prevent the false error message being generated in Office 2007 enterprise.

Can anyone who uses this version of office, download again, and let me know if this had the desired effect. Something I can't test for myself....

[NickB]

Hey thanks again Roadrat

Got another error, it still works after you close the debug thing but the error does come up. Here a pic:

[Roadrat]

Wow, that's peculiar, it seems to be throwing out random run time errors, there's nothing wrong with that line of code either. I will add run time error suppression code into all of the subroutines, maybe that will resolve it for you guys with this awkward version of office.

[Roadrat]

Okay, mark three now uploaded with run time error suppression.

In theory the program should not now generate any "run time" errors, they should just be ignored. Appreciate it if Nick or anyone else with Office 2007 Enterprise can check it out, I would really like to nail this one.

[Rich1969]

Hi Roadrat,

I had been doing similar calculation in excel only in a very "manual" way. This is going to save me a hell of a lot of time. Many thanks for sharing.

Hope you can get tot he bottom of the bug for those using effected versions of office.

cheers Rich

[svtbolt]

Okay, mark three now uploaded with run time error suppression.

In theory the program should not now generate any "run time" errors, they should just be ignored. Appreciate it if Nick or anyone else with Office 2007 Enterprise can check it out, I would really like to nail this one.

Working great for me in Office 2007 with no errors now. Thanks for the hard work!

[Roadrat]

........

[Christian K]

404 error - not found....

Can you post the download link again (upload) when you get a chance Roadrat I would like to try out this program, thanks.

[Roadrat]

...............