I have a macro to upload data in the shared workbook everyday. Now if there is one user on the network who is using the shared workbook, there can be data corruption.
1.How can i write a macro so that i 'kick' out all the users who have this shared workbook open? Once i do that, i will be able to have exclusive right on that file and then do my loop from my macro to change this shared workbook.
2. if the shared workbook is open by other users, is it possible to copy the file to another folder through VBA. I understand it needs to be close to copy or open the workbook. any work around solution?
1.How can i write a macro so that i 'kick' out all the users who have this shared workbook open? Once i do that, i will be able to have exclusive right on that file and then do my loop from my macro to change this shared workbook.
2. if the shared workbook is open by other users, is it possible to copy the file to another folder through VBA. I understand it needs to be close to copy or open the workbook. any work around solution?