dinilkarun

Hi, I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating …

Hi, I am running a batch file to generate a report. A command similar to the below one is put in the batch file. [url]http://localhost/XXXX/XXXX/Test.asp?format=EXCEL&cqs=N3-FMIJTUVMUTPO-QQEWQ3MP[/url] Test.asp contains the below <%@ Language=VBScript %> <% select case Request.QueryString("format") case "EXCEL", "Excel", "excel": Response.ContentType = "application/vnd.ms-excel" case "WORD", "Word", "word": Response.ContentType = "application/msword" …

Hi All, I am updating a column in a table through SQL+ using Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual; The same field when updated through an application has a time offset of 4hrs. Select dbtimezone from dual; returns DBTIME ------ -04:00 I want to form a statement which will update the field with …

I am encountering the error attached "UnicodeEncodeError: ASCII codec can't encode character u'\0152' in position 124: ordinal not in range(128)" Please help me solve this.....

I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column. I want to know the SQL statement to find out the base tables of th view and also the base …

Hi, Im working on a stored procedure to get monthly reports from a table. For that i need to develop a logic to perform the following function: suppose i give a start_date and end_date, i need to get the months split up between these dates. for eg) if I give …

Can somebody help me with the code to read file names from a folder? curretnly i'm using the below code. Dim files() As String files = System.IO.Directory.GetFiles("c:\myfolder") this is not working please help me.

Hello Friends, Through python I am able to generate an excel report. In one of the cells I have populated an e-mail address which shows up as a hyperlink. Can I make this hyper link to launch outlook with the e-mail address present in the cell in the "To" and …

Hi Friends, I need to write a piece of code to identify if an Excel session(the process which is listed in the Task Manager) is already running or not?. Can anyone guide me with this? Any help will be much appreciated! Regards, Dinil

Hi All, How can I increase the time for which the ToolTip is displayed. I currently have a radio button for which I have set a tooltip and the content is large. There is not enough time for the User to read it completely. I dont want to use the …

Hi friends, I want to copy few cells of an excel sheet and paste special(picture) in ms-word. I want to develop a vb code code for this. Please help!... Regards, Dinil

Hi All, I am using the below code to write into a text file [CODE] # Write into log file inp=file(Doc\Log.txt, 'w') inp.write('Log file start') inp.close()[/CODE] The text file 'Log.txt' is present in 'Doc' folder inside the application folder. Now I want to create a text file with a time …

Hi All, I am using the following code to write data into an excel sheet: [CODE]# Open the Output Spreadsheet objExcel = win32com.client.Dispatch("Excel.Application") # Creating object to write to Spreadsheet self.xlApp =Dispatch("Excel.Application") # Creating Workbook self.Wkbk = self.xlApp.Workbooks.Add() # Get sheet count intShtCnt=self.Wkbk.Worksheets.Count # Creating worksheets wsObjReport = self.Wkbk.Worksheets.Add() # …

Hi All, I am using the .search function. [code=python] strValue="XXX" strTemp1="YYYXXX" strTemp= strTemp1.search(strValue) [/code] Python is not able to recognise the .search function. AttributeError: 'str' object has no attribute 'search' What should I import for this? Please help!

Hi All, I have two frames.viz., frm1 and frm2. On click of a button on frm1, I want frm2 to pop up and frm1 to hide. Presently I am using the following code: [TEX]self.Hide() self.frm2=frm2.clsFrame2(self) self.frm2.Show()[/TEX] clsFrame2 is the class present in frm2. The above code if written on the …

Hi All, I have the following string: "AND Category 07|Spec 01|ABC 01 AND Category 07|Spec 02|XYZ 02 AND Category 07|Spec 03|PQR 03 " It is stored in a string variable. I want to remove only the "ABC 01", "XYZ 02", "PQR 03", etc from the original string. The new string …

Hi All, I have created a grid and want to implement the following idea:

Hi All, I have created a grid and want to implement the following idea: The user should be able to enter only numeric values in any of the cells in that grid. I could not get any property of the cell which can check for the entered data. Please guide …

Hi All, I am developing a GUI in Boa Constructor. I am using a grid for displaying some data and want to change the names of the column and row headers in the grid. Please help me in achieving this. Regards, Dinil

Hi All, I would like to create new rows dynamically. When a user clicks a button, a new row should be added in the grid. Please guide me as to how can I achieve this. Thanks, Dinil

Can anybody please help me with the code to read file names inside a zip file using VB6. I am able to open(not extract) the zip file.

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, …

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, …

Hi, I would like to insert a background image in an excel sheet which is generated through VB code. The image should be inserted in such a manner so that any data in the same cells can be seen over the image. (i.e the image should be in the background …

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could …

I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr]

hi, I want to put a textbox over a bitmap in MS Excel sheet and populate the textbox with a value from VB code. Please guide me in acheiving the same. Regards, Dinil

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could …

I am calling the below function on the click of an 'OK' button to set the attribute of a cell of a table (attributes for <td> tag), however i am not able to set the 'style' attribute of the <td> tag with the code below. Please help me in achieving …

Please help me in positioning the scroll bar at the bottom of text. Please help me by providing the code snippet.