For anybody with Norton Auntie Virus 2004 and Office 2003

[Howard Kaikow]

Option Explicit

Private Sub CreateWordObjectUsingNew()
Dim appWord As Word.Application

On Error Resume Next
Set appWord = New Word.Application
If Err.Number <> 0 Then
Debug.Print Err.Number, Err.Description
Exit Sub
'-2147221231 Automation error
'ClassFactory cannot supply requested class
End If
appWord.Quit
Set appWord = Nothing
End Sub
Using either of the subs below, I am unable to create a Word object and get
the same error message in both cases.
I know that I ran analogous code successfully on 22 July 2004, with NAV
2003.

As far as I know, the only software installed since then was NAV 2004 on 24
August 2004.

Does anybody with Office 2003 and NAV 2004 see the same error?
Problem does not occur, on another systetm, with Office 2002 and NAV 2003.

Private Sub CreateWordObjectUsingCreateObject()
Dim appWord As Word.Application

On Error Resume Next
Set appWord = CreateObject("Word.Application")
If Err.Number <> 0 Then
Debug.Print Err.Number, Err.Description
Exit Sub
'-2147221231 Automation error
'ClassFactory cannot supply requested class
End If
appWord.Quit
Set appWord = Nothing
End Sub

 

[Malcolm Smith]

There have been (too many) documented issues with Norton and Word. In
some of the magazines which I brought back from the US a few columnists
were bemoaning Norton when they would 'improve' something.

Sometimes one couldn't create a new document!

So, it's nothing new and I tell you that I will never have Norton here
ever again!

- Malc
www.dragondrop.com

 

[Howard Kaikow]

Added info:

1. I do not have NAV Office plug-in enabled.
2. I tried with NAV Office plug-in enabled, same problem.
3. No such problem creating an Excel object, even from within Word.

 

[Howard Kaikow]

I use NAV ONLY because NAV appears to be the most common environment, so
when I write VBA code for others to use, I want to have the most common
environment.

I'll may try uninstalling NAV to see whether NAV was really the culprit.

Of course, with NAV's activation, I might have trouble re-installing, so I
better do a full backup before uninstalling.

However, before doing that, I want to find someone who can reproduce the
problem using NAV 2004 and Office 2003.
Doubt that the OS matters, but I'm using Windoze 2000 Pro SP 4.

One thought is to first disable some of the options in NAV 2004 that were
not in NAV 2003.

 

[Howard Kaikow]

There are related threads in Microsoft.public.vb.ole.automation, and,
perhaps, other newsgroups.

 

[Peter Hewett]

Hi Howard

I tried both the early bound and late bound examples you posted using:

Win 2k SP4, Office 2003 SP1, NAV 2004 (latest sigs etc.)

form Excel with the Orifice plug-in both enabled and disabled and all worked ok or in
my case

Cheers - Peter

Added info:

1. I do not have NAV Office plug-in enabled.
2. I tried with NAV Office plug-in enabled, same problem.
3. No such problem creating an Excel object, even from within Word.

HTH + Cheers - Peter

 

[Howard Kaikow]

Thanx.

I do not have SP 1 installed.
I guess I could try that first, but I'm concerned about the SP 1 problems
reported.
Heck, I'll roll the dice!

If that does not do the deed, I guess that I'll need to try uninstalling,
then re-installing Office, since somebody fixed a similar problem according
to a posting in the ole.automation newsgroup.

 

[JB]

Thanx.

I do not have SP 1 installed.
I guess I could try that first, but I'm concerned about the SP 1 problems
reported.
Heck, I'll roll the dice!

If that does not do the deed, I guess that I'll need to try uninstalling,
then re-installing Office, since somebody fixed a similar problem according
to a posting in the ole.automation newsgroup.

HI Howard,

What SP1 problems have you heard about? Can you give me some links please?

I'm just about to deploy it

Cheers

J

 

[Howard Kaikow]

There are reports scattered about in various newsgroups.
Place to start is microsoft.public.officeupdate.

I just installed SP1 less than one hour ago.
So far no problems, but did not remedy the problem mentioned in this thread.

I did end up with a 2nd Outlook shortcut on the Quick Launch Bar, and the
shortcut has different properties than the first shortcut.
I've posted a query in microsoft.public.outlook.general.

 

[Howard Kaikow]

Alas, SP 1 does appear to be causing significant problems with IE and/or OE,
etc.
Symptoms include:
1. I get locked out of the icon in the system tray that shows the
connection, so I cannot disconnect.
2. When I try to REply to a newsposting, the editing window appears, then
quickly disappears.
3. IE does not seem to connect to sites.
4. Worst, if I do Atl Ctrl Del, the task manager window appears then
disappears.
5. Ditto for trying to get to the Start Menu.
6. I tried using Alt S to get to the Start Menu, but it disappeared.
7. I then quickly typed Alt S, then Alt u to get to the Start Menu. Alas
that too disappeared.
8. I then quickly typed, Alt S, then Alt u and Return QUICKLY and was able
to restart,
9. OE problems do not occur while I am offline, which is how I managed to
type this message.

Spoke too soon.

As I was typing this, offline and not connected, problems occurred.
I kept fiddling with Alt shortcuts until I got to Shut Down button in task
manager.

