does a file exist
I would like to make a True/False statement in an excel-formula that checks if a certain file exists on the harddisk or not. There must be some kind of VBA statement for that. Please let me know if you can help me. Thanks. Arien de Haan Eindhoven, NL -- Arien ------------------------------------------------------------------------ Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892 View this thread: http://www.excelforum.com/showthread...hreadid=497521 |
does a file exist
Best to add a UDF
Function BookExists(wb As String) BookExists = Len(Dir(wb)) 0 End Function and use like =IF(BookExists("C:\myfile.xls"), "yes","no") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Arien" wrote in message ... I would like to make a True/False statement in an excel-formula that checks if a certain file exists on the harddisk or not. There must be some kind of VBA statement for that. Please let me know if you can help me. Thanks. Arien de Haan Eindhoven, NL -- Arien ------------------------------------------------------------------------ Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892 View this thread: http://www.excelforum.com/showthread...hreadid=497521 |
does a file exist
Arien,
Here's some code I use to delete a dummy file from the C drive - I'm sure you can adapt it to your needs. Regards & happy New Year Pete If Dir("C:\Holidays+Training+Sickness Chart.xls") < "" Then Kill "C:\Holidays+Training+Sickness Chart.xls" End If "Arien" wrote: I would like to make a True/False statement in an excel-formula that checks if a certain file exists on the harddisk or not. There must be some kind of VBA statement for that. Please let me know if you can help me. Thanks. Arien de Haan Eindhoven, NL -- Arien ------------------------------------------------------------------------ Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892 View this thread: http://www.excelforum.com/showthread...hreadid=497521 |
does a file exist
It works. Thanks a lot. regards, Arien de Haan Bob Phillips Wrote: Best to add a UDF Function BookExists(wb As String) BookExists = Len(Dir(wb)) 0 End Function and use like =IF(BookExists("C:\myfile.xls"), "yes","no") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Arien" wrote in message ... I would like to make a True/False statement in an excel-formula that checks if a certain file exists on the harddisk or not. There must be some kind of VBA statement for that. Please let me know if you can help me. Thanks. Arien de Haan Eindhoven, NL -- Arien ------------------------------------------------------------------------ Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892 View this thread: http://www.excelforum.com/showthread...hreadid=497521 -- Arien ------------------------------------------------------------------------ Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892 View this thread: http://www.excelforum.com/showthread...hreadid=497521 |
All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com