I make all the other changes I have to make send the workbook back to my colleagues make changes send it back to me and the same problem occurs. What I really need is the VB6 source code and database.mdb files. Thank you I have Windows 7 with Visual Basic 6 installed so I can duplicate the problem with your uploaded files and figure out how to fix the problem. Basically the macro uses ADO to ask an existing table to obtain desired data. Place them to an extent from a plateset - then filter and share the data in separate spreadsheets. I got the impression that you do not have to put references with late binding but I tracked your example and still get the message User Type Undefined. The problem I could not understand is that it works for the file that is stored on my local hard drive but it has only one problem to access the file in the shared drive.