Compile Error: Automation Error

[Hoopsah]

Hi

I recently got an upgraded computer from IT and now cannot get one of my old programs to work.

When I open the Excel file everything works as it should, however, when I try to save I get a pop-up stating that Document could not be saved,
I click ok, and then every cell I click on is greeted with a pop-up stating Automation Error

I have tried on someone elses PC and all was fine

I assume I am missing a library or object but I have exhaused google to no avail

Any help apprecieted

Hoops

[Paul_Hossler]

In the VBIDE Tools, References, and see if any are #Missing

Paul

[Hoopsah]

I did check the other user and all that had ticked were:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library

I have the same ticked within my VB

[mdmackillop]

With Vista & Win7 you cannot save to the root folder (C Drive) using code.

[Hoopsah]

Hi

I'm not using code I am simply doing the File, Save from the menu

I have tried it on another users computer and everything is fine

[Hoopsah]

Bump!

[Hoopsah]

Bump! Bump!