Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
In the Worksheet.Change event I have the following code snippet. Fname = Range("G12") ' Filename Fname = Fname & ".xls" If Dir(Fname) < "" Then MsgBox Fname & " - There is already a file with this name. Please try again", , "File Exists" Target = "" End If This worked fine for a while but for some reason doesn't work anymore. Application. EnableEvents is set to True and I've tried stepping through to no avail. Any ideas ? regards, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
big problem | Excel Discussion (Misc queries) | |||
=IF problem | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |