I have written a macro to import data from a text file into a new excel file, copy that data to the database and finally delete the new file opened for importing purpose.
However the command .Refresh BackgroundQuery:=False
gives:
Run-time error '1004'
Application-defined or object-defined error.

At times it executes without any error.
Any clue regarding how I can solve this ?

Thanks in advance