?
Solved

Macro Issue in Word 2010

Posted on 2011-10-03
17
Medium Priority
?
370 Views
Last Modified: 2012-05-12
We are having an issue with a word macro written in VB which was created by the previous IT manager.
There are two scripts - one to add the letterhead background and the other removes it .

These scripts seem to be part of the normal.dot file. When you run the batch file to add this to the users local profile it adds two buttons into word so that users can add/remove the letterhead.
Anyway since word 2007 this has not worked and now we have moved to 2010 this has become a big issue. Any help is much appreciated.
0
Comment
Question by:cmlbaete
  • 9
  • 8
17 Comments
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36904457
would you be able to email the scripts to me and we will sort them out for you.
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36904517
I have uploaded the normal.dot file which I believe has the scripts in, I hope this is ok, I am limited in my VB knowledge so many thanks for offering to look at this.

 Normal.dot
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36904723
Got it, leave it with me; will return the marco to you tomorrow (fixed)
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 1

Author Comment

by:cmlbaete
ID: 36905358
That would be great, thanks for your help.
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36908589
it is looking for a file located

S:\4_INFORMATION\2_LIBRARY\02_Templates\JTP templates\LetterHeadImage.jpg"

is it still there.......................

find this file put in on the network and then give me the location

and in the future do not remove / rename or change network path

i.e S:\ mapped drive for everybody's PC, file path remains untouched and file it self does not get renamed

Bernie
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36908604
Yes the file path is correct and the file is in that location, as I may have mentioned this works ok for Office XP and 2003 users.

S drive is mapped for all users and will not change.
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36908624
MMMMmmmm it working here on Word 2010, Can you shed any more light on the situation
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36908646
Have a look
1.jpg
2.jpg
3.jpg
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36908675
Where have you placed the file out of interest?
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36908684
This is the message I get when trying it in Word 2010 if that helps? Macro Image
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36908754
OK, try opening the file from your desktop also your Macro settings on Word need changing. Maybe you do not have the appropriate admin rights to do this?
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36908814
ok this works when opening the file direct. I have this problem even when akk the Macro items are set to enabled so wonder if I am missing something?
0
 
LVL 1

Assisted Solution

by:WowIamanexpertnow
WowIamanexpertnow earned 750 total points
ID: 36908900
Best way forward is to email me your telephone number, I can remote access your pc to help you and advise you on your macro settings also will be able to embed the macro into word natively.....

Bernie@TheRedWineBar.com
0
 
LVL 1

Expert Comment

by:WowIamanexpertnow
ID: 36909271
You most probably have a shortcut in your profile for this macro try put the file there instead
0
 
LVL 1

Author Comment

by:cmlbaete
ID: 36931877
I will send you a message now - Thank you
0
 
LVL 1

Accepted Solution

by:
cmlbaete earned 0 total points
ID: 37654039
This has now been fixed and is working well. There was a a change that needed to be made to the normal.dot template which allows it to work in the new version of office.
0
 
LVL 1

Author Closing Comment

by:cmlbaete
ID: 37676576
This was fixed in house.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question