Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Run Macro at startup with command line switch

Jul 21, 2010 3:14AM PDT

How would I load a macro from a command line switch without having the macro in the Normal.dotm file? I'm running on XP Pro and we've just upgraded to Office 2007. I've tried the /m switch but the dotm file that has the code in it is not available at startup of Word. I've tried it in the startup folder still no luck. The only way I've found is to put the macro code in the Normal.dotm file but our IT support shop does not want to modify the Normal.dotm file. Any thoughts?

Discussion is locked

- Collapse -
(NT) What do you want this macro to do?
Jul 21, 2010 5:57AM PDT
- Collapse -
What do you want this macro to do?
Jul 22, 2010 1:20AM PDT

We use a file management system called ProjectWise by Bentley. It's integrated with the Office Suite. We also have an application called GEOPAK that creates reports. The macro is started from a command-line trigger in ProjectWise when the files is opened. The macro first displays a dialog box asking the Designer if the want to convert the report from 8.5" X 11" paper to 8.5" 5.5" paper. If the Designer select the process button the macro opens a new document takes the text from the currently opened files rotates the text and reduces it in size to fit on the new sheet size. This all works if I run it from the Normal.dotm tempalte.

- Collapse -
Re: macro
Aug 7, 2010 12:35AM PDT

Time to ask IT support for another working solution. If they can't (which I assume) go up in the hierarchy to have them implement your solution, even if it's against standard policy. That's what hierarchy is for.

Kees