Hi David/Anil,
We are trying to upload the excel file through excel vba.
The files are from common shared folder not on the local drive.
I hope this helps, However, I will share the screenshot by tonight. Thanks
for your time.
Thanks
On Thu, May 9, 2013 at 10:11 AM, David Grugeon
Thanks Abhishek , it is perfect deleting all the row as per cireria.
Regards,
Chaya
On Thu, May 9, 2013 at 12:08 PM, Abhishek Jain abhishek@gmail.comwrote:
Attached.
On Thu, May 9, 2013 at 11:58 AM, Chaya chayamon...@gmail.com wrote:
Dear Abhishek,
I have a query for deleting
In essence, internet explorer does not understand excel files. You could
save the file as a web page and load that. It would not have the
functionality of excel though.
There are some proprietary products which allow you to run excel
spreadsheets through a browser. They cost though! Min $500,
Dear Chaya,
Use this.
Sub delete()
Dim cell, Searchrange As Range
Set Searchrange = ActiveSheet.Range(A1:K100)
For Each cell In Searchrange
If cell.Value = Total Then cell.EntireRow.delete
Next cell
End Sub
On Thu, May 9, 2013 at 12:17 PM, Chaya chayamon...@gmail.com wrote:
Thanks
Yes Anil Sir,
I tried your code too. its fine working. Thank you.
Regards,
Chaya
On Thu, May 9, 2013 at 12:37 PM, Chaya chayamon...@gmail.com wrote:
Yes Anil Sir,
I tried your code too. its fine working. Thank you.
Regards,
Chaya
On Thu, May 9, 2013 at 12:31 PM, अनिल
In the database sheet I added an hyperlink to a cell to another file on my
computer) as presently there are no hyperlinks, they are just formatted
blue and underlined. After I added the hyperlink, I searched for the cell
on the Home sheet, and in the results when I clicked on the cell which has
Dear experts,
I want to split the below string into seperate numbers.
Example:
15.00,63.23,18.00
i want into as :
15.00
63.23
18.00
After seperation, i want the min number of those three number. Please
find the attachment for more example
i have use Text to Coloumns, but i want in
PFA sheet solved,
You can split your data by using text to columns wizard and selecting
comma in the options.
One done with this you will data splitted in mutliple columns, now give a
min formula for the beside row, it will give u minimum value, drag it
down till the data is available. Once done,
Thanks Waheed,
Thanks for that, but i dont want to split by text to coloumns, i want
with formulas in one cell.
hope you got my point of query.
Regards,
Chaya
On Thu, May 9, 2013 at 6:26 PM, Shaik Waheed waheedb...@gmail.com wrote:
PFA sheet solved,
You can split your data by using
Hi Chaya,
Pfa
On Thu, May 9, 2013 at 6:30 PM, Chaya chayamon...@gmail.com wrote:
Thanks Waheed,
Thanks for that, but i dont want to split by text to coloumns, i want
with formulas in one cell.
hope you got my point of query.
Regards,
Chaya
On Thu, May 9, 2013 at 6:26 PM, Shaik
see if it helps
http://www.motobit.com/tips/detpg_uploadvbaie/
On Thu, May 9, 2013 at 12:30 PM, David Grugeon da...@grugeon.com.au wrote:
In essence, internet explorer does not understand excel files. You could
save the file as a web page and load that. It would not have the
functionality
Hi All,
there is an Urgent requirement for the role of Java Swing Developer in
Milpitas, CA.
Interested people may reply me at amit.go...@hmgamerica.com
The Job Description is as Follow :-
*Job Description*
* *Software Developer for the CTO Organization enabling Engineering
Development of
Hi Experts,
Please find the attached file for my problem description. I have given
notes in the file itself for better understanding.
I would like to have VBA code to list the required info
I tried but need your expertise in this regard.
Please let me know if my description is not clear.
OK. To to this you need to analyse the URL that is sent when you do it
manually, then you need to construct an appropriate URL and make this a
hyperlink.Then you can refer to the cell containing the hyperlink and open
the hyperlink.
It will be something like Range(A1).hyperlink.follow.
Regards
I
Sent from BlackBerry® on Airtel
-Original Message-
From: David Grugeon da...@grugeon.com.au
Sender: excel-macros@googlegroups.com
Date: Fri, 10 May 2013 12:08:12
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Hi Experts,
Please find the attached excel.
My requirement is :
1. There should be only one command button.
2. There should be option for command button like Sum, Average,
Sumproduct etc.. i can select the formula whichever is required.
3. If i select the cell I4 and if i press the
Hi Priti,
Sorry for the late reply., Thanks for the formula provided, really its a
very new things for me and learning tips.
Ok, Can we make in only one formula to find the min number in my attached
file earlier ?
Or else can we seperate the number seperately without array formula in your
Hi chaya ,
Yes you can do it.Please see the attached file .
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chaya
Sent: 10 May 2013 9:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Split with formula
Hi Priti,
Sorry for
Hi Priti,
Your formulas are absolutely correct no doubt. Thanks
Actually i have comma in between the numbers, plse see below, like wise.
15.00,63.00,20.00 15.00,63.00,10.00
16.00,22.00,12.00 08.00,06.00,10.11
Can We seperate by comma ? my requirement is :
For example, 15.00,63.00,20.00
I have doubts about whether you can arrive at this with any certainty.
I am assuming the channels are some sort of broadcast channels. Perhaps TV
or Radio channels. CCG is ambiguous. It could mean Canadian Coast Guard
or perhaps Central Control Government or dozens of other things.
The
please see it .
On Fri, May 10, 2013 at 10:25 AM, Chaya chayamon...@gmail.com wrote:
Hi Priti,
Your formulas are absolutely correct no doubt. Thanks
Actually i have comma in between the numbers, plse see below, like wise.
15.00,63.00,20.00 15.00,63.00,10.00
16.00,22.00,12.00
Awesome, its perfectly working.
Thanks a ton priti for the help.
Regards,
Chaya
On Fri, May 10, 2013 at 10:46 AM, priti verma pritiverma1...@gmail.comwrote:
please see it .
On Fri, May 10, 2013 at 10:25 AM, Chaya chayamon...@gmail.com wrote:
Hi Priti,
Your formulas are absolutely
From the data available there is no way to determine how many users have 3
or more channels.
Regards
David Grugeon
On 10 May 2013 15:34, Sri Jai jaisri1...@gmail.com wrote:
Thanks david for the response
I think i confused you uncessarilly..(Apologies)As attached in the
word
23 matches
Mail list logo