To all,

I wrote some code in an excel file that was on my network drive which
works perfectly for me. However, when a colleague tries to use the
file the program is halted because of a subscript error. This is the
line where the problem occurs:

Application.Workbooks("Loss Reduction Worksheet -
Working").Sheets("Switchboard").Activate

At this point in the program, a new excel file is created and
information is taken for the original document and analyzed in the new
document.

I never have any problems with the program which leads me to believe
that I must have changed the settings or loaded an add-in on my excel
application which my colleague hasn't done. But for the life of me, I
can't figure out how adjust my colleagues settings so that the program
works (that is if that is the case).

Any suggestions would be much appreciated.

Thanks,
Peter


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=493417