ok i ran the code a box came up saying Cannot access 'Westland_xlsx' so i clicked ok then another box came up saying 'Westland_xlsx' is a read only to save a copy, click ok, then give the workbook a new name in the save as dialog box. i clicked ok and the sheet opened and it looked good.