Hi
Pls find the code.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
Cancel = True
End If
End Sub
This will work only if the workbook has been saved once.
On Fri, Jul 22, 2011 at 12:07 AM, Anshul wrote:
> Please let me know how i can remo
Hi
1. I have created a database with some custom menus. In that I am having a
menu called "Manage" and I require a code which should hide the particular
menu for particular users.
2. I have created a form for startup and I don’t want allow the users to
close the form using the Cnrl+W. It should
Experts,
In order to unlock locked sheets/workbooks or VBA project, which program or
codes would you suggest.
Regards
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Please let me know how i can remove save as option from excel file...I have
restrict persons not to save as anexcel file.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Dear Raghvendra,
Please try below code and see attached sheet
Sub advancefilter_sumif()
Dim i, j As Long
Dim abc, cba As Range
Application.ScreenUpdating = False
Sheet1.Range("A1:A" & Sheet1.Range("A1").End(xlDown).Row).Copy
Sheet1.Range("D1").Select
ActiveSheet.Paste
Sheet1.Range("E1").Valu
Dear Raghunandan,
Please use below link for Call center Dashboard
http://www.klipfolio.com/products/call-center-dashboard
http://www.inovasolutions.com/call-center-reporting/products/call-center-dashboard.html
On Thu, Jul 21, 2011 at 10:10 PM, Raghunandan wrote:
> Hi Guys,
>
> Can any1 help me
try this see if it helps
On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava wrote:
> Harish,
>
> Did you try it.. ??
>
> On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
>
>> Harish,
>>
>> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in
>> that macro.
>>
create a pivot table . check the attachment.
On Thu, Jul 21, 2011 at 10:49 PM, Raghavendra wrote:
> Hi,
>
> Can anyone let me know VBA code for the below?
>
> Input Data
>
> Names Amount
> A 100
> B 200
> C 100
> B 100
> A 100
> D 150
>
> Out put data shou
add this line before if condition see if it helps
wb.Sheets("Pivot").select
On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava wrote:
> is it possible to attach the sheet? You can remove the data from it or
> replace the values..
>
>
> On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
>
>>
try this book
http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
and websites join these forums
www.mrexcel.com www.contextures.com www.rondebruin.nl www.ozgrid.com
www.cpearson.com
peltiertech.com
chandoo.org
www.mvps.org/links.html
www.vbaexpress.com
www.functionx.com
check few examples here
http://akoul.blogspot.com/2010/07/vba-code-to-send-email-through-excel.html
http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html
http://akoul.blogspot.com/2010/08/sending-e-mail-based-on-data-in-column.html
On Fri, Jul 22, 2011 at 12:01 AM, Anish Sh
try the attached file
On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan wrote:
> try this
>
>
>
> =IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))
>
>
> On Thu, Jul 21, 2011 at 10:54 PM, Prabhu wrote:
>
>> Hi Friends,
>>
>> In the attached sheet wherever we
try this
=IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))
On Thu, Jul 21, 2011 at 10:54 PM, Prabhu wrote:
> Hi Friends,
>
> In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
> replace with # and add with the previous cell which doe
Hello Prabhu,
Use this in B2 & copy down.
=IF(ISNUMBER(SEARCH("Opt. ",A2)),LOOKUP(2,1/ISERROR(SEARCH("Opt.
",A$2:A2)),A$2:A2)&SUBSTITUTE(A2,"Opt. ","#"),A2)
Then copy Col_B *Paste Values *in Col_A. Then after delete Col_B.
HTH
Haseeb
--
--
Hi,
You can’t do it with a formula (a formula only changes the value of the cell
which contains it). Either you use the replace command (Ctrl+H) or you have
to use a macro.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé :
Try :
Sub ConFormatOffset3()
Dim LastRow As Long
LastRow = Cells.Find("*", , , , xlByRows, xlPrevious).Row
With Range([D1], Cells(LastRow, "EJ"))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression,
Formula1:="=AND(F1<>,D1>F1)"
.FormatCondition
A Pivot Table is used precisely for such computations. As a thumb
rule, use Excel functions and tools where Excel can handle it
efficiently. Use VBA only if Excel cannot give desired output on its
own
On Jul 21, 10:19 pm, Raghavendra wrote:
> Hi,
>
> Can anyone let me know VBA code for the below?
Yes Prabhu, It is possible.. Pour in your further details/sample
attachments.
On Thu, Jul 21, 2011 at 11:03 PM, Prabhu wrote:
> Hi all,
>
> I need to send Automatic mail message from my mail id to some around 10
> members in every week end to remind them to do something.
>
> I can create distrib
Haseeb Sir,
I am becoming a FAN of you... You seem to have super knowledge of
Formulas... tooo good...
On Thu, Jul 21, 2011 at 9:58 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Prabhu,
>
> Use SUBSTITUTE. or excel's Find/Replace command
>
> SUBSTITUTE is a case sensitive fun
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote:
> Yes, the names are all ok, i double checked it, even try to change names,
> but doesn´t work :S
>
> 2011/7/21 Anish Shrivastava
>
>> Please check
Hi,
How to learn Excel VBA. If i chose VB.Net course it's cover Excel VBA
Or any special course to learn Excel VBA.
Also advice where i can learn.
Regards,
Prabhu
--
--
Some important links for excel users:
1. F
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava
> Please check if the sheet name is "Pivot".
> if not then rename it to Pivot.
> On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
>
>> Hi guys, i have this macro i us
Hi Guys,
Can any1 help me out by sending Call center KPI dashboards or any link where
in I can find that.
Thank you...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
Can anyone let me know VBA code for the below?
Input Data
Names Amount
A 100
B 200
C 100
B 100
A 100
D 150
Out put data should be
Names Amount
A 200
B 300
C 100
D 150
Regards,
Raghavendra
--
---
Thank you Dave for the last cell point & the correction. I didn't notice the
last column being Yes.
I think Column U don't have to be blank, because we have an additional
column (A) without Yes or No, so If we change the formula without including
column U, like,
=SUMPRODUCT(--(B2:T2="Yes"),--(
Hello Prabhu,
Use SUBSTITUTE. or excel's Find/Replace command
SUBSTITUTE is a case sensitive function, so you need convert the cell to
UPPER or LOWER, so use,
=SUBSTITUTE(UPPER(A1),"ABC","")
Or,
=SUBSTITUTE(LOWER(A1),"abc","")
All the letters in 1st output will be in CAPITAL LETTERS
All the
Hi all,
I need to send Automatic mail message from my mail id to some around 10
members in every week end to remind them to do something.
I can create distribution list for whom i have to send mails, Message
content will be same only.
It needs to reach every week end to that particular distrib
Dear members,
Thanks for all your contribution to group. I am very happy to see the
great participation in the group.
For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey, so feel fr
Hi Friends,
In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
replace with # and add with the previous cell which does not contain
"Opt."originally.
As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add #
with A8 as prefix.
Similarly in A3 "Opt. 0D1"
Please check if the sheet name is "Pivot".
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote:
> Hi guys, i have this macro i use to copy a range from column D of a
> worksheet of a workbook to column G of another workbook and worksheet, but
> it keeps giving me
Hi guys, i have this macro i use to copy a range from column D of a
worksheet of a workbook to column G of another workbook and worksheet, but
it keeps giving me the same error saying that it´s "subscript out of range"
in the line in yellow.
Public wb, wbmes As Workbook
Sub filldatabase()
Call Abr
Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.
My data I'm comparing is in Column D and F, E and Getc all the way
up to Column EK. Any pointers on skipping around with this formula?
Thanks again!
Natron
> Try
Hi All,
Great!!! Thanks..
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.li
@Anish, that's cool dude, just trying to help.
Sam Mathai Chacko
On Jul 21, 9:41 pm, Anish Shrivastava wrote:
> Prabhu,
>
> Use the solution given by GoldenLance below.
>
> =SUBSTITUTE(A1,"ABC","#")
> *GoldenLance,*
> Thanks Man, This formula didnt hit my mind at that time.
>
>
>
>
>
>
>
> On Th
Harish,
Did you try it.. ??
On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
> Harish,
>
> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in
> that macro.
>
> Use this attachment.
>
> On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava
> wrote:
>
>> Hi Harsi
Prabhu,
Use the solution given by GoldenLance below.
=SUBSTITUTE(A1,"ABC","#")
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.
On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance wrote:
> Wouldn't this be much more easier, and apt?
>
> =SUBSTITUTE(A1,"ABC","#")
>
> On Jul 21,
Wouldn't this be much more easier, and apt?
=SUBSTITUTE(A1,"ABC","#")
On Jul 21, 9:27 pm, Prabhu wrote:
> Hi Anish,
>
> If it is "ABC12" and i need to replace the ABC form the cell then the
> formula will be ?
>
> Regards,
>
> Prabhu
--
-
Hey Prabhu,
try this formula
=IF(ISERROR(REPLACE(A1,FIND("ABC",A1),3,"#")),A1,(REPLACE(A1,FIND("ABC",A1),3,"#")))
On Thu, Jul 21, 2011 at 8:50 PM, Prabhu wrote:
> Hi Friends,
>
> Can you help me to know the formula for find and replace.Examble i need to
> find "ABC in the A1 cell and rep
Hi Anish,
If it is "ABC12" and i need to replace the ABC form the cell then the
formula will be ?
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
ht
Try :
Sub ConFormatOffset()
With Range([A1], Cells(Rows.Count, 1).End(xlUp))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _
Formula1:="=A1>B1"
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
End Su
If you are looking for an Excel formula, just use
=SUBSTITUTE(A1,"ABC","")
On Jul 21, 8:37 pm, "Daniel" wrote:
> HI,
>
> Sub ABCReplace()
>
> [A1].Replace "ABC", "#"
>
> End Sub
>
> Regards.
>
> Daniel
>
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part
You are welcome.
Oh just noticed, out of curiosity, why is my message displayed after
Ashish's? I messaged it before!!
On Jul 21, 2:47 am, Natron wrote:
> Thanks to both Ashish and GoldenLance. Problem solved.
--
-
HI,
Sub ABCReplace()
[A1].Replace "ABC", "#"
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 17:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Re: ***Formula for f
Giving the formula as per your example.
*=IF(RIGHT(A1,3)="ABC",LEFT(A1,2)&"#",A1)*
Copy it down.
On Thu, Jul 21, 2011 at 8:55 PM, Prabhu wrote:
> Hi Friends,
>
> Can you help me to know the formula for find and replace.Example i need to
> find "ABC in the A1 cell and replace with "#". If th
Hi Friends,
Can you help me to know the formula for find and replace.Example i need to
find "ABC in the A1 cell and replace with "#". If there is no 'ABC"
existing A1 should remain as it is.(Not using ctr+H)
*Example.*
Existing Cell Replace as
12ABC 12#
1
Hi Friends,
Can you help me to know the formula for find and replace.Examble i need to
find "ABC in the A1 cell and replace with "#". If there is no 'ABC"
existing A1 should remain as it is.
Existing CellReplace as
12ABC 12# 13XTZ 13XTZ
--
--
Hi,
I have names, order no and county names in two sheets.. need to consolidate
in one sheet..
Thanks
On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava wrote:
> Vijay,
>
> Though you have provided the sample sheet your requirement is not clear.
>
> What do you mean by merge the names in one s
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the names in one sheet. do you want to consolidate
the data or you want a concatenation.
On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA wrote:
> fyi
>
>
> On Wed, Jul 20, 2011 at 6:25 PM, N
Hi Avinash,
Try below Links,
http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html
--
*Best Regards,*
*Venkat*
*
*
On Thu,
http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html
http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.html
http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html
On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar <
chandrashekarb@gm
Any link is ok. Just I need to learn how to do this task. Thanks.
On Thu, Jul 21, 2011 at 2:15 PM, ashish koul wrote:
> can you send the direct link
>
>
> On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> How to extract data from websites fo
Thanks a ton to one all really helped me alot in this concern.
On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab wrote:
> Hi
>
> For Vlookup you can use static Name range which is predetermined
> RANGE
> =SBUMapping!$A$1:$D$789
> OR
> dynamic Name range range which resize dynamically
> RANGE
>
> =O
Hi Avinash,
Try this:
http://www.freeexceldashboards.com/exceldashboardtemplates.html
Cheers,
Andy
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like dro
can you send the direct link
On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> How to extract data from websites for ex: Yahoo News Columns. could anyone
> provide VBA code for this. Thanks!
>
> --
>
> ---
open this link
http://chandoo.org/wp/excel-dashboards/
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with fu
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
"a dashboard with full graphical and customization interface"
i'll be realy greatfull to you guys please forward me the designs,
Regards,
Harish,
PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK* in
that macro.
Use this attachment.
On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava wrote:
> Hi Harsih,
>
> Since you didnt reply about column headers I assumed that it's the same for
> every file on share driv
Hi Harsih,
Since you didnt reply about column headers I assumed that it's the same for
every file on share drive.
Please see the attached file with macro.
You must populate the file path in Sheet2-A1.
Do let me know if it works fine for you.
Cheers!!
Anish
On Thu, Jul 21, 2011 at 4:00 PM, Anish
Hi,
How to extract data from websites for ex: Yahoo News Columns. could anyone
provide VBA code for this. Thanks!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:
Hi,
Just Go to Below link and sign in your Gmail account..and set as a
https://groups.google.com/group/excel-macros/subscribe?hl=en
and go to Edit my membership --->Email *(Approximately 15 emails per day)*Send
each message to me as it arrives
and save it...
--
*Best Regards,*
*Venkat*
*
*
O
Harish,
I forgot to ask you one thing.
The column headers in the file you attached will be constant for all the
30-35 files which are there on your sharedrive, right?
Cheers,
Anish
On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma
wrote:
> Hi Anish,
>
> Please find attached the sample file with one
Sure Harish :) ..
You will have it soon..
On Thu, Jul 21, 2011 at 3:45 PM, Harish Sharma wrote:
> Can someone help this is really urgent.
>
> Thanks
> Harish
>
>
> On 20 July 2011 23:06, Harish Sharma wrote:
>
>> Hi Anish,
>>
>> Please find attached the sample file with one row filled.
>> And C
Can someone help this is really urgent.
Thanks
Harish
On 20 July 2011 23:06, Harish Sharma wrote:
> Hi Anish,
>
> Please find attached the sample file with one row filled.
> And Column "C" & Column "H" concatenate should give us unique value so if
> this is repeated then we need to have below r
Thanks a lot everyone for your quick help. This is one of the best
forums for Advance Excel.
Azeema
On Jul 20, 2:42 pm, Haseeb Avarakkan
wrote:
> Hello Azeema,
>
> Use this formula, say in V2 & copy down.
>
> =COUNTIFS(A2:S2,"Yes",B2:T2,"<>Yes") This will only work XL2007 or later.
>
> If you wa
Hi
1. I have created a database with some custom menus. In that I am having a
menu called "Manage" and I require a code which should hide the particular
menu for particular users.
2. I have created a form for startup and I don’t want allow the users to
close the form using the Cnrl+W. It should
Try this
Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
.Open
End With
From: excel-macros@google
Hi Ashish
Thanks for that. How do I toggle the 'TabOrder' on ? At the moment the tab
order is not working.
Thanks
Charlie
On Thu, Jul 21, 2011 at 7:08 PM, ashish koul wrote:
> try this
>
>
> On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose wrote:
>
>> Hi Rajan
>>
>>
>>
>> I have attached copy o
Any chance to think about it?
Sent from my iPhone
On Jul 20, 2011, at 1:06 AM, Adam Hamilton wrote:
> You're a godsend!
>
> On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava
> wrote:
>> Tracking sheet.. I see.. I will have a look and try my best to give one
>> dummy dashboard by tomorrow.
http://support.microsoft.com/kb/306125
http://support.microsoft.com/kb/321686
http://www.ozgrid.com/forum/showthread.php?t=83016&page=1
On Thu, Jul 21, 2011 at 10:44 AM, Markkim wrote:
> Hi all
>
> I'm trying to learn how to connect to SQL Server and extract information
> from Excel.
>
> The
69 matches
Mail list logo
