R Ross Nov 3, 2003 #1 How can I use VBA to test a File Location to determine that it is valid, ie that it exists? Thanks, Ross
How can I use VBA to test a File Location to determine that it is valid, ie that it exists? Thanks, Ross
M Marshall Barton Nov 3, 2003 #3 Ross said: How can I use VBA to test a File Location to determine that it is valid, ie that it exists? Click to expand... Use the Dir function: If Dir(fullpath) = "" Then 'no such file Else 'file found End If
Ross said: How can I use VBA to test a File Location to determine that it is valid, ie that it exists? Click to expand... Use the Dir function: If Dir(fullpath) = "" Then 'no such file Else 'file found End If
G Guest Nov 3, 2003 #4 Marsh, Thanks so much! -----Original Message----- Use the Dir function: If Dir(fullpath) = "" Then 'no such file Else 'file found End If Click to expand...
Marsh, Thanks so much! -----Original Message----- Use the Dir function: If Dir(fullpath) = "" Then 'no such file Else 'file found End If Click to expand...
R Ross Nov 3, 2003 #5 Thank you Cheryl! -----Original Message----- Check out the Dir() function. -- Cheryl Fischer Law/Sys Associates Houston, TX . Click to expand...
Thank you Cheryl! -----Original Message----- Check out the Dir() function. -- Cheryl Fischer Law/Sys Associates Houston, TX . Click to expand...
