$$Excel-Macros$$ macros help needed

Following is an excel sheet which contains data abt shares I want to follow. I want to get an email to my id once the actual market price reaches a value in the range of Expected mkt price. Is this possible? Thanks & Regards, | Shreyas Shringarpure | Team Lead (BA)- DTM | Target Corporation Indi

$$Excel-Macros$$ Auto Send Email With Attached Word Doc Created From Merge

I have an excel file. This file has 4 columns - sign, first name, last name and Email. My goal is to create a button on each line (or link) that will automatically create an email using the email address in that record. Not only will it say Dear first name and last name, but it will also have a w

$$Excel-Macros$$ Re: Simple Copy/Paste Macro won't work.

Thanks Paul! That's very helpful! On Dec 8, 1:52 pm, Paul Schreiner <[EMAIL PROTECTED]> wrote: > The problem is that unless told otherwise, the macros "assume" the > workbook you refer to is the one the macros RESIDE in. > Basically, it uses two objects: > ThisWorkBo

$$Excel-Macros$$ Pop-up on saving the shared excel

Hi everyone, I have an excel which is shared between 5-6 users and everybody updates and saves it. I want know is there any macro by which i'll get a pop-up message stating one of user has updated and saved the excel? Thank you in advance, -- Luv Hems ! ! ! " I don't have the LICENSE to kill ;

$$Excel-Macros$$ Re: formula help

Dear watmatt Here is the formulae you required: =IF(A1<50,B2*(1.5),IF((A1>50)*AND(A1<100),B2*(1.4),IF((A1>500),B2*(0.97),IF((A1>1000),B2*(0.95),0 But if you put this formula in B2 cell. It will create circular reference. You can look into the given attachment. Cheers.. Govind On Sun, Dec 7,

$$Excel-Macros$$ Re: run time type mismatch/other improvements

VBA has a function called DateDiff: DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) The DateDiff function syntax has these named arguments: Part Description interval Required. String expression that is the interval of time you use to calculate the difference between date1 a

$$Excel-Macros$$ Re: Simple Copy/Paste Macro won't work.

The problem is that unless told otherwise, the macros "assume" the workbook you refer to is the one the macros RESIDE in. Basically, it uses two objects: ThisWorkBook and ActiveWorkBook ThisWorkBook is the workbook that has the macros. ActiveWorkBook is the workbook currently selected. Another ob

$$Excel-Macros$$ Re: excel ebookss

Thank you very much Aju v chacko On Sun, Nov 30, 2008 at 2:30 PM, Sunil Thacker <[EMAIL PROTECTED]>wrote: > > hi all please find this excel e-boooks..!! Please just say thanks if u > find it useful..! he he > > > cheer guys and gals...keep exceling :) > > >

$$Excel-Macros$$ Simple Copy/Paste Macro won't work.

Hello. "Macros.xls" is where I store all of my macros. I get another file daily which contains the data that I would like to run the macos on. I have written a simple macro that copies data from my daily file and pastes into the same file in the same sheet. The problem I am having is that when

$$Excel-Macros$$ Re: run time type mismatch/other improvements

Thanks for the tips. When I checked the code, I found I had reversed the row and column in the Cell(). There were also a few other issues. I like the Date - Date but that would not teach me anything about programming. I still need to cehck the if then sequence but it does run with some of the test

$$Excel-Macros$$ Re: excel ebookss

there is no attachment.. On Mon, Dec 1, 2008 at 1:32 PM, vijender kumar <[EMAIL PROTECTED]>wrote: > Hi A very big Thanks... I hope macro part would be > very useful.. > > On 11/30/08, Sunil Thacker <[EMAIL PROTECTED]> wrote: >> >> >> hi all please find this excel e-boooks.