• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

Sign in to follow this  

Office 2013 help

Recommended Posts

TheGreek    3

Hey everyone!

 

Forgive me if its not the right section to post to.

 

I just bought Office 2013 and I love it. But I have my macros and styles in my normal.dotm and they can't seem to work in 2013 but they are fine in Office 2010.

 

Can anybody help me out what to do? 

This is very important to me, I have a lot of work to do in Office and want to use 2013.

 

Thanks!

Cheers!

Share this post


Link to post
Share on other sites
morpheus6969    102

This link should help you out:

 

http://office.microsoft.com/en-001/word-help/enable-or-disable-macros-in-office-files-HA010354316.aspx

 

Cheers

 

 

Hey everyone!

 

Forgive me if its not the right section to post to.

 

I just bought Office 2013 and I love it. But I have my macros and styles in my normal.dotm and they can't seem to work in 2013 but they are fine in Office 2010.

 

Can anybody help me out what to do? 

This is very important to me, I have a lot of work to do in Office and want to use 2013.

 

Thanks!

Cheers!

  • Like 1

Share this post


Link to post
Share on other sites
AStalUK    60

Also where have you copied your "normal.dotm" files to, for Office 2010/2013 it should be in "%appdata%\Microsoft\Templates".

Share this post


Link to post
Share on other sites
TheGreek    3

Also where have you copied your "normal.dotm" files to, for Office 2010/2013 it should be in "%appdata%\Microsoft\Templates".

I copied there! I can see my macros in Office 2013 but they are not working.

Share this post


Link to post
Share on other sites
AStalUK    60

Okay, just verified with my PC.  Copying the Word 2010 Normal.dotm to the same location in Word 2013 does copy across the macro's and they function without issue.

 

Do you still have access to the 2010 installation, you could export the macro's to a file and them import them back to 2013?

 

  1. In Word 2010 enable the developer tab if not already available.  Right click anywhere in the Ribbon Bar and select "customize the ribbon", place tick in Developer on the right hand section and OK the window.
  2. From the Developer tab select Visual Basic and expand Normal in the top left section, then expand Modules.  Under Modules you should see your macro's.
  3. Select a macro and click File>Export and save the file to easy to access location.
  4. Repeat for each macro.

For Word 2013.

  1. Rename the normal.dotm file to normal.dotm.old.  And then open Word 2013 and open Visual Basic from the Developers tab.
  2. Now go File>Import and import the BAS files you exported in the previous steps.  Close Visual Basic and then Word making sure you save as needed.

 

Hopefully what I've typed makes sense and helps you.

  • Like 1

Share this post


Link to post
Share on other sites
TheGreek    3

Hey AStaley!

This looks good and logical. I will try this after I get home!
I will check back with the result.

 

Thanks again for your help.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.