excel 2010 pop up

dinotom

Active Member
Joined
Aug 2, 2009
Messages
357
I am trying to adapt a 2007 file to work in 2010. I just upgraded this PC to Win 7 and Excel 2010. The routine goes to a website and grabs a file each week. I then scrape the information I want and append it it to my local file. Now in Excel 2010, or maybe its Windows 7 doing it, I get a pop up message box warning me of harmful files. I tried putting sendkeys in to "OK" the message box but apparently the popup event happens before the sendkeys can be run. Any thoughts on how to handle the pop up?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
If the pop-up is from Excel you could try

Code:
Application.DisplayAlerts = False
'
'code to grab data
'
Application.DisplayAlerts = True

If it is a pop-up from Windows then you would probably need some clever API programming to trap it.
 

dinotom

Active Member
Joined
Aug 2, 2009
Messages
357
Yeah, I tried that so it must be a Windows 7 thing. Can you point me to some reference material to review to try and handle the windows call?
 

Watch MrExcel Video

Forum statistics

Threads
1,130,047
Messages
5,639,767
Members
417,110
Latest member
RayClarke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top