Sorry, just had to make sure that the site saved my e mail, so I can get
replies. You know, space the final frontier?
"David" wrote:
> Hi Again,
>
> I have a little bit more information on the problem. I think it is a
problem
> with files in tem****ary not cleaning themselves out. Went to "tem****ary
> internet files", while I was running the program and deleted some of the
> previous queries and the program resumed working, but I am not sure how
to
> cure the problem from a programming point of view.
>
> Any ideas? I am using VBA in Excel.
>
> Thanks for your help.
>
> David
>
> "David" wrote:
>
> > Hi Group,
> >
> > I am going a Query in Excel 2003, using IE7, in Windows XP. Things go
along
> > just fine, up to a point. There are about 60 queries and they are
working
> > fine up to a point, then I get a failure message is:
> >
> > Run-Time error 1004:
> > The file could not be accessed. Try one of the following:
> > *Make sure the specified folder exists.
> > Etc.
> >
> > But nothing has changed and it has been ok for a large number of
Queries.
> > Some times I will be ok if I do the ".Refresh BackgroundQuery:=False"
over,
> > but more often than not it still fails. It is as if there is an
overflow.
> > Possibly it is my ISP, which is ATT or a factor I do not know how to
check, a
> > loss of Memory? Anyone have any ideas?
> >
> > Thank you for your time and efforts.
> >
> > David
|
