Code to update macros automatically in startup folder

dwirony · #1 01-10-2017, 11:11 AM

I'm sharing a lot of my code with coworkers and would like to be able to write in an option to update the code automatically as I release more.

I'm thinking that by using Auto_Open the code will read down a specific file path, and if "newcode.dotm" exists, it will bring up a userform that gives the user the option to copy that code to the startup folder. Is this option available via wordvba? I know it's someone hard to access the startup folder while word is being used, so is it possible to have code close word, replace "oldcode.dotm" with "newcode.dotm" in the startup folder, then have it reboot word?

I know this might be a bit of a stretch (I could always have people manually update it), but they're not very tech savvy and this option would make things very easy for everyone. Thanks for any input/ideas as to how I could make this work.

This is how I'm thinking of starting it

Code:

Function FileThere2(FileName As String) As Boolean
    FileThere = (Dir(FileName) > "")
End Function
Sub UpdateCode()
If FileThere("G:\SalesOffice\Public\user1\newcode.dotm") Then
    'FileThere is a private function that searches for the newer version in the G Drive
MsgBox Prompt:="oldcode has detected that there is a better version. Oldcode will now prompt you to download newcode", _
 Buttons:=vbExclamation, _
 Title:="Outdated"
frmDownloadNewCodeShow 'This prompts the user to download new code.
Else 'Do Nothing
End If
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to Access Building Block Template in Word 2013 Startup folder	rdross51	Word VBA	2	06-01-2016 07:05 PM
How to automatically enable the macros upon opening a file with macros?	laurieli	Office	7	01-17-2016 08:56 AM
How to constantly and automatically copy the contacts from a shared folder to my private folder?	Paulo	Outlook	0	08-16-2015 12:06 PM
Help with macros, what's wrong with my code??	cc.caroline15	Excel Programming	6	01-12-2015 10:04 PM
Office Startup folder not default trusted location - shortcut	Charles Kenyon	Word VBA	0	08-27-2012 09:36 AM