 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Internet Explorer / May 2008Failure in Excel Query
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 Hi Again, I have a little bit more information on the problem. I think it is a problem with files in temporary not cleaning themselves out. Went to "temporary 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 > Hi Group, > [quoted text clipped - 16 lines] > > David Sorry, just had to make sure that the site saved my e mail, so I can get replies. You know, space the final frontier? > Hi Again, > [quoted text clipped - 30 lines] > > > > David > Hi Group, Hi David, > I am going a Query in Excel 2003, using IE7, in Windows XP. You're in the wrong newsgroup. This is the group for the Mac version of IE. You should repost in one of the regular IE groups. Corentin  Signature--- Mac:MS MVP http://www.cortig.net/wordpress/ --- http://www.mvps.org - http://mvp.support.microsoft.com MVPs are not MS employees - Les MVP ne travaillent pas pour MS Remove "NoSpam" to e-mail me - Retirez "NoSpam" pour m'écrire |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.