can I run a macro when I open a specific doc.

macropod · #5 01-12-2012, 02:22 AM

Quote:

Originally Posted by shreked

Is there any way that I can get a message box come up saying "please choose template that applies" when it opens up the "open box" to click on what file to open.

Yes, but you're really not going about this the right way. Be that as it may, add:
MsgBox "Please choose the template that applies"
after:
With Application

Quote:

Originally Posted by shreked

And being a pain can I close the original document when the 2nd doc opened.

Yes, add:
ThisDocument.Close SaveChanges:=False
before:
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for highlighting specific number of words	icsjohn	Word VBA	2	12-07-2011 06:44 PM
Need help extracting specific text from one doument to another with macro/VBA.	zsmithku	Word	1	04-15-2011 03:46 PM
Macro request: open on event	infotech	Outlook	0	12-08-2010 06:40 PM
Macro to open template not working	Brandi	Mail Merge	2	06-24-2010 09:29 AM
Word attachment on an E-mail-macro to open attachment &	nablady	Outlook	0	11-28-2006 03:00 PM