Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's a code snippet that has worked for years under 2003:
strFullName = strPath & subPath & varBookName Err.Clear On Error Resume Next Workbooks.Open FileName:=strFullName, _ UpdateLinks:=0 'do not update Select Case Err.Number Now, under 2010 if the file does not exist I get a dialog that displays the filename as "not found, etc, etc." When I click on OK, the code continues executing and does what I expect. Is there a setting change on 2010 or something that I'm missing? -- Clif McIrvin (clare reads his mail with moe, nomail feeds the bit bucket :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On error resume next not working | Excel Discussion (Misc queries) | |||
year 2010 not working in IF | Excel Discussion (Misc queries) | |||
On Error Resume Next ? | Excel Programming | |||
On Error Resume Next | Excel Programming | |||
"on error resume next" NOT working... | Excel Programming |