Avatar of cmlbaete
cmlbaeteFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Macro Issue in Word 2010

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.
VB ScriptMicrosoft WordMicrosoft Office

Avatar of undefined
Last Comment
cmlbaete
Avatar of WowIamanexpertnow
WowIamanexpertnow

would you be able to email the scripts to me and we will sort them out for you.
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

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
Got it, leave it with me; will return the marco to you tomorrow (fixed)
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

That would be great, thanks for your help.
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
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

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.
MMMMmmmm it working here on Word 2010, Can you shed any more light on the situation
Have a look
1.jpg
2.jpg
3.jpg
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Where have you placed the file out of interest?
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

This is the message I get when trying it in Word 2010 if that helps? User generated image
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?
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

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?
SOLUTION
Avatar of WowIamanexpertnow
WowIamanexpertnow

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
You most probably have a shortcut in your profile for this macro try put the file there instead
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

I will send you a message now - Thank you
ASKER CERTIFIED SOLUTION
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of cmlbaete
cmlbaete
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

This was fixed in house.
Microsoft Office
Microsoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

80K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo