What line of code does it error out on?

Barb Reinhardt

"Impecunious" wrote:

Hi,

I've got a list in an Excel file that's linked to SharePoint. If I
right click anywhere in the list and choose List Discard Changes and
Refresh, the list refreshes fine. However, if I use the VBA
equivalent - ListObjects("List1").Refresh (the code that the macro
recorder even creates) - I get an application-defined error '1004)
when the refresh appears to be wrapping up.

Can anyone explain? This is really bizarre and I don't want to have
to do this manually.

Thanks!