Thread: Run-time error '1004' in import macro
View Single Post
  #2 (permalink)  
Old 11-26-03, 06:08
yannfoubert yannfoubert is offline
Registered User
  
Join Date: Nov 2003
Posts: 2
Question Re: Run-time error '1004' in import macro
Quote:
Originally posted by geeorbit
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
Hi!

Did you have the solution for your problem? I have the same one and can't find out what's going wrong.

Thanks in advance.

Yann
Reply With Quote