Korean Job Discussion Forums

[SHANE02]

MS did a stupid thing I think. They made it impossible to scan into Office 07. Why the hell they took out the scan icon I dont know. So after tons of searching I fond a guy who explained how to build a macro to add a scan icon. It works for me. I did have to have my HP install disk in the drive the first time I ran the macro, but now it's all good.



Create the following Macro (Tools > Macro > View Macros > Macros in Normal.dotm > Type 'scan' as the name > Create > Paste in code:

Sub InsertFromScanner()
On Error Resume Next
WordBasic.InsertImagerScan
End Sub

You can then 'Customise the Quick Access Toolbar' > choose commands from: 'Tools/Word Options/ Customise. Choose Macros' in "Choose cammands From" and ADD. Then Modify it to give it a distinctive icon.

This will give you the 'insert from scanner' box with one click from the Quick Access Toolbar (QAT).

-----------------
The next challenge was to get it deployed across a network of 100 users (complaining about the function being missing in Word 2007).

So... I copied the Normal.dotm from my computer to a network folder. It is originally here:

"C:%HOMEPATH%\Application Data\Microsoft\Templates\normal.dotm"

Paste it twice with the following names:
normal.dotm
scanning.dotm

I also copied my QAT file for Word to the same folder. Originally here:

"C:%HOMEPATH%\Local Settings\Application Data\Microsoft\Office\Word.qat"

So there are three files in the folder. You can then use a logon script to copy them to the users' folders automatically. A batch file can do the same job (as below). I have taken the precaution of renaming the files that are already there as a backup. Also, be aware that users will get the QAT of your choice rather than an previous customisations but in a new Office 2007 this should not be a problem.

Batch files (and locations to use for logon script):

+++++
ren "C:%HOMEPATH%\Application Data\Microsoft\Templates\normal.dotm" normal.orig
copy /-Y normal.dotm "C:%HOMEPATH%\Application Data\Microsoft\Templates"

copy /-Y scanning.dotm "C:%HOMEPATH%\Application Data\Microsoft\Word\STARTUP"

ren "C:%HOMEPATH%\Local Settings\Application Data\Microsoft\Office\Word.qat" Word.orig
copy /-Y Word.qat "C:%HOMEPATH%\Local Settings\Application Data\Microsoft\Office"

pause
+++++++

I hope this helps someone out there avoid hours of research!