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 2261
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.com/aer/
And you can also download a free demo version at http://www.datanumen.com/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...
|
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...
|
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
...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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 --...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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,...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |