Posts by s_u_resh

Dear All,

Is it any way to read a excel file which is protected with password. i do not want to modify. i want to know what is in the file .

Help will be appriciated.

Thanks

Would like to know Conditional Array Formula.

Dear Adkins !
I would like to give your the solution. I am from India. I will give you the solution in 2 days time. If you agree for that. Please explain me in details. We can start doing.

I have 10 Years experiance In Excel VBA.
Looking forword your reply.

Thanks

Happy Christmas to you all.

Regards
S.Suresh
Yahoo Chat ID is : s_u_resh

dear sir ,

I have a custome function , it only works when i press F2 THEN ONLY .

I want it shold work like XLs default Functions

Example

10
10
=sum("a1:a2")

=mytotal("a1:a2")

When i change the value in a1 my function does not change the value .
if i press f2 it change

please help

I would like to know both. pls help me

Thanks

i have a xla file i want to save it to xls file , how ?

I want to modify the Add-in, I can not able to save as or save.

How do i make the modification. Pls help
Thanks

:flame:

I want to display some data from a worksheet to form in any grid. how should i do that ?

Thanks
:yes:

Thanks, I have done the same in xla.

Dear Andy,
I like your Idea that should not remove excel settings.

I already experienced that it is true. But when i am developing application in excel , I have few masters , when some one give input on master entry that time only i want to remove the settings. because validation & user will not think of trying any other option. what do you think.

all the transection i will keep the settings open.

Still i need your advice.

Do you have any application developed in excel for me to view so i will come o know how to develop.

Thanks

Reards
S.Suresh

I am writing application in excel , SO i want to remove excel menu and Tool Bars.

Is it possible to Unable to execute all default commands in excel.

Thanks

This is what i am looking for , for i have not saved the file so i do not know the file name . how will i find the file then.

The file name book1 . book2 .book3 ... like that .

what ever last made new file.

Please help me.

Thanks

I have menu List

1) Customer Master
2) Metal Master
3) Emp Master

Every time I open new workbook and ask some inpus from user. But If the user keep clicking the Customer master many times I am opening many workbooks.

How do i control that. If I Identify the last new work book and close , if user want to work on 2 multi menu option is not possible .

So I want to give some Tag to unsaved Workbook, Please Help me .

Thanks

I want to Lock Some Range. But My cursor also should not go there .

Please help me

Thanks

Thanks

I do not want to Hide the rows or colums to stop the screen rolling because ,

If i hide the rows the file size become big.

I want to disable screen rolling . Please help.

If Scroll Bars are invisible also if I use Down arrow key it keeps moving down , SO i want to stop scrolling . Thanks

Thanks you Sir , Your are reailly Super .

Please any one help me to use timer in Excel .

I want to run a macro every 1 minite.

Thanks

Dear Mr Pesky Weasel,
I do not want to use VBA forms. I want to use a Xls Sheet as a user form. I am developing a XLA program, so where will i store the XLS Sheet , with in XLA then How do i call them and make use of it.

It i am storeing the Xls Sheet seperate file then , if any one delete the file i will not able to display the sheet .

How do i write command ? like

Form.show

Sheet1.show

I want to Use Excel Sheet as a Userform. How to make use of it.

I do not want to use Forms in xla.
I want to use a Xls Sheet. Where Should i save the sheet. How do i call and make use if it.

Thanks