@jespah,
ok here goes I have this code to open a workbook
newfn = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls*),*.xls*", Title:="Please select a file")
The user when he clicks on a button in his open sheet (Invoice)
When he clicks on it it opens the directory where all the quotations are and he clicks on the one he wants the invoice to be filled automaticly .
this works great so far but this code stops giving error ...OPEN OBJECT WORKBOOK HAS FAILED ERROR 1004
the code line shows Workbooks.Open Filename:=newfn
All permissions are there nothing hidden (files)
And what is really weird this thing works on all other computers except one.