$$Excel-Macros$$ Re: Copy PDF data to Excel macro require

can you share PDF file, if it is text only then same can be imported.. On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote: > > Hi everyone, > > Need your help for this easy. I have a folder with multi PDF files. I need > a macro to copy all pdf data in a workbook. > > Note: One

$$Excel-Macros$$ Re: Minimum difference needed

Ok, i got that now.. So you are finding min diff between Invoices & multiple payment received & allocating in a way which yields you min difference.!! will change the code to suits your need. Cheers!! On Thursday, June 5, 2014 4:30:50 PM UTC+5:30, Sleek wrote: > > You can use the data once &

$$Excel-Macros$$ Re: Getting error to select the maxdate

Hey Can you share sample file with dummy data. This will help in understanding better.. Thanks On Saturday, July 27, 2013 9:59:18 PM UTC+5:30, Sanjay Kumar Maurya wrote: > > Hi All > > I'm getting error to select the maxdate. > > > Sub Pivot_table() > > ActiveWorkbook.Sheets("Incidents Resolve

Re: $$Excel-Macros$$ group dates into months

Hi Pl refer. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/ Thanks On Friday, July 5, 2013 6:03:30 PM UTC+5:30, Krishnaraddi V. Madolli wrote: > > Does anyone know how to group dates into months in a Pivot table in > Excel *2003*? > > > > Regards, > > Krishnaraddi V Madolli. >

$$Excel-Macros$$ Re: SAVE As file name

Hi You can try this code: Sub SaveFileAs() Dim FName As String Dim FPath As String FPath = ThisWorkbook.Path '"C:" FName = ABC(Range("A2").Value, Range("B2").Value, Range("C2").Value) 'FName = Sheets("Sheet1").Range("A1").Text ThisWorkbook.S

Re: $$Excel-Macros$$ Protect & unprotect query

hey you missing additional control.. Your cells are not locked, lock & then protect.. Cheers//Vabs On Sun, Jun 30, 2013 at 3:44 PM, Pravin Gunjal wrote: > Hi Experts, > > I have assigned the macro to attached file for protect and unprotect the > sheet manually. But it is not working properl

Re: $$Excel-Macros$$ Still image even we scroll

Hi It is not possible, by default Graph or Image is fixed to a place. Check whether your range is freezed. Un freeze pane by Pressing ALT + W + F If problem persist share your sheet. Thanks On Sat, Jun 29, 2013 at 12:33 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Team,

Re: $$Excel-Macros$$ To count values in a changeble range

d as you > say and didnt work. So i tried to change With > ThisWorkbook.Worksheets("sheet1") >for With ThisWokbook.ActiveSheet or With ActiveWorkbook.ActiveSheet, > neither of them worked. I dont want to run it on a module where I have to > initialize the macro every time

Re: $$Excel-Macros$$ To count values in a changeble range

ank cells, for now > everything is perfect. Thank ou so much for your help. Soon I'll need more > help on a similar subject, I hope you can Help. Now I'll try to fit in my > real sheets. Have a nice weakend > > > > 2013/6/28 VBA VABZ > >> Hi >> >

Re: $$Excel-Macros$$ Plz help me to solve this prob

Hi Either your table is corrupted, re-created new excel file using pasting values. Best Luck. On Thu, Jun 27, 2013 at 11:45 AM, thameem wrote: > Still getting hanged, even it was converted in to binary file, i tried to > delete empty rows, but not working > > > On Thu, Jun 27, 2013 at 9:55 AM

Re: $$Excel-Macros$$ get data range used by chart in excel using vba

box, i want that range programmatically. > > Divaker > > > On Tue, Jun 25, 2013 at 6:19 PM, Divaker Pandey wrote: > >> thanks for your quick response. >> >> but i couldn't get, please vabz tell me exact way, how can i get data >> range used by chart. >

Re: $$Excel-Macros$$ get data range used by chart in excel using vba

