I am running a VBA macro application in Microsoft Excel 97 under Windows XP -Service Pack 1 to,
1.Open an Excel work book .
2.Update a value in a cell
3.Save and close the file.
I need to repeat the steps 1,2,3 for 1,00,000 times. But after executing the process around 32,000 times the Excel application crashes.The whole OS hangs. And a message box appears As Run time error -2147467259 (80004005) ", method 'open' of object workbook's failed.
I have also tested the macro in Microsoft Excel 97 under Windows NT , the application excecuted 1,00,000 times with out any issue, I would like to know the reason of the crash.
I am facing this problem since last two weeks, If any body have the solution please comment it .
Thanks
Arun
1 2276 fyz 2
New Member
I am running a VBA macro application in Microsoft Excel 97 under Windows XP -Service Pack 1 to,
1.Open an Excel work book .
2.Update a value in a cell
3.Save and close the file.
I need to repeat the steps 1,2,3 for 1,00,000 times. But after executing the process around 32,000 times the Excel application crashes.The whole OS hangs. And a message box appears As Run time error -2147467259 (80004005) ", method 'open' of object workbook's failed.
I have also tested the macro in Microsoft Excel 97 under Windows NT , the application excecuted 1,00,000 times with out any issue, I would like to know the reason of the crash.
I am facing this problem since last two weeks, If any body have the solution please comment it .
Thanks
Arun
Hi Arun,
I am not sure abuot your problem. But, does this problem cause corruption of your file? If so, maybe you can try a popular Excel file recovery tool called Advanced Excel Repair to repair your Excel file. It is a powerful tool to repair corrupt or damaged Excel files.
Detailed information about Advanced Excel Repair can be found at http://www.datanumen.c om/aer/
And you can also download a free demo version at http://www.datanumen.c om/aer/aer.exe
Alan
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: I Decker |
last post by:
Hi all,
Hope this is the right group.
I am writing a program in c# to open create an excel document, enter
some data, save it and then email it as an attachment. I have
successfully created an excel document which the user can see (at this
stage of development) and passed some data to it. I then used the
savas method to save the file. Again this seems to work as the file is
created. However once I close the excel file and try and...
|
by: Rich Wallace |
last post by:
Is there a way to open an Excel file and either respond to or supress the
Macro warning window via VB.NET?
Dim oExcel As Excel.Workbook
Dim sFilePath As String = "C:\DailyReport.xls"
oExcel = GetObject(sFilePath) --> Throws Macro warning window
oExcel.Unprotect("password")
|
by: cr113 |
last post by:
I just upgraded from Office 2000 to Office 2003. My VB.NET Excel macro
calls don't work any longer.
Here is how I make my Excel macro call from VB.NET:
Dim objExcel as Excel.Application
objExcel = New Excel.Application
objExcel.Workbooks.Open(FileName:="c:\test.xls", ReadOnly:=True)
objExcel.Run("test.xls!test.test")
|
by: Mr.Doubt |
last post by:
I'm trying to run a Excel macro, which uses SOLVER.XLA Add-In, in
VB.NET application. When the macro is executed I get the following
error message
"Solver: An unexpected internal error occured, or
available memeory was exhausted"
Any suggestions whats causing this error and how to debug it???
Also, I get the following exception message when executing all the
|
by: cr113 |
last post by:
We've upgraded from Office 2000 to Office 2003 and now my excel macro
calls are messed up. There's about a 15 second delay from the time I
make the call in VB.NET to the time the excel macro is actually
executed.
Here's my code:
Dim oExcel As Microsoft.Office.Interop.Excel.Application
oExcel = New Microsoft.Office.Interop.Excel.Application
| |
by: Senthil |
last post by:
Hi All
I need to create an Excel report and create a command button and
have to run a macro on the
click event that will print all the pages in the Excel workbook.
I am able to create the report from the database but I am not sure how
do I put a command button and associate a macro with that using C#. Can
anyone help me??
Thanks in advance.
Senthil
|
by: developer200701 |
last post by:
The following code (which is distilled down from a larger application)
worked for several years previously. Now, the instant you click on
the print icon within the print preview window the workstation crashes
hard: reboots and upon Windows restart wants to send an error report
to Microsoft (recovered from severe error). My default printer is HP
LaserJet 5000N Series PCL6; if I select an alternative printer
(different HP model) this...
|
by: arun0580 |
last post by:
I am running a VBA macro application in Microsoft Excel 97 under Windows XP -Service Pack 1 to,
1.Open an Excel work book .
2.Update a value in a cell
3.Save and close the file.
I need to repeat the steps 1,2,3 for 1,00,000 times. But after executing the process around 32,000 times the Excel application crashes.The whole OS hangs. And a message box appears As
" Run time error -2147467259 (80004005) ", method 'open' of object workbook's...
|
by: NeverLift |
last post by:
This is probably answered elsewhere, but I've searched the Web and VBA for Excel manual, find no answers.
I have a VBA-coded macro in an Excel workbook that is to open another existing workbook -- a .xls file, not .csv -- copy data from it, paste that into the original workbook where the macro resides, then close the source workbook.
If I use the debugger to step through the macro -- putting a breakpoint at its first executable line, run...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |