Displa Alert = False ... Not working

[sacsona]

Hi

I need a big time help with the annoying excel warning pop up keep flashing upon every refresh of a web query. I have tried to use Display Alert = False, as well as Send keys = {ENTER}, but some how it is not working.

I have a web refresh every 2 mins and so eventually it pops up every 2 mins and some time after 15-20 mins... there is no set interval.

Can you pl help, suggest any alternative pls.

 

[ChrisFoster]

Are you using the full part of the code? Such as;

Application.DisplayAlerts = False

 

[sacsona]

Ohh, yes.. that's what I mean... but it's just not working

 

[MARK858]

You haven't stated what the popup says.

 

[sacsona]

Hi Mark,

Thanks, it says [Expression Error: The field 'records' of the record wasn't found] ... pl note here records is the table name in the webquery.

 

[sacsona]

Can someone help me please