HI Pl refer: http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx Using the ChartArea Object Use the *ChartArea* property to return the *ChartArea* object. The following example sets the pattern for the chart area in embedded chart one on the worksheet named "Sheet1." Wo

Re: $$Excel-Macros$$ Dates based on working hours

Pl consider this. On Tue, Jun 25, 2013 at 1:13 PM, VBA VABZ wrote: > See this sheet as per your requirements. > > Pl let us know if any error. > > HTH//Vabs > > > On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote: > >> Hi >> >> Refer hope this will

Re: $$Excel-Macros$$ Dates based on working hours

See this sheet as per your requirements. Pl let us know if any error. HTH//Vabs On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote: > Hi > > Refer hope this will help. > > http://chandoo.org/wp/2010/09/10/working-hours-formula/ > > > Thanks > > > On Mon, Jun 24

Re: $$Excel-Macros$$ Help in linking data based on PO criteria

Hi PFA file that take care of coping data. HTH//Vabs On Mon, Jun 24, 2013 at 7:41 PM, wrote: > Hi All! > > My name is Ryan. I am pretty experienced in Excel but have run into a > dead in with my recent project. I currently manage all PO's for my company > to perform financial formulas, analy

Re: $$Excel-Macros$$ Dates based on working hours

handra > > On Mon, Jun 24, 2013 at 7:10 PM, VBA VABZ wrote: > >> HI >> >> Can you give more clarity. What date1 & date2 means here. >> >> Thanks >> >> >> On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar < >> chandrashekarb@gmai

Re: $$Excel-Macros$$ Dates based on working hours

HI Can you give more clarity. What date1 & date2 means here. Thanks On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I need a formula which calculate dates based on working hours please find > attached file. > > Regards, > > Chandra > > > > -- >

Re: $$Excel-Macros$$ Date format to be changed

n : > > Use the below > =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")​ > > > On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal wrote: > >> Dear Vaibhav >> >> It's not working,. please check the attachment. >> Thanks, >&g

Re: $$Excel-Macros$$ Web links in word - reg.

re might be somewhere setting is changed. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: VBA VABZ > Date: Sat, Jun 22, 2013 at 5:06 PM > Subject: Re: $$Excel-Macros$$ Web links in word - reg. > To: "excel-macros@googlegroups.com"

Re: $$Excel-Macros$$ Web links in word - reg.

HI Open new word doc & try pasting there. If it works there then there is issue in existing doc so you need to re-create existing doc. HTH//Vabs On Sat, Jun 22, 2013 at 4:50 PM, Prabhu Pinky wrote: > hi pravin, > > am also using the same version of MS Word. But its working fine even if i > pr

Re: $$Excel-Macros$$ Start and Stop Time - Macro

Hi For end time you can add one line ti check existing time with end time, if existing time is > end time then quit sub. HTH//Vabs On Sat, Jun 22, 2013 at 10:57 AM, Bill Q wrote: > Sounds good Vabz Half way there. What about the end time ? Where would > that go ? > On Fri

Re: $$Excel-Macros$$ Date format to be changed

Select cell, right click, format cell, custom & type DD--. You can use text(cell,"DD-MMM-") also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote: > I have date in this format : *DD.MM.* (with dot) and require it as : * > DD-MMM-* (with hyphen). > For example :

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

try edate formula.. Thanks On Sat, Jun 22, 2013 at 1:13 AM, Hilary Lomotey wrote: > Hello Experts, > > In the attached sheet, i have a list of dates in col A and index number in > Col B. What i am trying to achieve is that in Sheet two, i have written a > formula to give me index number as at

Re: $$Excel-Macros$$ Start and Stop Time - Macro

Hi To run this macro, just make sure that you replace *Name_of_Macro* with the name of the macro inside of your Excel workbook that you want to run. Also, replace *09:30:00* with the time that you want your macro to run. Private Sub Workbook_Open() 'Runs a macro at 9:30 AM Application.OnTime Time

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks _ > :=False, Transpose:=True > coordS = coordS + 5 > coordF = coordF + 5 > target = target + 1 > > Next > > End Sub > > kind regards, >

