Hi,
I'm retreiving external data from an Access 2000 db using excel 2000 and sometimes when I use the below code I get the error "Application defined error".
Sheets("Data").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
I can always fix it by manually going to the sheet and selecting refresh but this regularly halts macros that I've written.
Thanks for any help
Mike
I'm retreiving external data from an Access 2000 db using excel 2000 and sometimes when I use the below code I get the error "Application defined error".
Sheets("Data").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
I can always fix it by manually going to the sheet and selecting refresh but this regularly halts macros that I've written.
Thanks for any help
Mike