$$Excel-Macros$$ Run-time error 1004 when no file selected

2011-08-11 Thread Andy McGooner
Hi All, I have a spreadsheet that stores data from a text file, the idea being that it opens the file dialog and i select the relevant text file. The problem is that when i do the file open and press cancel i get the folowing message: Run-time error '1004' false.xls could not be found How do i

Re: $$Excel-Macros$$ Run-time error 1004 when no file selected

2011-08-11 Thread ashish koul
after u declare variables use on error goto abc and before end sub abc: exit sub use error handlers http://www.xlpert.com/partG.htm http://www.functionx.com/vbaexcel/Lesson26.htm On Thu, Auon errg 11, 2011 at 1:16 PM, Andy McGooner andrew_mcni...@yahoo.co.uk wrote: Hi All, I have a