Re: $$Excel-Macros$$ Need code for extracting report from CMS Avaya

hey FYI http://fracta.net/fracta/index.php/forum/2-excel-vba-forum/15-excel-vba-macro-to-automate-avaya-cms-supervisor-reports Thanks On Fri, Jun 21, 2013 at 4:13 PM, Arundatti M wrote: > Hi Team, > > I need help in extracting report from CMS Avaya CRM application to excel. > If there is any

Re: $$Excel-Macros$$ Add me

Welcome on the Borad!! On Thu, Jun 20, 2013 at 4:16 PM, Muralidharan Thangavelu < muralika...@gmail.com> wrote: > -- > Regards, > > T.Muralidharan, > Asst Manager (Electrical), > L&T ECC Division, > Krishnagiri Walajabad Road Project, > Bargur, > Krishnagiri Dist, > Tamilnadu. > Phone-9489202217

Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

Hi PFA, there are other solution for this. HTH On Thu, Jun 20, 2013 at 11:53 AM, Ali wrote: > Hi all, > > I have a worksheet that need to allocate the number of nights spent by a > guest in the relevant Columns designed for the purpose. I can't seem to > find the right formula to do this. > >

Re: $$Excel-Macros$$ Need a Fastest way

Hi Highlighted means cells filled with specific color or selected cells. Thanks On Wed, Jun 19, 2013 at 5:58 PM, rajan verma wrote: > > can anyone suggest a faster way to know which cells are highlighted in a > Range ? > > suppose i have data of 1 lac cell and i have some cells highlighted ,

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

Hi, Use this code.. Sub Select_Row() Range(ActiveCell.Rows, ActiveCell.Offset(4, 0)).EntireRow.Select End Sub This will select 5 rows from active cell. Thanks On Wed, Jun 19, 2013 at 12:48 PM, Seba wrote: > Hi, > > can someone please advise how to parse a column in excel, so that every 5 >

Re: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page

Hi Sub MyFooter() Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range Set Sh = Worksheets("Sheet1") Set Rng = Sh.Range("A51:G51") For Each c In Rng StrFtr = StrFtr & c & " " Next c ActiveSheet.PageSetup.LeftFooter = StrFtr End Sub HTH On Mon, Jun 17, 2013 at 4:26 PM, Ira wrote:

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

> Dim rng As Range > Set rng = Range("E" & Cells(Rows.Count, "E").End(xlUp).Offset(1, 0).Row) > cancel = True > With Selection > Selection.Copy Destination:=rng > End With > End Sub > > Regards, > Sam Mathai Chacko > > > On Sun, Jun 16, 2013

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

Hi priti This will keep on overriding existing data one on anothet on click. We have to change taeget once data is copied in to. Feedback appreciated. Thanks On 16 Jun 2013 16:56, "priti verma" wrote: > Hi sajid you can also try this > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

Hi Try this code: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _ cancel As Boolean) Dim rng As Range Set rng = Range("E" & Cells(Rows.Count, "E").End(xlUp).Offset(1, 0).Row) cancel = True With Selection Selection.Copy Destination:=rng End With End Sub Here rng specifies destina

$$Excel-Macros$$ Re: Help in copy data

Sub Here rng specifies destination rage which you can alter. Since there is no single left click event procedure, you have to Right Click to activate macro. Paste Macro in sheet module to work. HTH//Vabz On Thursday, June 13, 2013 1:15:47 PM UTC+5:30, SAJID MEMON wrote: > > I have a list of som

Re: $$Excel-Macros$$ use of excel sheet to limited time frame say month, day, time or limited number of days

Hi, You may refer: http://www.vbaexpress.com/kb/getarticle.php?kb_id=475 http://www.vbaexpress.com/kb/getarticle.php?kb_id=540 File with example is there for better understanding.. Best Luck On Sun, Jun 16, 2013 at 12:03 AM, sunil lobo wrote: > hi all > can anybody suggest a vb code or a m

