Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Excel file automatically opens | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) |