PDA

View Full Version : File on hard drive or network drive



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.

Tinbendr
01-04-2011, 07:29 AM
Here's a start (http://www.vbaexpress.com/forum/showthread.php?t=34851). #6.

Test for local first, then if not found, test for network. Respond with feedback accordingly.

David