Re: $$Excel-Macros$$ List File Names from Folder in Excel

PFA http://www.xl-central.com/list-files-dir.html http://www.excelvbamacros.com/p/index_1.html Thanks On Sat, Jun 15, 2013 at 5:39 PM, Vijayendra Rao wrote: > Dear All, > > Is there any macros to create list names with subfolder and propertis from > any folder. Currently I am using ASAP-Utili

Re: $$Excel-Macros$$ split function in vba

in vba function split function is working is magic of instr: Instr checks each word in sentence, if it contains @ then it is picked up & thrown as result.. its using right logic with right function to reach destination in fastest way.. HTH On Sat, Jun 15, 2013 at 3:21 PM, ravinder negi wrote:

Re: $$Excel-Macros$$ Date conversion to other format

refer.. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote: > Hi, > > I want to convert the date =Today() to this format : DD.MM. > > Formula =Today() 6/14/2013 In next cell, it should display as : > 14.06.2013 > Sample file is attached. Thanks. > > Regards > Pravin Gunnjal > > -- >

Re: $$Excel-Macros$$ Grouping Similar Cells in Excel

Hi JK, Desired result can be achieved using PVT table, you need to add one column & mention string in to the same. Now make pvt & refresh the same once data is added. Pl refer att. HTH/Thanks On Thu, Jun 13, 2013 at 2:53 AM, jk9045 wrote: > Hello everyone, > > I have an excel sheet that has

Re: $$Excel-Macros$$ Excel Training Material (PPT)

Hi Try this, hope it will help: https://docs.google.com/open?id=0B7i2wkMBVw9xQV9tb3hhZVdXWFE Thanks On Wed, Jun 12, 2013 at 9:25 AM, Prabhakar S H wrote: > Dear Team, > > MY HR given me responsibility to give training on Excel to my Marketing > team. So can you send me the materilals on Basic

Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet

This can be done using Mail Merge in word only. Refer link here: http://www.timeatlas.com/5_minute_tips/chunkers/mail_merge_tutorial_using_microsoft_word_and_excel#.Ubcqfvn7AqI Thanks On Tue, Jun 11, 2013 at 7:15 PM, VBA VABZ wrote: > Hi, > > Why you need output in word? > >

Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet

Hi, Why you need output in word? On Tue, Jun 11, 2013 at 7:09 PM, Atul Kesaria wrote: > Hello Expert, > > I need a help in creating a macro which will pick data from excel sheet to > mail merge to a predefined Word template.Attached is a sample word & Excel > Format. > > Request your expert op

Re: $$Excel-Macros$$ Access 2007 Tutorials

thanks for sharing!! On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR wrote: > Respected Mr Excel, > > You can check the following links. > http://allenbrowne.com/tips.html > http://www.baycongroup.com/access2007/ > http://www.gcflearnfree.org/access2007 > http://ms-access-tips.blogspot.in/p/advan

$$Excel-Macros$$ Re: Need help on worksheet protect and unprotect code

If you want to use VBA on a shared workbook I would recommend moveing the code to an XLA On Friday, June 7, 2013 10:45:10 PM UTC+5:30, maksood alam wrote: > > Hi Guys, > > I have workbook with codeing below > > Private Sub Worksheet_Change(ByVal Target As Range) > > *Sheets("MMPs").Unprotect

$$Excel-Macros$$ Re: Need help on worksheet protect and unprotect code

Hi, The following features can't be changed after a workbook is shared: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and

Re: $$Excel-Macros$$ Re: Please help Excel Gurus

> > *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere > 3 sheets of A4 paper pollutes 1 litre of water* > > > > > On Tue, Jun 4, 2013 at 10:43 AM, Vabz > wrote: > >> Hi >> >> Chek this file. >> >> I have changed dates in he

