Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If the file exists "Yes should appear"
Hi All, I am asking people to fill out a questionairre, which their responses are saved in a shared folder. Their responses are saved as theirname.xls. Is it possible, if I have an excel sheet with all the names in one column, to have excel put a "YES" in the adjacent column if the userse file exists? Thank you for your quick reply. -- Sami82 ------------------------------------------------------------------------ Sami82's Profile: http://www.excelforum.com/member.php...o&userid=27111 View this thread: http://www.excelforum.com/showthread...hreadid=525538 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If the file exists "Yes should appear"
Function FileExists(UserName as string) as string
Const DIRPATH as string="C:\stuff\" 'or whatever if dir(DIRPATH & UserName & ".xls")<"" then FileExists="Yes" else FileExists="No" end if end function Tim "Sami82" wrote in message ... Hi All, I am asking people to fill out a questionairre, which their responses are saved in a shared folder. Their responses are saved as theirname.xls. Is it possible, if I have an excel sheet with all the names in one column, to have excel put a "YES" in the adjacent column if the userse file exists? Thank you for your quick reply. -- Sami82 ------------------------------------------------------------------------ Sami82's Profile: http://www.excelforum.com/member.php...o&userid=27111 View this thread: http://www.excelforum.com/showthread...hreadid=525538 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Macro help - "Save As" when a file already exists | Excel Programming | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming |