My process fails - error 9: subscript out of range at this statement:-
With Workbooks(Cranafile).Worksheets(SheetName)
on one PC! On all other PC's the macro works fine. The workbook defined by
cranafile is definately open and definately has a sheet called sheetname. On
my PC I can have the string defined in any case (upper or lower) and all is
OK with or without the .xls extension. On this maveric PC I've had to add
code to ensure the book and sheet names are exactly as held in
workbooks(<bookid).name to make the with or any subsequent code find the
book and sheet. Why is this ? The maveric PC in on windows NT (I think) and
has recently had Excel re-installed. Is there a known bug in Excel here or in
there some parameter I need to set ? This was a real pain to find and code
round so any advice would be appreciated. Thanks