Re: $$Excel-Macros$$ Marge Data from Different workssheet.

Hi PFA Macro which i have made for users. You can change as per your need. HTH//Vabs On Tuesday, June 4, 2013 9:23:42 AM UTC+5:30, Tariq Aziz wrote: > > Dear Vijy Kumar > > > i already try this add-in but it is not working. > > > Tariq > > > On 3 June 2013 23:48, P.VIJAYKUMAR >wrote: > >> Respe

Re: $$Excel-Macros$$ Want to add every third row or coloumn!

Hi Send sample file for more clarity Thanks On Tue, Jun 4, 2013 at 9:51 AM, wrote: > Dear expert, > Many time I have to add every third or every forth or every second row or > column etc...can you suggest a function which will ease my problem! Till > now I am adding required cell one by one

$$Excel-Macros$$ Re: Please help Excel Gurus

Hi Chek this file. I have changed dates in header to respective month ends since deductions are made at the end of the month. HTH//Vabs On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, Harish P Y wrote: > > Hi Every One, > Please find the attached file, > Kindly help me with the required formula

Re: $$Excel-Macros$$ use full link to learn Excel

Thanks!! On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote: > Dear Frndz, > > > Use full link to learn Excel. please find attached link!!! > > > > > http://www.excel-pratique.com/en/index.php > > Thanks > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

Re: $$Excel-Macros$$ Macro Help

Shire Council in Thargomindah Queensland Australia. >> >> Regards >> David Grugeon >> >> >> >> On 27 May 2013 16:13, VBA VABZ wrote: >> >>> hey >>> >>> for which co you work. >>> >>> thx >&g

Re: $$Excel-Macros$$ Urgent help plss..

Hi Either source sheet has filter or merged cells. Try clearing out filter and perform operation again. If doesn't work send us sheet. HTH On 28 May 2013 10:07, "Prabhu Pinky" wrote: > hi experts > > I have one excel, from that excel I am unable to copy and paste the data > to new excel..even

Re: $$Excel-Macros$$ Macro Help

hey for which co you work. thx On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote: > Hello, > > ** ** > > Please find attached the sheet. > > ** ** > > Macro Requirement : I will receive the data for 20 associates in my team > in a separate sheets (20 Sheets) in the attached format. Now

$$Excel-Macros$$ Re: Need a code for multiple If condition and delete cells in excel

Pl attach file here itself in forum to save on time. I tried best on my side on the basis of your explanation.. Pl share your query to work on Thanks On Monday, May 27, 2013 12:14:56 AM UTC+5:30, Sivaprakash A wrote: > > I have worked this below macro and was succesful in one out come but the

Re: $$Excel-Macros$$ Sortring out worksheets in ascedning order

PFA Cheerz!! On Saturday, May 25, 2013 9:52:51 AM UTC+5:30, ITP Abdulgani wrote: > > Gr8, can please tell me, if I want to ignore first two sheet while sorting > ascending or descending. How to do it ? > > > On Fri, May 24, 2013 at 4:50 PM, Abhishek Jain > > > wrote: > >> Check this. >> >> >>

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

See my formula in attachment, im talking abt it. Re-attached Thanks On Saturday, May 25, 2013 3:52:26 PM UTC+5:30, Amit Desai (MERU) wrote: > > No its not that easy. > > > > *From:* Vabz [mailto:v...@vabs.in ] > *Sent:* 25 May 2013 15:51 > *To:* excel-...@google

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

PFA Just Drag & Drop first formula!! Cheers!! On Saturday, May 25, 2013 3:24:08 PM UTC+5:30, Amit Desai (MERU) wrote: > > Can someone please look at my query & help me? > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Amit Desai (MERU) > *Se

$$Excel-Macros$$ attach digital signature to documentse

Hi, Is it possible to attache Digital Signature to PDF or Any Other documents using excel VBA. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ convert date value into month number of format eg 03 for March

