Have a problem that is driving me a bit mad , i have a db that works absolutely fine on a number of machines, except the one it should do. The code that creates the error is:
Public oWord As Object
Set oWord = CreateObject("Word.Application")
nothing wrong there , the code is doing a merge function and on the machine in question throws up an error 48 when you try and use the create object line.
I have uninstalled office, reinstalled it checked the reg and can find nothing wrong with it, i even managed to get the automation object working on a simple script.
However...in this case the object is called as part of another routine.
what i want to know is has anyone had anything profoundly odd like this before and if so what was the cause?