Updating VbaProject.OTM on several users

gruiz

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
I want to update the "VbaProject.OTM" of a few coworkers, everytime I've found some new trick here on Slipstick I want to add it to our VBA bag of tricks :) (progress bars when exporting messages or when saving attachments, this little things make our life at work a lot easier)

I know the file is on "C:\Users\[username]\AppData\Roaming\Microsoft\Outlook\VbaProject.OTM" but I can't find how to update it that besides going to each computer, closing Outlook 2016 and manually copy the latest version from a shared network drive to the actual users Roaming folder.

Is there a way to make Outlook VBA "look" on this shared folder at startup and get always the file found there? I find this a hard task to do since it implies to replace the file that locked because is in use by Outlook as soon as it starts.

I though on a batch that first copy the OTM file to the right location and then starts Outlook but perhaps it exists a more elegant and on-demand way since this requires the user to restart Outlook when a change is made. I can live with that because we work phisically in the same room so its a matter of "Restart outlook, please".

I also though of importing the updated VBA Modules but is not as easy task (it is using VBA in Microsoft Access wich I many years of experience, but I've found Outlook totally different)

Any ideas? We all use Outlook 2016 32bit on Windows 10 PRO 64 bit and we have access to a common network share that acts as a repository for the latest OTM file.
Also I don't have admin privileges so I can't get into every users Roaming folder and replace the file, this also means I can't install an Addin.

Quite a challenge, isn't? :)
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
A batch file to replace the file is the easiest - my memory says they will need to open the editor once when the default file is replaced. Test it to see.

It is possible to open a different OTM using a switch - i think this is still possible in newest version. But I don't think it will work with a network path. To the best of my recollection, this does not require opening the VBEditor to enable the macros.
/altvba otmfilename
You also need to set a registry key to use the switch with Outlook 2013 and later.

Test both methods on one computer and see which works best - it may be that using a batch to copy to a local path on each computer will be the most efficient, once you set up their shortcut to use the switch.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Hmm. After re-reading this, it sounds like the registry key may be a hindrance to the switch. :(
 

gruiz

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Thanks for you help, I wasn't aware of the OTM switch :)

I'm thinking about creating a scheduled task that runs at logon and always copy the latest OTM to the right place to be sure no Outlook is running at that time. If I make an urgent change its a matter of ask for log again. Its not the best solution but it will keep all users updated at least once a day.

Many thanks again for your help, Diana! I'll keep improving the OTM based on tricks and tips found right here :)

I saw that you published an Outlook book a few years ago, is there something that covers VBA published by you or any eBook you can recommend?
 
Thread starter Similar threads Forum Replies Date
D Custom Search Folders not refreshing/updating automatically Using Outlook 0
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
RBLampert Updating from Outlook 2010 to Outlook 365 Using Outlook 0
T Office 2013 no longer updating automatically Using Outlook 2
G Mass Updating Contact form used Outlook VBA and Custom Forms 8
J Updating existing entry on shared calendar wants to send update from delegate Using Outlook 0
K Can VBA intervene when updating Internet Calendars? Outlook VBA and Custom Forms 5
S Task Update coming as email and not updating task Using Outlook 3
M search takes a loooong time since updating Using Outlook 8
T Shared calendar not updating Using Outlook 1
T Need help with finding/updating task Outlook VBA and Custom Forms 1
P Updating Last Modified Date on ThisOutlookSession Macro Outlook VBA and Custom Forms 1
TotallyConfused Godaddy Microsoft exchange 2007 stopped updating Exchange Server Administration 1
S Updating the database based on received task Outlook VBA and Custom Forms 3
makinmyway Recent Files Not Updating when Using Insert Hyperlink in Outlook 2013 Using Outlook 0
S Updating between Smartphone and PC Using Outlook 3
M Outlook 10 Inbox not updating Using Outlook 3
H Gmail not updating Outlook Home Using Outlook 17
Aalishaan Outlook 2010 Updating Inbox starts again Using Outlook 0
Alex Hall When updating shared calendar, it does not automatically update personal calendar Using Outlook 3
D Updating Registry to force new task and note items to save in a particular folder Using Outlook 1
K Excel Import Option: Need Help Updating Existing Records BCM (Business Contact Manager) 0
J Shared ICalendars are not updating in Outlook Using Outlook 2
A Updating Outlook Contact Phone Nos to international dialling codes Using Outlook 5
D Outlook 2010 - Pattern for updating task owner in generic mailbox Using Outlook 2
M Constantly updating address book Using Outlook 5
B Updating Macro to OL2010/32bit Using Outlook 8
D Multiple Users Updating Custom Form At Same Time Using Outlook 1
M Updating VBA code from outlook 2007 to outlook 2010 Using Outlook 1
D Updating a recurring meeting cuses a reminder to be sent for every occurence. Using Outlook 2
C Message Count not updating Using Outlook 2
H Cannot share calendar, global address book not updating Exchange Server Administration 1
C Updating many contacts at once? BCM (Business Contact Manager) 3
Z Updating .ics files in OUtlook 2010 Using Outlook 1
J Outlook changing from inbox/trash/sent, etc. is EXTREMELY slow since updating Windows a couple of days ago. Is there an issue with Outlook as to the Using Outlook 2
H Calendar not updating accepted appointments! Using Outlook 1
D Updating Accounts in Business Contact Manager Using Outlook 1
S Global address book, 1 users not updating Using Outlook 2
S Error updating public folder with free/busy information on virtual machine server. The error number Using Outlook 2
K Updating Contact Groups in Outlook 2010 Using Outlook 3
F updating contacts Using Outlook 1
R Resource not updating for cancelled meetings Using Outlook 1
N Outlook Anywhere Not Updating Local Cached Password After Reset - Client Stays Disconnected Using Outlook 2
T After updating Exchange 2010 from RTM to SP1, OWA clients cannot move or delete emails Using Outlook 4
T Error when updating Internet Calendar Subscriptions Using Outlook 12
L Outlook 2007 Global Address Book Not Updating Using Outlook 1
V Updating Custom Forms Using Outlook 1
J Outlook 2007 with connector hangs when updating GMail account Using Outlook 3
G Outlook 2010 Error: Not Implementing after updating Using Outlook 2
H Problem in updating Categories Using Outlook 2
Similar threads


















































Top