Ok. I work with several users who share a network.
I have developed a Macro embed Global Template (.dotm file) that is stored on each computer. Located in:
C:\Users\%username%\AppData\Roaming\Microsoft\Word\STARTUP\salesmacros.dotm
My intent: The user clicks on a button (or link) on the Shared Network that will:
1. Open Word
2. Find their template (on their C:Drive as noted above)
3. Automatically run the top level macro (called "Macro_sales")
I thought a clean way to accomplish those three steps in one, would be a Batch File.
Just as FYI - The "Macro_sales" macro asks the user a series of questions (IF and IFELSE VBA) to populate a specific report template (based on the users answers), creates a network folder, and save the populated form and a .doc file.
Again, thank you for any help