VBA - My Outlook Calendar.dot

Status
Not open for further replies.

Abenser

Member
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
 
K

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" <Abenser.477sya@invalid> wrote in message

news:Abenser.477sya@invalid...

> 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

> > Abenser
> >
 

Abenser

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




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




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




- A




Thanks
 
K

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" <Abenser.479b4a@invalid> wrote in message

news:Abenser.479b4a@invalid...

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

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

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

> - A

> Thanks

> > Abenser
> >
 

Abenser

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




A
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
G Outlook VBA and Google Calendar ("Events") Outlook VBA and Custom Forms 1
R How to copy outlook 2010 shared calendar appointment or meeting to personal calendar by vba? Outlook VBA and Custom Forms 1
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
S Excel vba code to manage outlook web app Using Outlook 10
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
O VBA Outlook Message Attachment - Array Index Out of Bounds Outlook VBA and Custom Forms 0
J Want to learn VBA Macros for Outlook. What book can you recommend? Outlook VBA and Custom Forms 2
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
A VBA Code in Outlook disappears after first use Outlook VBA and Custom Forms 1
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
B Advanced Search in MS Outlook by VBA and SQL Outlook VBA and Custom Forms 2
K Outlook Archive to PST Files by Date Range VBA Script? Outlook VBA and Custom Forms 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
S Find a cell value in excel using outlook vba Using Outlook 1
J Execute Add-In Button from VBA Outlook 2016 Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
M Slow VBA macro in Outlook Outlook VBA and Custom Forms 5
T Outlook AntiSpam with VBA Outlook VBA and Custom Forms 1
F "Move to" O365 feature to Outlook client via VBA Outlook VBA and Custom Forms 4
B query outlook using vba Outlook VBA and Custom Forms 13
J VBA to switch Outlook online/offline Outlook VBA and Custom Forms 4
M VBA to change flag status in outlook contact item Outlook VBA and Custom Forms 3
T VBA outlook, detect priority emails Outlook VBA and Custom Forms 5
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
stephen li VBA Outlook send mail automatically by specified outlook mail box Outlook VBA and Custom Forms 1
S Outlook VBA Contacts Notes Outlook VBA and Custom Forms 0
O VBA to Run Font Change on Outlook Startup Outlook VBA and Custom Forms 4
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
O VBA or other solution for Outlook tasks to OneNote Outlook VBA and Custom Forms 0
S Automatically selecting folders and deleting messages in Outlook VBA Outlook VBA and Custom Forms 7
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1

Similar threads

Top