473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Excel related problem

2
Dear Friend,
I've developed code to create Excel work book and post data in to it. Since one year it is working fine. Now from 1 week it is not working at our client place. I am not able to trace what might gone wrong or new installations happened etc.,

I am putting the code here. As soon as the application reaches Line 10 program is just exiting without giving any error message.

Dim xlFl As String
1.On Error GoTo Errh
2.Excel.Application.DisplayAlerts = False
3.xlFl = Replace(RltFl, ".rlt", ".xls", 1, 1, vbTextCompare)
CloseIfOpen xlFl
xlApp.DisplayAlerts = False
Set xlWorkBook = xlApp.Workbooks.Add
ActiveWindow.Zoom = 100
ActiveWindow.WindowState = xlMaximized
xlWorkBook.SaveAs xlFl
Feb 9 '07 #1
3 1144
Did you try to re-Install the MS Office? or did they try to make some updates like MS OFFICE 2000 to XP/2003? Try to re-Install it first with your original MS OFFICE Version because if you developed your Program under previous version of MS OFFICE like 2000 then your client is using XP/2003 then some of the functionalities might not the same as the old one. So, in short please check if there are some compatibility issues. I experienced that before...

Gud luck

Norman
Feb 10 '07 #2
Killer42
8,435 Expert 8TB
I'd suggest leaving DisplayAlerts turned on for debugging, in case you are suppressing a significant error message.
Feb 10 '07 #3
tmadhu
2
Thanks a lot buddy, Keep it up. Your suggestion shown me a way.

Regards,
Madhu.

Did you try to re-Install the MS Office? or did they try to make some updates like MS OFFICE 2000 to XP/2003? Try to re-Install it first with your original MS OFFICE Version because if you developed your Program under previous version of MS OFFICE like 2000 then your client is using XP/2003 then some of the functionalities might not the same as the old one. So, in short please check if there are some compatibility issues. I experienced that before...

Gud luck

Norman
Feb 23 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
17
by: Mansi | last post by:
I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi
1
by: Gerry | last post by:
I have an ASP.NET application installed on a Windows Server 2003 computer. MS Excel is also installed on the same computer. And yes, the application makes use of Excel. When the Application Pool...
3
by: hkappleorange | last post by:
I connect to mdb file using the following codes. How should I modify it if I want to connect to Excel instead ? <%@ Import Namespace="System.Data.OleDb" %> <% Dim conAuthors As...
2
by: Lee | last post by:
I have been trying for *many* hours to figure out how to use the OpenText method in Excel. I have a data file in text format (ASCII) and I want to import this data into an Excel worksheet using...
18
by: lgbjr | last post by:
Hi All, I have a VB.NET app that, among other things, writes data to Excel. I am having trouble getting the Excel process to terminate after I quit Excel. I found an article related to this...
3
by: Marja Ribbers-de Vroed | last post by:
Hi, One of my clients has a strange problem with my webapplication which I think may be related to some firewall setting on his computer. On several screens in the application, it is possible...
6
by: Gunawan | last post by:
Dear All, I have create an excel (COM Object) using this code Excel.Application xls = new Excel.Application(); but I can not remove it from memory although I have using close and quit ...
3
by: Chris | last post by:
I have a python script that is driving Excel and using the win32com module. However, upon program completion there's still an Excel.exe process running in the background that I must terminate...
15
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.