popups asking me to update values

[mprice40ca]

I want to correct a Vlookup happening in another workbook.

The code is working

Please Login or Register  to view this content.

but once the macro is done there are some popups asking me to update values.

i want to enter G:\Engineering Resources\QUALITY ENGINEERING RESOURCES\AQL\AQL.XLS into those popups and close them (invisibly of course)

[protonLeah]

You might try:

Please Login or Register  to view this content.

[mprice40ca]

Thank you that worked.

Its kinda weird though I have one set of workbooks where that works and another (I can differentiate between them) Where i had to use a sendkeys... and load the location of the book again to make the formulas work.