How to error trap "... cannot find the data..." message?
 

MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the
data on MYList. When there was no trading for a particular stock,
Excel prompts me with the message: "Excel could not find the data you
are searching for". At that stage I have to press the Enter Key to
clear the OK sign and allow the program to continue on to search for
the next code till the end. There were days when I had to press the
Enter Key over a hundred times. Is there a way for the program to do
this automatically by adding some codes to it? Thanks for any help.

Tom

How to error trap "... cannot find the data..." message?
 

Could be as simple as adding
Application.DisplayAlerts = False

or
Application.DisplayAlerts = False
On Error Resume Next

before the .Find line in your code.

Would help more to see the macro code you're using.



" wrote:

MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the
data on MYList. When there was no trading for a particular stock,
Excel prompts me with the message: "Excel could not find the data you
are searching for". At that stage I have to press the Enter Key to
clear the OK sign and allow the program to continue on to search for
the next code till the end. There were days when I had to press the
Enter Key over a hundred times. Is there a way for the program to do
this automatically by adding some codes to it? Thanks for any help.

Tom

How to error trap "... cannot find the data..." message?
 

I think that the program will have to be changed.

If you're not the developer, maybe you can ask for the results to be placed in
an adjacent column--or even have a new results worksheet created.

wrote:

MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the
data on MYList. When there was no trading for a particular stock,
Excel prompts me with the message: "Excel could not find the data you
are searching for". At that stage I have to press the Enter Key to
clear the OK sign and allow the program to continue on to search for
the next code till the end. There were days when I had to press the
Enter Key over a hundred times. Is there a way for the program to do
this automatically by adding some codes to it? Thanks for any help.

Tom

--

Dave Peterson

How to error trap "... cannot find the data..." message?
 

On Aug 25, 7:23*pm, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
Could be as simple as adding
Application.DisplayAlerts = False

or
Application.DisplayAlerts = False
OnErrorResume Next

before the .Find line in your code.

Would help more to see the macro code you're using.

Sorry, couldn't get back earlier because of computer problem.
The codes below are written in Excel 4 macro. Hope they make sense.
=ACTIVATE("ExchangeList.xls")
=FORMULA.FIND("xyz",1,2,2,1,FALSE) - by column, match all, etc.
=IF(A156=FALSE,,GOTO(A160)) - if previous line's return is "false",
continue next line, else get its content.
=ACTIVATE("MyList".xls")
=SELECT("R[1]C") - move down 1 row, same column
=GET.CELL(5) - get content of activecell

Tom

" wrote:
MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the
data on MYList. When there was no trading for a particular stock,
Excel prompts me with the message: "Excel could not find the data you
are searching for". At that stage I have to press the Enter Key to
clear the OK sign and allow the program to continue on to search for
the next code till the end. There were days when I had to press the
Enter Key over a hundred times. Is there a way for the program to do
this automatically by adding some codes to it? Thanks for any help.

Tom- Hide quoted text -

- Show quoted text -

How to error trap "... cannot find the data..." message?
 

On Aug 26, 5:03*am, Dave Peterson wrote:
I think that the program will have to be changed.

If you're not the developer, maybe you can ask for the results to be placed in
an adjacent column--or even have a new results worksheet created.

Thanks for your suggeation.

Tom



wrote:

MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the
data on MYList. When there was no trading for a particular stock,
Excel prompts me with the message: "Excel could not find the data you
are searching for". At that stage I have to press the Enter Key to
clear the OK sign and allow the program to continue on to search for
the next code till the end. There were days when I had to press the
Enter Key over a hundred times. Is there a way for the program to do
this automatically by adding some codes to it? Thanks for any help.

Tom

--

Dave Peterson