VBA - My Outlook Calendar.dot

[Abenser]

I having problems using the My Outlook Calendar.dot template from the
Slipstick website (sorry I can't attach it, file type not supported).

I downloaded the .dot file and with the help of someone in IT we
modified the code to pull event details from outlook onto the resulting
calendar report. I was able to use it successfully for a few weeks and
then all of a sudden the .dot stopped working. It gives me a runtime
error whenever I try to launch it.

I'm not familiar with VBA at all but I used the debug tool to see where
the code "breaks". It seems to happen at Ln 3046 - 3047. Now, I could be
completely wrong on that one - but I thought I'd take a stab.

I have tried using the .dot file on other machines on the network and I
get varying results. Some machines give a runtime error on first launch.
On others, I can use it for a few times and then I get the runtime
error. There is no pattern that I can see, but thought I'd post this on
the forum to see if anyone else has had issues with the My Outlook
Calendar.dot file or could look at the code and tell me what's up.

Thanks for your time - Angela

 

[Ken Slovak - [MVP - Outlook]]

If the code in the form was modified then there's no way anyone could figure
out why your version is failing from looking at the original code.

 

[Abenser]

We only modified the section of the code that pulled fields from outloo
onto the resulting .doc, nothing else. And, the .dot worked fine afte
that for a few weeks and then something happened and it doesn't work fo
me now.

I think I need to hire someone that knows VBA and can look at th
solution and see what is happening in our environment that is causin
this thing to buck.

FYI - I've been sucessful in running the modified .dot on othe
machines in the office - some not all will give the error, and the
eventually running the .dot on those machines will bring the runtim
error. One machine in the office currently still can run the .dot wit
no error and I can print the calendar needed. I anticipate that thi
work around will eventually fail. I'm ust trying to figure out what'
going on before I get the runtime error on that machine so I ca
continue to provide a calendar erport to the boss.

- A

Thank

 

[Ken Slovak - [MVP - Outlook]]

From what you say you first need to figure out what's different where it
works and where it doesn't work. Once that's solved you should be able to
get it working everywhere.

 

[Abenser]

OK. I'm going to show this thread to IT. They think it's the code an
that they can't fix it cuz they didn't write it. But if it works fo
some, not all, it is environment, right? Hmmm...it's a mystery is wha
it is. Thanks for contributing. I will let you all know if I figur
anything out.