Hi,
I have a worksheet with dependent value.
For eg. when i am select a2 value from the list, b2 cell have values depend on the a2 cell. (b2 contains some formula)
But i want to non-editable the b2 cell (user cannot edit the formula)
Plz help me.
Thanks,
Murugavel
murugavelmsc
Last Activity: Feb 17 '10, 09:14 AM
Joined: Apr 29 '08
Location:
-
How to set non-editable cell in excel
-
Excel VBA
Hi,
I have an Excel VBA with Modules in it. I want to remove all the modules after save as a another file name. How can I do this?
Thanks,
Murugavel -
vba excel
Hi all,
I create a macro in excel through vba of file size of 3 MB, when i run the script and save it as an different file name means , that file have a size of same 3 MB.
How to solve the issue.
Please help me.
Thanks,
Murugavel -
application defined error - VBA
Hi,
I have an excel sheet that is loaded with a dynamic result set of data. Column C2 depends on A2 Column data. The following code throws an 'Applicaton-defined or object-defined error':
...Code:Sheet1.Activate With ActiveWorkbook.ActiveSheet.Range("C2").Validation .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _ "=OFFSET(regionstart, MATCH(A2, -
in vba, convert excel to xml
Hi,
I have a excel with some data. But i want to convert the data in xml file.
Plz help me.
in Excel
link Title
xml/20423325 Guggenheim Museum, NYC
xml/192323325 The Stele of Naram-Sin - coming soon!
xml/23325 Studio Technique Video - Carving
In XML
...Code: -
VBA in excel
I have given below a trial balance which is exported from Accounting package to excel. Negative Values are shown as CR and Postive Values are shown as DR. These values are formatted using custom format
0.00" Cr"
0.00" Dr"
I want to filter the positive values in one coulmn and negative values in another column which i am not able to do so using if command of excel. Can anybody help in filtering... -
Vba: convert pdf file to ps
Hi,
In VBA, how to convert PDF file to PS file.
Thanks in advance,
Murugavel -
Call Javascript from VB
Hi,
in VB, How to javascript function, and returns the value from Javascript.
In VB, i added the script control1.0
pls guide me with sample code.
thanks,
Murugavel -
Convert Javascript to VBscript
Hi,
i have a javascript code. I want to convert into VBscript.
pls
help me
Javascript Code:
...Code:<!-- TWO STEPS TO INSTALL VIRGENERE ENCRYPTION: 1. Copy the coding into the HEAD of your HTML document 2. Add the last code into the BODY of your HTML document --> <!-- STEP ONE: Paste this code into the HEAD of your HTML document -->
-
Encryption
Hi,
In Mysql, Password field is encrypted.
For example:
password: for "textech"
it shows *&-haOZ (MySQL)
Thanks,
Murugavel -
Encryption
Hi,
I have use VB and mysql. In login form, how to compare the password field to mysql database encrypted password field.
in vb, how to convert the password text to encrypted field
pls help me.
bye
murugavel -
Perl Regular Expression
Hi,
I have a text file of 1,2,3,678,90, 100 as text.
i want to convert the number as three digit number in perl.
eg,
001
002
003
678
090
100
please help me
thanks,
murugavel -
Number of Sundays
hi,
in mysql, how to calculate no. of sundays in a month through query.
thanks
murugavel -
Date Function
Hi,
In MySql, I have a leave table. In this, fromdate and todate fields are there.
i want to display what are the dates in between two dates using query.
please guide me.
Thanks,
Murugavel -
Problem with Date-Comparison - Curdate()
Hi i write a javascript code, it throws an error
[CODE=javascript]tod=new Date()
if(row["birthdate"]=tod.getDate())
{"/webcontent/birt/images/birthdaycake2.j pg"}
else
{"/webcontent/birt/images/bxp37686.jpg"}[/CODE]
Thanks,
Murugavel -
ya i got a error of unknow columns rowcursor...Leave a comment:
-
VBA with MysQL
Hi,
i develop a application with VB and mysql.
my question: in excel a1 column have a 10 values. Based on the values we get data from mysql and place it in a2 columns (corresponding row)
Eg:
Excel
A1 Column A2 columns
5 retrieve the value from database based upon 5
6 retrieve the value from database based upon 6
7 ... -
<asp:DropDownLi st ID="ddprodid" runat="server" Width="135px" DataSourceID="S qlDataSource1" DataTextField=" ProductID" DataValueField= "ProductID" OnSelectedIndex Changed="ddprod id_SelectedInde xChanged">
</asp:DropDownLis t><asp:SqlDataS ource ID="SqlDataSour ce1" runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:pmgConnectio nString5...Leave a comment:
-
DropDown List and TextBox
hi,
in asp.net, i have form with dropdownlist contains a item of productid from the product table. Another item is textbox which is depends upon the dropdownlist.
whenever a dropdownlist index changed, textbox have a productname of productid.
thanks in advance,
Murugavel -
Navigation in Gridview
hi,
i am using two pages, the first page contains the gridview control which i select one record means that job id of particular record move to second page through querystring. But in second page i have a design like form of textboxes and dropdownboxes.T his control are filled depend on the job id which i select from first page.
i try the below mentioned code, it throw an error like "Invalid attempt to read when no data...Last edited by Curtis Rutland; Aug 12 '08, 04:32 AM. Reason: Added code tags -- Please use the # button
No activity results to display
Leave a comment: