Device I/O Error

G

Gromit

Hi,

I'm using Excel 2003. When I open a workbook, create a macro, save
close and re-open the worksheet, a second entry for the same projec
appears in the Project Explorer Window of the VBE. Each time I clos
and re-open a sheet, but without actually closing Excel itself, a ne
duplicate of the Project is in the window. I eventually get a serie
of "Device I/O Error" messages, before a crash that on AutoRecover ha
wipes out all my Userforms, modules and sheet code.

Anyone else experience this? Any advice on what to do muc
appreciated.

Cheers

Gromi
 
A

AlfD

Hi!

Curiouser...

I too have had this I/O error message.

Excel workbook produced in Excel 2003 on my machine (Windows XP) which
has Google desktop.
Transferred to another machine (Excel 2000 : Windows 2000 Professional)
which does not have Google desktop.

I/O message appeared on this other machine but no eventual loss of
programme etc.

I might add, I would be loathe to dump the Google. It finds things I
never even knew existed let alone the ones I had long forgotten.

Alf
 
G

Gromit

Thanks Frank,Alf, I'll try it.

Any theories why it happens or is it just one of those things....?
 
J

jason

I run a macro with the following two lines in it:

Sheets("CLIENTNAMES").Range("A1").QueryTable.Refresh
BackgroundQuery:=False
Sheets("GLOBALHOLDINGS").Range("A1").QueryTable.Refresh
BackgroundQuery:=False

and then I get this I/O error message throughout excel, even if I
close the book that contained the lines.
If I comment out these two lines then everything is hunky-dory

Any ideas what I should do?
(I'm using Excel2000)

Regards
Jason.
 
Top