Nuz
01-04-2011, 02:38 AM
Is there a way using VBA to detect whether a specific .xls-file lies on the user's hard drive or network drive?
I would like to give warning to user if the file(s) to be processed are located on the network drive because the process is much slower in that case (each file has to be opened, saved and then closed). The problem is I don't know how to program this drive check into the VBA code.
I would like to give warning to user if the file(s) to be processed are located on the network drive because the process is much slower in that case (each file has to be opened, saved and then closed). The problem is I don't know how to program this drive check into the VBA code.