Solved: Only running MyExcel.xls on named machine?

[Charlize]

Maybe change :

With Sheets("Sheet1")

with

With wb.sheets("Sheet1")

Not sure but maybe you do a check on the wrong workbook

Charlize

ps.

Set wb = Workbooks.Open("C:\documents and settings\vrtSzL04\desktop\copy of compname.xls", True, True

must it be

Set wb = Workbooks.Open("C:\documents and settings\vrtSzL04\desktop\copy of compname.xls", True, True) 

a ) at the end ?