Re: $$Excel-Macros$$ Urgent Help

2010-05-02 Thread Harpreet Singh Gujral
Hi Ashish/Jai/Group, I am also looking for some kind of Folder protection program.. Please advise Cheers! Harry On May 2, 12:15 pm, ashish koul wrote: > try this it may help you > > 1. Go to the directory where your folder is in. > 2. Create a new notepad file and paste this without t

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

2010-05-02 Thread Harpreet Singh Gujral
Sidhantha, I can give it a try, as i am also studying some things related to Stock Market... Let me know Harry On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know it

$$Excel-Macros$$ Please help me

2010-05-02 Thread sidhantha suchit
hi sir I m new to this group right now i m doing a project on stock market and i have to do lot of calculation ,I know its my duty but can if any one help me its reduce my task because i have to apply in 1000 BSE listed company . what i have to calculate Volatility (daily) Jump in script Mean R

$$Excel-Macros$$ How to compare two Excel sheets

2010-05-02 Thread sudhir kumar
Dear friend, first of all thanks u very much for ur mind blowing programing, just tell me one thing if i want to apply same concept with my some other file having different format, than what should i do, i means different heading, and position of text. thanks -- Regards- Sudhir Kumar Design Engine

RE: $$Excel-Macros$$ Kndly Solve my Problem

2010-05-02 Thread Dave Bonallack
You're welcome. > Date: Sun, 2 May 2010 03:18:27 -0700 > Subject: Re: $$Excel-Macros$$ Kndly Solve my Problem > From: asheeshinsura...@gmail.com > To: excel-macros@googlegroups.com > > Thanks Dave, > > Asheesh Arora > > -- >

Re: $$Excel-Macros$$ How to compare two Excel sheets

2010-05-02 Thread sudhir kumar
dear harpreet, i m not having a great knowledge of vba, so can u help me hw can i use the code send by u, i already pasted that code into a module, but hw i run that code. thanks On Sat, May 1, 2010 at 5:33 PM, sudhir kumar wrote: > Thanxs dear., > i 'll try this , if i will tell u if i get nay

Re: $$Excel-Macros$$ Kndly Solve my Problem

2010-05-02 Thread ASHEESH
Thanks Dave, Asheesh Arora -- -- 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.linkedin.com/groups

Re: $$Excel-Macros$$ Urgent Help

2010-05-02 Thread ashish koul
try this it may help you 1. Go to the directory where your folder is in. 2. Create a new notepad file and paste this without the double quotes: "ren Users.{21EC2020-3AEA-1069-A2DD-08002B30309D} Users" (Make sure to replace the word “Users” with the name of your folder.) 5. In Notepad, go to Fil

Re: $$Excel-Macros$$ Kndly Solve my Problem

2010-05-02 Thread Ahmedhonest
Dear Asheesh Arora, Please find attach the solved as per your criteria, hope this is what you are looking for. Regards Ahmed Bawazir On Sun, May 2, 2010 at 6:17 AM, Asheesh Arora wrote: > Dear All, > > Please help, > > In column A:A dates are there > In column B:B Condition are there > In colu

$$Excel-Macros$$ Do No copy excel file or data from that file

2010-05-02 Thread Harpreet Singh Gujral
Hi Vijay, I think the following code will help to some extent. Private Sub Workbook_Open() Application.DisplayAlerts = False If Range("A1").Value <> "C:\Desktop\[Book2.xls]Sheet1" Then 'In the inverted please insert the location to chck MsgBox "Workbook was moved from the Original Location. Hence