How to invoke the macro correctly in the workflow

macropod · #1 07-08-2014, 02:50 AM

Quote:

Originally Posted by smndnm

The macro works when run from within the whateveritscalled=AltF11 environment. But the workflow is still broken.

If you had added the macro to the document template's 'ThisDocument' code module, it would run immediately the document is created. As for Alt-F11, have you never used Alt-F8?

Quote:

The filename and filetype changes do not occur on clicking the save icon.

The macro has nothing to do with the normal Save or SaveAs processes. As coded, it handles all the name & type definitions with it's own call to the SaveAs process. If you wanted to employ the same process for a subsequent save, it's simply a matter of running the same macro again.

Quote:

While I understand the code I am looking at (or at least it makes sense). I don't get how or when it gets invoked or even how to make that happen on my say so.

It runs automatically and you can run it manually.

Quote:

From the XXX.dotm, when I open (double click) it to a document1.docx, this macro should be invoked upon clicking the Save icon, which would perform the filetype and filename and location changes, this part doesn't work... and I am completely clueless how to even begin looking at it.

because that's not how the macro works. If all you want is to intercept the SaveAs and Save commands, simply rename the macro:
FileSaveAs
and add another macro:

Code:

Sub FileSave
Call FileSaveAs
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Suggestions wanted for improving workflow of shared incoming emails	plaidma1	Outlook	1	05-03-2013 09:33 AM
How to add a file menu item and invoke an EXE?	simplyarun	PowerPoint	0	07-21-2011 01:59 AM
margins don't set correctly	dawit	Word	1	05-10-2011 09:47 PM
TOC Not Updating Correctly	Nigel1985	Word	1	05-27-2010 07:19 PM
workflow	silviu	Office	1	05-21-2009 11:12 AM