Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

Hi Bill, There are two variable defined in your module. These are "RunWhen" and "SaveWhen". Both of them are being used with timeserial value. You can provide your desired time in this parameter(TimeSerial). Suppose you want to Run your code at 1500 hrs then you can modify your code as below: Run

Re: $$Excel-Macros$$ Help req.

Dear Neeraj, Pl find attached. Regards, Gawli On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. i want to make the conditional format, but > how to make. revert me > > -- > Join official Facebook page of this forum @ > https://www.facebo

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

Thanks a lot Ashish, this is what exactly what i am looking. I small addition required, Once the Formula is placed and formula resulted converted to % format, the value should highlight in red font if the value is more than > 10% only for that result row. Is this possible? On Tue, Dec 11, 2012

$$Excel-Macros$$ Help req.

Dear Experts, kindly find the attached sheet. i want to make the conditional format, but how to make. revert me -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen

Re: $$Excel-Macros$$ Animated_Logo

Dear Pravin First Thanks for your valuable time for my solution & sorry for change your name.Now it s working fine Regards Amar On Wed, Dec 12, 2012 at 10:58 AM, Pravin Gunjal wrote: > *Hi Amar,* > * > * > *Pl be noted that, I am not Prince and I am Pravin.* > * > * > *Also note that you can

Fwd: $$Excel-Macros$$ Animated_Logo

*Hi Amar,* * * *Pl be noted that, I am not Prince and I am Pravin.* * * *Also note that you can change the animation effects by changing it's parameters as per your requirement.* * * *Regards* *Pravin Gunjal * -- Forwarded message -- From: amar takale Date: Wed, Dec 12, 2012 at 10:

Re: $$Excel-Macros$$ Animated_Logo

Dear Prince Sir Thanks for great guidance Now I repair my mistek. One more question sir,Can I give different effect for animation. On Tue, Dec 11, 2012 at 7:09 PM, Pravin Gunjal wrote: > *Dear Amar,* > *Pl find the attached file as per your requirement.* > * > * > *It was not working as because

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Thanks Very much Ashish Sir & Excel user group On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user wrote: > Hi Amar, > > Try this array formula > =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) > > > > > > On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > >> Hi All Champs >

$$Excel-Macros$$ Re: Need to create a summary sheet

Hi, Prince I need to go a step further, is there any way that instead of number the name of person will appear in the cell so that we can differentiate each person. On Tuesday, December 11, 2012 7:12:45 PM UTC+5:30, satyas wrote: > > Thanks Prince > > > > On Friday, December 7, 2012 4:06:27 AM

Re: $$Excel-Macros$$ need formula please

Hi Raghu, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > sir, > I need a formula for total sum of each account no wise as given in excel > sheet. > > Thanks

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

Hi Amar, Try this array formula =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0)) On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join offic

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

I verified the path is correct (when I type the path into explorer, it opens the template) On Tue, Dec 11, 2012 at 1:20 PM, wrote: > ** > have u selected the correct template and extension of template > Pls check it once again > Sent on my BlackBerry® from Vodafone > ---

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

have u selected the correct template and extension of template Pls check it once again Sent on my BlackBerry® from Vodafone -Original Message- From: Laura Ann Dietrich Sender: excel-macros@googlegroups.com Date: Tue, 11 Dec 2012 13:09:35 To: Reply-To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

Thanks. When I try that code (with the corrected file path), it no longer creates a new worksheet or names one. It just points me to a random cell on the last worksheet. On Tue, Dec 11, 2012 at 1:03 PM, ashish koul wrote: > sorry forget to mention please change the path of template as per your

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

