LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Can run-time 1004 be trapped ?

on error goto errhandler



errhandler:
if err.Number = 1004 then

end if
Resume Next
End Sub

--
Regards,
Tom Ogilvy

"BHARATH RAJAMANI" wrote in
message ...

Does anyone have code to trap run-time error '1004' ?

I'd like to trap '1004' in a macro that reads (case-sensitive) csv

filenames
from a (derivatives exchange) website.

TIA !!!

Regards,
BR

--
Manager, International Private Banking, International Banking Group, ICICI
Bank
East Wing 8th floor South, ICICI Towers, Bandra Kurla Complex, Mumbai

India
400051



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run time 1004 cluckers Excel Discussion (Misc queries) 5 January 22nd 10 09:17 PM
Run-time error: '1004' Bishop Excel Worksheet Functions 2 May 21st 09 04:28 PM
Error not trapped - please help!!! Bura Tino Excel Programming 8 April 18th 04 09:27 PM
Can error 1004 be trapped???? Richard m Excel Programming 3 November 29th 03 02:55 PM
Run time error 1004 Paul B[_6_] Excel Programming 3 October 26th 03 02:14 PM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"