Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Run Time Error

Hello group
I have a number of files (6) that usually open all at one time. Recently
when I open them all I get a Run Time Error 10004 "Application defined or
object defined error" The error seems to pop up on different files based on
the order I select when I open them. I can open less than 6 with random
selection and I still get the error. So I cannot tie it down to one
particular file. Also the RTE dialog does not give me a debug option. These
files are network files and the behavior does not exist on other machines on
the network, only mine.
Any ideas or suggestions?
Thanks!
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Run Time Error

Hi
is there any code in these workbooks (e.g. workbook_open event code) and if
yes you may post this code

"BOB" wrote:

Hello group
I have a number of files (6) that usually open all at one time. Recently
when I open them all I get a Run Time Error 10004 "Application defined or
object defined error" The error seems to pop up on different files based on
the order I select when I open them. I can open less than 6 with random
selection and I still get the error. So I cannot tie it down to one
particular file. Also the RTE dialog does not give me a debug option. These
files are network files and the behavior does not exist on other machines on
the network, only mine.
Any ideas or suggestions?
Thanks!

  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Run Time Error

Thanks for the reply Frank,
There is extensive code in all of the files....None has changed and the
files open with out error on other computers. And the fact that there is no
option to debug is what confuses me, and that the error even shows up on
workbooks that have no code.

"Frank Kabel" wrote:

Hi
is there any code in these workbooks (e.g. workbook_open event code) and if
yes you may post this code

"BOB" wrote:

Hello group
I have a number of files (6) that usually open all at one time. Recently
when I open them all I get a Run Time Error 10004 "Application defined or
object defined error" The error seems to pop up on different files based on
the order I select when I open them. I can open less than 6 with random
selection and I still get the error. So I cannot tie it down to one
particular file. Also the RTE dialog does not give me a debug option. These
files are network files and the behavior does not exist on other machines on
the network, only mine.
Any ideas or suggestions?
Thanks!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Error Run Time Error, Type Mismatch Meg Partridge Excel Discussion (Misc queries) 12 September 10th 08 06:10 PM
Run time error 1004, General ODBC error [email protected] New Users to Excel 0 September 19th 05 01:41 AM
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error rdavis7408 Excel Programming 1 August 25th 04 03:54 AM
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) Tim[_36_] Excel Programming 4 April 23rd 04 02:53 AM
Run-time error '11' & Run-time error '1004' Piers Clinton-Tarestad Excel Programming 0 January 9th 04 07:45 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"