hi if data is in date format then, use =text(cellref,"mm") Thanks On Fri, Apr 19, 2013 at 6:14 PM, colmkav wrote: > Hi, > > what excel formula do I need to convert a date field into the month number > like 03 for March? > > for example cell A3= #31/03/2013# > > I want "03" in my new cell. > >

Re: $$Excel-Macros$$ print current file to pdf

Hi Dont add dim. I forgot to mentio you need to add this extension on your PC so as to allow file to save as PDF. Press F12 on excel sheet & check if you have save as pdf option there, if its not there then add following extension: http://www.microsoft.com/en-in/download/details.aspx?id=9943

Re: $$Excel-Macros$$ Same macro for multiple sheets

hi Since you restricting to specific sheet it doesnt work.. Try dis: Public g_blnUpdate As Boolean Public Sub Protect_Unprotect() 'With ThisWorkbook.Worksheets("Sheet1") targetws = ActiveSheet.Name With ThisWorkbook.Worksheets(targetws) If g_blnUpdate = True Then g_blnUpda

Re: $$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs

hi can u send me sample data... Rgds On Tue, Nov 6, 2012 at 10:24 PM, veerendra vanam wrote: > > > On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam > wrote: > >> >> Dear all, >> >> i am sending mail particular updated file summary sheet as >> body, every 1hr like 01:00hr,02:00hr,03:00hr,

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: > > Hi Vabz, > > Nope, not giving the desired result... (attached the sample required > file for more info) > > > A) THIS PIVOT WILL GET AUTO REFRESHED (BASE

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi I have just tested & it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: > > Hi > > Ignore earlier & consider this > > Sub email() > Dim myOutlook As Object > Dim myMailItem As Object > Dim F

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

TimeValue("00:10:00"), "email" Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: > > Hi > > Try this: > > Sub email() > D

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail > to be sent and @ 9:20 AM again No E-mail as no change in the Value > (also e-mail has already been sent @ 9.10 AM !!) > > Thank you. > > JP > > On Tue, Nov 6, 2012 at 4:13 PM, Vabz > wro

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject("Outlook.Application") Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME With otlNewMail .To = "v...@vabs.in" .CC

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

aly wonderful, it help me to make report so easy.. >> >> >> On Fri, Oct 26, 2012 at 2:16 PM, Vabz > wrote: >> >>> PFA >>> >>> Cheers//Vabs >>> >>> >>> On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wr

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

Hi LINK Pl check, its working fine.. Rgds//Vabs On Friday, October 26, 2012 2:11:39 PM UTC+5:30, Rahul Sharma wrote: > > link is not working. > > On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: >> >> Hi All, >> >> Firstly let m

$$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA Cheers//Vabs On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

$$Excel-Macros$$ Re: Help: increase the sheet number in a formula

Hi PFA Cheerz//Vabs On Thursday, October 25, 2012 2:45:04 PM UTC+5:30, Sundarvelan wrote: > > Dear Gurus, > > Please help me to increase the sheet number > > =IF(IF(ISNUMBER(SEARCH($C$2,*Sheet1*!$B$1)),"TRUE",0)="TRUE",TRIM(RIGHT(* > Sheet1*!$B$1,LEN(*Sheet1*!$B$1)-FIND(":",SUBSTITUTE(*Sheet

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

HI Pl refer this link for more idea, if you are not able to understand pl revert: http://www.contextures.com/xlDataVal02.html Rgds//Vabs On Friday, October 26, 2012 1:42:45 PM UTC+5:30, Rahul Sharma wrote: > > you have add vlookup function, but i dont want the same. let me explain > what i nee

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

Hi PFA, In your case this can be done with simple Vlookup. for more info on dynamic dependent list refer link: http://www.contextures.com/xlDataVal02.html RGds//Vabs On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: > > Hi All, > > Firstly let me thanks to the admin and all

$$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA Suggets if any changes. Rgds//Vabs On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussex

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

Hi Nice work, you can automate it through conditional formating. Rgds//Vabs On Wed, Oct 24, 2012 at 12:49 PM, Yahya Muhammad wrote: > Hi experts > > I want to compile the annual leave schedule of each staff in the > department in excel. The idea is to have all the schedule in one work > sheet,

Re: $$Excel-Macros$$ Query for applying the formula

Hi It could not be so. Check whether you have provided correct sheet name in your project sheet also.. Rgds//Vabs On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala wrote: > Hi all, > Pls help me solve my query. > I have written my query in the attachment . > > Thanks & Regards. > > -- > Join offici

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

ello, >> >> The configuration is oke , video card should be separated not integrated >> >> and as for company that you should choose , i rather opt for Asus >> ,Toshiba. >> >> >> >> >> On Saturday, October 20, 2012 3:03:22 PM UTC+3, V

Re: $$Excel-Macros$$ countif in hidden rows

Hi PFA Rgds//Vabs On Monday, October 22, 2012 8:14:41 PM UTC+5:30, danial mansoor wrote: > > u did not get it,sir in subtotal we don't have option of Counting things > with conditions as we do with countif,so i want a way to count with > condition with hidden rows. > > to make it more elabora

Re: $$Excel-Macros$$

Hi Also dont forget to put a the end.. application.displayalerts = true Application.screenupdating= true Else user will wonder whats going wrong.. Rgds//Vabs On Friday, October 19, 2012 5:25:18 PM UTC+5:30, shrini wrote: > > Dear Both, > > Very very thanks for solution. > > Regards > Shri

$$Excel-Macros$$ No Questions??

Hi, No questions on this forum.. Can some body share some good stuffs.. Rgds//Vabs -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ Re: Please help me.. on sumproduct

Hi You can do that with simple Vlookup function. Rgds On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote: > > Hi, > > I want to know if coll "A" Data found in Coll "C", it found the value of > Coll "A". using sumproduct.. > &

Re: $$Excel-Macros$$ Re: Please help me.. on sumproduct

if coll "A" Data found in Coll "C", it found the value of > Coll "A". using sumproduct.. > > > On Thu, Oct 18, 2012 at 3:08 PM, Vabz > wrote: > >> Hi >> >> What exactly you are trying to do. >> >> Rgds//Vabs >> >>

$$Excel-Macros$$ Re: Please help me.. on sumproduct

Hi What exactly you are trying to do. Rgds//Vabs On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert, > > please help tell me i am doing something wrong in this formula.. > A B c Store ID Store ID V5/A & G-199 #VALUE! V5/A & G-016 V5/A & > G-016 #VALUE!

$$Excel-Macros$$ Re: Need formula to update status

Hi PFA.. Cheers.. Rgds//Vabs On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote: > > > -- Forwarded message -- > From: Manoj Kumar > > Date: Thu, Oct 18, 2012 at 12:29 PM > Subject: Need formula to update status > To: excelvb...@googlegroups.com > > > Dear Exp

$$Excel-Macros$$ Re: Hard to find Status for me...

hi what is logic, i am not able to get it. Please explain. Rgds//Vabs On Thursday, October 18, 2012 11:18:23 AM UTC+5:30, Manoj Kumar wrote: > > > Dear Expert. > > Please help me.. > File attached below.. > > Regard > Manoj > > > -- Join official facebook page of this forum @ https://www

Re: $$Excel-Macros$$ For Indian Accountants & Taxation professional. Check ISPANVALID

, Sam Mathai Chacko > > > wrote: > >> Similar Thread here too >> >> >> On Wed, Oct 17, 2012 at 7:24 PM, Vabz > wrote: >> >>> Hi >>> I have created a function to find our invali PAN. >>> >>> This Function Highlights in

$$Excel-Macros$$ Re: Suproduct not equal range

Hi Can you please share sheet with results required by you. Prima facie you are getting array because you are comparing range of not same size. Rgds//Vabs On Monday, October 15, 2012 10:51:12 AM UTC+5:30, Chandru wrote: > hi Group Member > > i have small doubt how to use Sumproduct

$$Excel-Macros$$ Re: Excel VBA Code for Zip Password

Hi Check following link: Link Rgds//Vabs On Monday, October 8, 2012 11:48:57 AM UTC+5:30, Dhartikumar Sahu wrote: > Hi Experts > > Kindly provide me a code for Zip file with password Protection. > > Q. How to Zip the folders with password in exc

$$Excel-Macros$$ Re: Need Help in allocation table

Hi Can you explain base for allocation, theer is no standard method that can be assumed on the basisi if data given by you. Rgds//Vabs On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote: > > Need help > > > Dear All, > I need your help in automatic some calculations in s

$$Excel-Macros$$ Re: Help to get the Formula

Rajan & Ashish.. Its really good formula.. Thanks .. Rgds//Vabs On Tuesday, October 2, 2012 12:19:37 AM UTC+5:30, ankur wrote: > > Hi All, > > I seek some help in to get the desired result via formula. > > My requirement is - I need result in column G in the yellow > highlighted cell as Yes

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hey hii.. My self Vaibhav Joshi and online people call me vabz/vabs.. I am extremely lover of system & automation.. MS Excel is one of my area of meditation & love to help people because i love to feel that smile & relief on the face when problem is solved... It gives me smile on my

Re: $$Excel-Macros$$ Re: Benford's Laws in excel

> how to use it. > Regards > David Grugeon > > > On 30 September 2012 23:40, Vabz > wrote: > > Hi > > > > Follow this link.. > > > > Cheers.. > > > > Regards//Vabs > > > > > > On Sunday, September 30, 2012 8:52:

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

Hi Is this of any use? Rgds//Vabs On Friday, September 28, 2012 11:05:30 AM UTC+5:30, Vabz wrote: > > Hi Bhasker & Reshma > > PFA excel file with macro.. > > This macro extracts wav file properties, you can keep the data you want & > discard unwanted.. > &g

$$Excel-Macros$$ Re: Query

Hi You getting error because you are multiplying array with not value of Cell C2 but just text C2. Rgds//Vabs On Friday, September 28, 2012 5:54:58 PM UTC+5:30, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, it has no > problem, > > =S

$$Excel-Macros$$ Re: Benford's Laws in excel

Hi Follow this link.. Cheers.. Regards//Vabs On Sunday, September 30, 2012 8:52:26 AM UTC+5:30, sandeep chhajer wrote: > > Good morning to all, > > Do any one have macros or aad-in on Benford's law. > > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone -- Join official facebook pa

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

Hi Bhasker & Reshma PFA excel file with macro.. This macro extracts wav file properties, you can keep the data you want & discard unwanted.. Cheers.. Rgds//Vabs On Thursday, September 27, 2012 10:47:25 AM UTC+5:30, reshma shri wrote: > > Hi Bhasker > > I too am a medical transcriptionist

$$Excel-Macros$$ Re: Basic Macro

Hi, You can learn online from may websites: *http://home.pacbell.net/beban* *http://excel.tips.net* *http://www.andrewsexceltips.net/* *http://www.andypope.info/* *http://akoul.blogspot.com* *http://www.ashishmathur.com* *http://www.discussexcel.com* *http://members.aol.com/Machero* *http

$$Excel-Macros$$ Re: Help for VBA code (Excel Table copy to word)

Hi Please refer link : Rgds//Vabs On Thursday, September 27, 2012 11:09:18 AM UTC+5:30, amar takale wrote: > > Hi All Experts > I need VBA code for Excel table paste in word on one click.If I Select > Table or range for one or more table

Re: $$Excel-Macros$$ Hiiiiiiiiiii

hi Really nice.. Rgds On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) wrote: > To all my dear friends, > > ** ** > > Nice Excel filewith ABCD on Friendship... > > Please see the attachment and click on flowers. > > Best Regards, > > Amit > > ---

  1   2   >