Hi got a nice piece of code from this site:
http://code.activestate.com/recipes/303339/

I am now able to check if an Excel process is running or not. The code does not use WMI and works fine on...

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...

I am using BOA Contsructor

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...

oh yes.. that makes it even more simpler.. Thanks a lot again....

Thanks... i used the below code and its working perfectly..
Thanks a lot :)

lt = time.localtime(time.time())
lt=[lt[1], lt[2], lt[0], lt[3], lt[4],lt[5]]
...

Hi All,

I am using the below code to write into a text file

# Write into log file
inp=file(Doc\Log.txt, 'w')
inp.write('Log file start')
inp.close()

The...

Thanks a lot brother.. Its working fine.. I am now able to change the color of each row.
Thanks once again!...

Hi All,


I am using the following code to write data into an excel sheet:

# Open the Output Spreadsheet
objExcel = win32com.client.Dispatch("Excel.Application")

# Creating object to write...

Hi All,

I am using the .search function.

strValue="XXX"
strTemp1="YYYXXX"
strTemp= strTemp1.search(strValue)

Python is not able to recognise the .search function.
AttributeError: 'str'...

sorry.. I goofed up in wrapping the code.
its here:
self.Hide()
self.frm2=frm2.clsFrame2(self)
frm2.Show()

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:

self.Hide() ...

Thanks all for the great answers. I have solved it sucessfully..
Thanks once again....

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...

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...

Hi All,

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

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...

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

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...

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...

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...

I want to do the following in excel sheet fully using VB code.

1. Placin 1 single bitmap from (1,1) to (1,8) cell
2. Placing a text box over it.
3.filling the textbox with text.

THe above...

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...

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...

I tried setAttribute(), it does not work and throws up an error saying object expected. SetAttribute() for other attributes works fine, but for 'style' attribute it does not work.

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...

My application is developed in MS Access using VB. I have a form having multiple textboxes and other controls. Running the code for setting the scrollbar to the end is not working here and throws up...

the code is giving error!!!1

Please help any other alternative.

ExcelSheet.PageSetup.PrintTitleRows = "Sheet1!$1:$3"

Please help me in automatinng the following in my EXCEL sheet using VB.
I want to make my first two rows as Repetitve in every page of print.In excel it can be done as

PAGE SET UP->SHEET -> Print...

no

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

its the name of field of NUMBER type in MS ACESS back end.

The back end value is being passed as as Integer parameter to a function.Inside the function i need to add De_hours value into a Sum...

It is not working.
Please Help

I am coding in VB to add 3 fields of MS Access back end.
If there is no value (or blank) in a particular field, I want 0 to be considered in addition.

Following code is not working for checking...

I want to populata records into a list where i can have the following functionalities.

1) Multiple selection of records

2) Back colouring of individual reords.

Among Flexgrid and Datagrid...

My requirement from list is

1) Multiple selection of records.

2)Back colouring of record.

Please suggest which Grid should i go with.?FLEXGRID or DATAGRID

I want to choose a grid which...

I want to colour the 8 the column in evry row and movement row is done by "I".

For I = 0 To lstProject_report.ListCount
lstProject_report.Column(8, 1) = QBColor(I)
Next

I am getting...

I am gettin error message
"The RowSourceType" Property must be set to "Value List" to use this method.
The code is stoping at
lstProject_report.AddItem "Color " & I
in Form_load()...