I then rebooted to Safe mode.
Could not uninstall Office as "Windows Installer was not available".
So I did a reboot.

Right now, seems to be working, but I have no faith that things will
continue to work.

 

[Peter Hewett]

Hi Howard Kaikow

If you've got the hardware resources I can thoroughly recommend VMWare. I've not tried
Virtual PC. I've only been using it a couple of months and I absolutely love it. Some of
my clients having been raving about to me for the last two years - and they were
justified.

It's got a fairly steep memory requirement though, I'm using it on a 512MB AMD 2.4+ and
it's always running out of memory and needs fast disks as some of the VM's can be large.
I'm in the process of building a new system specifically for it as I need to run up to 3
VM's concurrently.

Cheers - Peter

Alas, SP 1 does appear to be causing significant problems with IE and/or OE,
etc.
Symptoms include:
1. I get locked out of the icon in the system tray that shows the
connection, so I cannot disconnect.
2. When I try to REply to a newsposting, the editing window appears, then
quickly disappears.
3. IE does not seem to connect to sites.
4. Worst, if I do Atl Ctrl Del, the task manager window appears then
disappears.
5. Ditto for trying to get to the Start Menu.
6. I tried using Alt S to get to the Start Menu, but it disappeared.
7. I then quickly typed Alt S, then Alt u to get to the Start Menu. Alas
that too disappeared.
8. I then quickly typed, Alt S, then Alt u and Return QUICKLY and was able
to restart,
9. OE problems do not occur while I am offline, which is how I managed to
type this message.

Spoke too soon.

As I was typing this, offline and not connected, problems occurred.
I kept fiddling with Alt shortcuts until I got to Shut Down button in task
manager.

I then rebooted to Safe mode.
Could not uninstall Office as "Windows Installer was not available".
So I did a reboot.

Right now, seems to be working, but I have no faith that things will
continue to work.

HTH + Cheers - Peter

 

[Howard Kaikow]

What does VMWare have to do with the issue I raised?

 

[Peter Hewett]

Hi Howard Kaikow

You just copy the virtual machine before adding any new software. No good (as it appears
in your case) then delete the new VM and continue with the old one. It's saved me so much
hassle in this respect. I can copy a VM, install new drivers/software/patches and know
that it's not going to bugger up my whole system - only the dispensable VM I installed it
on.

It means I can run different versions of Office each with it's own dedicated OS without
needing a multi-boot PC anymore. You also get the benefits of hardware abstraction in
that you can copy the VM to a completely different PC (Intel instead of AMD, SCCI instead
of IDE, different Motherboard chipsets) and as long as you've installed VMWare it will
boot.

Can't live without it.

Cheers - Peter

What does VMWare have to do with the issue I raised?

HTH + Cheers - Peter

 

[Howard Kaikow]

If I have 10 logical drives, does VMWare involve copying all 10 drives?

--
http://www.standards.com/; See Howard Kaikow's web site.

Hi Howard Kaikow

You just copy the virtual machine before adding any new software. No good (as it appears
in your case) then delete the new VM and continue with the old one. It's saved me so much
hassle in this respect. I can copy a VM, install new

drivers/software/patches and know

 

[Peter Hewett]

Hi Howard

Not quite sure about the question. When you boot a VMWare system you treat them as
physical systems each with it's own set of drives. Since you tend to create new VM's for
new clients/projects you generally end up with only a few drives per machine. You can of
course share a "real" drive. Just give it a Share and map it within the VMWare machine.

I have 4 different Virtual Machines each running Outlook (2 Office XP and 2 Office 2003).
They all share the same Outlook pst file (but not at the same time of course) through a
mapped drive.

My bootable system in nothing more than the OS/Patches/Drivers/Virus Scanner and VMWare.
Everything else goes into a VM. It makes for great flexibility being able to mix
OS/Office/VS.Net in various admixtures as I require. Also, if I have a system failure I
can load one of the VMs (from backup or pull the physical drive) onto another box and be
back in business in minimal time.

I recently had a motherboard fail and lost more than 8 days in downtime. I'd been
intending to use VMWare for some time and this precipitated my adoption. My current
hardware is emergency replacement until I get the my new system built. But when the new
hardware arrives I just load OS/Patches/Drivers/Virus Scanner and VMWare copy across the
VM machines and I up and running.

Peter

If I have 10 logical drives, does VMWare involve copying all 10 drives?

HTH + Cheers - Peter

 

[Howard Kaikow]

It seems that the best way to create a virtual OS would be to have ALL
installed apps for that OS installed on a SINGLE drive.
If not, there could be problems creating more than one OS.

Prior to Office "2005" or VS 2005, I'll need to build/buy another PC with
more horsepower.

I'll get lots of drive space and may play with Virtual PC or VMWare on that
system, but I'm still concerned about the OS licensing issue.
I do not recall what the Win 2000 or Win XP licenses say, but I expect that
they limit use to one PC. That's fine. However, I expect that the licenses
were not intended to restrict multiple installs on the SAME PC. The NTLDR
does not enforce any such restriction. But Virtual PC /VMWare might (decide
to)
enforce such a restriction.