sorry forget to mention please change the path of template as per your system and template name "C:\Documents and Settings\user\Desktop\sample.xltx" On Tue, Dec 11, 2012 at 11:31 PM, ashish koul wrote: > Hi Laura > > > *Please try this code* > > Private Sub Worksheet_Change(ByVal Target As

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

Hi Laura *Please try this code* Private Sub Worksheet_Change(ByVal Target As Range) Dim wsNew As Worksheet Dim sht As Worksheet If Target.Cells.Count > 1 Then Exit Sub On Error Resume Next If Not Intersect(Target, Range("A6:A99")) Is Nothing Then Set wsNew = Sheets(T

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

try this *Private Sub Worksheet_Change(ByVal Target As Range)* *Dim wsNew As Worksheet* *Dim sht As Worksheet* *If Target.Cells.Count > 1 Then Exit Sub* * * *On Error Resume Next* *If Not Intersect(Target, Range("A6:A99")) Is Nothing Then* *Set wsNew = Sheets(Target

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

"scanningprocess.xltm" is one worksheet. On Tue, Dec 11, 2012 at 12:47 PM, ashish koul wrote: > how many sheets u have created in "scanningprocess.xltm" template > > > > > > > On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich > wrote: > >> scanningprocess.xltm > > > > > -- > *Regards* > * *

Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

how many sheets u have created in "scanningprocess.xltm" template On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich wrote: > scanningprocess.xltm -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think abou

$$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell Value

Nevermind, I figured out the reason for the error. It solves my second issue. But not the first. What do I need to modify to make the new worksheet it creates my template "scanningprocess.xltm" instead of a blank worksheet? Thank you. On Tuesday, December 11, 2012 12:18:40 PM UTC-5, Laura Ann

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

add one more* end if* at the end see below * If wsNew Is Nothing Then* * Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Target.Text * * End If* * End If* *end sub * * * On Tue, Dec 11, 2012 at 11:11 PM, Laura Ann Dietrich wrote: > Thank you! When I do that

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

Thank you! When I do that I get the following error (I attached screenshot so you could also see the macro) On Tuesday, December 11, 2012 12:32:27 PM UTC-5, ashish wrote: > > Hi > replace

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

Hi replace this * If wsNew Is Nothing Then Sheets.Add().Name = Target.Text* *End If* * * with below one * If wsNew Is Nothing Then* * Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Target.Text * * End If* * * Regards Ashish On Tue, Dec 11, 2012 at 1

$$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

My end goal is to have new worksheet templates "scanningprocess.xltm" auto generate/name based on the values of cells on the main worksheet (A6:A99). So far I have the following macro that auto creates a new worksheet. The troubles I am having are the following: 1. It is a blank worksheet - not

Re: $$Excel-Macros$$ Request for formula:Unique value from same month

=MAX(IF(MONTH($E$7:$E$27)=MONTH(H8),$F$7:$F$27,"")) press + ctlr + shift+ enter On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote: > Hi All Champs > > I will Request all anyone suggest me unique value from same month (formula) > > Regards > Amar > > > -- > Join official Facebook page of thi

Re: $$Excel-Macros$$ VBA code for convert xls,xlsx into .CSV file

http://www.automateexcel.com/2004/08/14/excel_vba_convert_excel_to_csv_comma_del/ http://www.java2s.com/Code/VBA-Excel-Access-Word/File-Path/ExportactiveworksheettoCSVfile.htm http://www.ozgrid.com/forum/showthread.php?t=76720 On Tue, Dec 11, 2012 at 2:02 PM, Satheeshkumar Yadav < satheesh.aru

$$Excel-Macros$$ Re: Need to create a summary sheet

Thanks Prince On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote: > > Need to create a summary sheet for the attached Excel doc. > > Tab “Detailed” is the input tab and works fine. > > Tab “Summary” should show the name from the A column in “Detailed” in any > cell that corresponds.

Re: $$Excel-Macros$$ need formula please

your file (it's working only on one condition, that you account_no column is SORTED!!!) I didn't want to advice you to do pivot table as per request function.   awel From: raghunandan rallapalli To: excel-macros@googlegroups.com Sent: Tuesday, December 11, 2012

Re: $$Excel-Macros$$ need formula please

Hi, find below & use this =SUMIF($A$2:$A$23,A2,$C$2:$C$23) thankx satendra On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > sir, > I need a formula for total sum of each account no wise as given in excel > sheet. > > Thanks in advance please

Re: $$Excel-Macros$$ Re: BOND Macro

Hi Prince, Thanks for your feedback. Attached is an excel sheet with the macro and am getting zerodid i do it wrong? Thanks and regards, Boreh On 11 December 2012 14:27, Prince wrote: > Hi Kip, > > I got 91.7021557489662 value in price variable and i call this function > as per the param

$$Excel-Macros$$ Re: VBA code for convert xls,xlsx into .CSV file

Hi Satheeshkumar, Please try this code hope this will help you. Public Sub GetBrandsFiles() Dim varArrFile As Variant Dim intCtr As Integer Dim strFilesAs String Dim wbk As Workbook varArrFile = Application.GetOpenFilename("*.xls,*.xlsx", , "Select

$$Excel-Macros$$ Re: BOND Macro

Hi Kip, I got 91.7021557489662 value in price variable and i call this function as per the parameter provided by you ie : Sub test() Call PRICE364("31-10-2012", "22/4/2013", 11.5, 10.293, 100, 2) End Sub Please check may be you the way you passing the parameter in it is wrong. Regards

$$Excel-Macros$$ BOND Macro

Hi, I have the following macro which i am trying to get the price of a bond but ends up giving me zero value. What could be the prblem? Function PRICE364(settlement As Date, maturity As Date, rate As Double, yld As Double, redemption, frequency) 'Initialize Variables Dim COUPNCD As Date Dim COUP

$$Excel-Macros$$ VBA code for convert xls,xlsx into .CSV file

Hi Excel Experts, i am looking VBA code for convering xls,xlsx file into .csv file. can anybody support to get resource code in websites? -- Thanks & regards Satheeshkumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accu