$$Excel-Macros$$ PDF password CRACKER

Hi There.. I have downloaded a pdf file which is PASSWORD PROTECTED. CAn anyone PLEASE help crack the password. IF YES, then pls tell me so that i can mail the pdf file to the concerned person. I would be very oblidged for the help. Thanks in advance Thanks and Regards, Vivek Agrawal Skype

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

hi Here is the attached file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 9:28 AM, vinod rao wrote: > Hello Team, > > Need ranking formula.See attached, kindly help.

$$Excel-Macros$$ Re: Compare 4 columns in excel spreadsheet

Hi Hope this solves your problem... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Sep 9, 2009 at 7:48 PM, fishbonez wrote: > > i would like to know how can i compare 2 (A & B)cols in sheet 1 to

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

oh k Thanks a lot Sathish once Again... This was again a great learning... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 10:53 AM, Sathish Jalendran wrote: > Hi, > > > > I just tried o

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Really?... thats great this means some temp files might be creating some problem... neways now m happy... thanks a lot... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 12:16 AM, Daniel

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 10:12 AM, Sathish Jalendran wrote: > Hi, > > > > Check this file have tried repairing it, it works for me here > > > > Regards > > Sathis

$$Excel-Macros$$ Re: Need help on formula

Hi As per what you want... my answers are in red with yellow background The best way for what you want is that sort the column and then apply the formula in red with yellow... Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy

$$Excel-Macros$$ Re: help with Vloopup function

, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh wrote: > Hi Everybody, > > Can you please help me with the below formula > > Thanks and Regards > > Sanjay Singh > > On Tue, Aug 2

$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest

\ kindly open the personal workbook and then run the macro hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 9:23 AM, Rehan Baig wrote: > Hi Everybody, > > I have created a macro in

$$Excel-Macros$$ Re: Combine multiple ranges using R1C1

Hi You can use the union function it takes as argument various ranges you want to combine... eg.. Dim MyRange as Range Set MyRange = union(Range("A1"),Range("A2"), ..) hope this helps Thanks and Regards, Vivek Agrawal Skype

$$Excel-Macros$$ Re: ROUNDUP

Simple and best =CEILING(9235200.23,50)/1000 hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk wrote: > > ROUNDUP(9235200,23*2;-6)/2000 > > > On

$$Excel-Macros$$ Re: Need help on formula

hi i got the solution with out extra column hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote: > This will help.Thank you > > can you put formula with

$$Excel-Macros$$ Re: Need help on formula

rows 1157, 1158, 1159 and 1160 also contain positive values. 0.34 so these would be considered 1 like wise 1162 to 1156 also contain 0.6 which are again positive hence count to ranks 5-10.. i hope you understand what i want to convey Thanks and Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Need help on formula

how come it becomes difficult to add a column and then hide that. this will not change the visual alsoas the column would be hidden i feel it would be difficult to get without using F... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving

$$Excel-Macros$$ Re: Need help on formula

Hope This Helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > Hello Vivek, > > I could not get the right answer. I need like > > Example > >

$$Excel-Macros$$ Re: Need help on formula

The third argument of the RANK function specifies the ranking order Blank or "0" means ascending order any other positive number or "1" means the other way round Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save E

$$Excel-Macros$$ Re: Need help on formula

Hi attached is the solution to your query Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > Hello Team, > > How do i rank only positive numbers. Plz h

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

Hi See the attached image which contains the instructions on how to change the tab order of objects on a user form. in the image "Info Survey" refers to your user form... Hope that will help Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

Hi Shell "F:\Running Apps\FTP Backup\backup.bat", 1 the above code might help but i would like to know why the code which you gave is not reliable. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24,

$$Excel-Macros$$ Re: Find the second highest no.

Hi Gaurav The LARGE function allows to find any level of value... from highest to lowest. 2 arguments required 1. the range of numbers 2. the level required for example, 1 for highest, 2 for second highest. and so on... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

ttp://www.excel-vba.com/vba-forms-3-6-text-boxes.htm> Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 10:04 PM, bharghav r wrote: > Hi All, > > > 1> Is there any option of switching between > tex

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

then do one thing just mail the moderator. he would certainly take care of that you can mail Ashish or Ayush Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:13 PM, Sandeep wrote: > *F

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

when did u send them... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:07 PM, Sandeep wrote: > They not come the the forum. I don't know what happent to them. > > Sandeep > > --

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

have your mails been blocked?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 4:56 PM, vivek agrawal wrote: > Hi Sandeep > > The mails to this group have to go through moderation. > O

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

none of the mails are blocked. they are just waiting for moderation its entire upto the moderator to approve the mails... but till date none of my mails have been blocked or any body others' too for that matter. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agra

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

Hi Sandeep The mails to this group have to go through moderation. Only when the moderator approves the mail, that it gets delivered to the group for members viewing. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24

$$Excel-Macros$$ Re: Frnds

Hi Some pdfs have been uploaded to the groups FILES section. kindly go through that and if u dont find any then feel free to write back. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 2:05 PM

$$Excel-Macros$$ Re: Help with formatting and subtotal

Hi Attached is the solution to problem.. you just need to hide to column C. Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 15, 2009 at 1:34 AM, Cesar Delanoval wrote: > > I have a simple ta

$$Excel-Macros$$ Re: insert = in every cell with nos & Blank

attached is the file... hope this is the solution required Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 8:44 PM, Manoj Kukrej wrote: > Hi > > want to insert "=" sign before each

$$Excel-Macros$$ Re: Logos Quiz !!

no info about how to fill those text boxes any idea?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:52 PM, Iqbal Shaikh wrote: > Friends > > Can u solve this

$$Excel-Macros$$ Re: Help Needed

the zip is password protected Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:42 PM, Iqbal Shaikh wrote: > Hi All > > > Can u help me for open the XL file which is in ZIP. > >

$$Excel-Macros$$ Re: Timevalue and Datevalue suddently doesn't work any more

thats great :0 but the excel file which you sent already contained those sells in the date and time format Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:16 PM, zheng yu wrote: > Hi Vi

$$Excel-Macros$$ Re: Number in Words

Hi Sachin You simply need to copy paste the code into your own workbook.. you can get access to the code by ALT + F11 Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 1:37 PM, sachin patil wrote: > Dear

$$Excel-Macros$$ Re: Code to hide workbook

One workaround can be setting "Application.screenupdating = false" just before you open it. and then set the same to TRUE when you want to make it visible. Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Ea

$$Excel-Macros$$ Re: help Needed!

query,m i doubt i am right. So please elaborate if this is not what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman wrote: > Hi All, > > Can anyone guide me how

$$Excel-Macros$$ Excel vba for outlook

a mail. I want to be able to change the from address. can anybody help me do so thanks Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

want on these please specify (what you want and what you dont want..) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 4:49 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: >

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

Hi Attached is the Text File Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh wrote: > Hi Vivek, > > > > > > Send me the macro as text file as my outlook had bloc

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

he all the headings. and the data should start from the second row onwards. rest - you can modify the code according to your needs. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 10:34 AM, Chidurala,

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

save these different sheets in the same location where the file containing this module is present. you can modify the code based on your needs. Feel free to mail me if more help required. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Urgent help requird

Hi Shivashankar cal u please clarufy in which structure or format do you require the result in Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 3, 2009 at 1:44 PM, shivashankar katageri < shankarkatag...@gmail.

$$Excel-Macros$$ Re: Code not runnig after the file is opened

, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 1, 2009 at 4:59 PM, vivek agrawal wrote: > > M sorry... The problem occurs in Line 4 not 3 (i.e. while opening the > file,.).. it was a typo > Well... It was understandable

$$Excel-Macros$$ Re: Code not runnig after the file is opened

M sorry... The problem occurs in Line 4 not 3 (i.e. while opening the file,.).. it was a typo Well... It was understandable but still no confusions... WAITING FOR REPLY Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat

$$Excel-Macros$$ Code not runnig after the file is opened

ep Into). then when the Line 3 is executed... it takes some time and then the next code automatically gets ready to get executed. HOPE I HAVE EXPLAINED MY PROBLEM WELL. Please help. Would be very grateful to you... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 Go

$$Excel-Macros$$ Re: Progress Reporter

Yes... PROGRESS BAR Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 30, 2009 at 3:26 PM, zheng yu wrote: > you mean progress bar? > > On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal > wrote: > >&

$$Excel-Macros$$ Progress Reporter

Hi ALL Can any body help me create a progress reporter or if someone has it or if someone has build on his and he is willing to share that... then PLEASE do... Your help would be greatly appreciated... thanks a lot.. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com

$$Excel-Macros$$ Re: Escaping a foir loop

thanks for all the replies... does Excel VBA have a substitute command for "Continue" .. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 29, 2009 at 4:43 PM, Daniel wrote: > Hi. > >

$$Excel-Macros$$ Re: Escaping a foir loop

Hello Kumaran Exit For would completely exit from the for loop.. i want it to skip the code for the current loop and iterate to the next loop Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 29, 2009 at 4:45 PM

$$Excel-Macros$$ Escaping a foir loop

should not run and the next should be started... i want the line of code which i should insert in the ifendif statement its urgent can anybody please help me.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Password removal Tool !

Hi Shafiq Where is the file... Please attach the same Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 28, 2009 at 3:59 PM, shafiq online wrote: > > Attached is password removal tool. You can you it by

$$Excel-Macros$$ Re: Can any one resolve this?????

End Sub == Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 28, 2009 at 5:48 AM, hemant shah wrote: > Hi All, > > I have recently join the group and i have one query on ex

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

Pinky... can u please attach the file..so that the solution can be worked out in that itself Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 27, 2009 at 4:18 PM, Pinky Sangani wrote: > > HI > i need this ASAP

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Dhananjay. Have you been able to download the file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 27, 2009 at 7:25 PM, Dhananjay Pinjan wrote: > Hello Mr. Vivek Agrawal, > > I cannot able to view

$$Excel-Macros$$ Re: High : TOP URGENT

Hi Dilip Thanks for the reply... will look forward to your help whenever required and thanks for the compliments... :-) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sun, Jul 26, 2009 at 1:39 PM, Dilip Pandey wrote

$$Excel-Macros$$ Re: High : TOP URGENT

Dear Dilip Can you please assist how did u crack the password protected file Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 8:44 PM, Dilip Pandey wrote: > Hi Abdul, > > Attached xls has been &qu

$$Excel-Macros$$ Re: High : TOP URGENT

hi Abdul... You can copy paste the sheet date to some other sheet in some another workbook Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 6:17 PM, Abdul Hakim Khan wrote: > Dear All, > Please h

$$Excel-Macros$$ Re: File needed in pdf

Hi Dave Please find the pdf file at http://groups.google.com/group/excel-macros/files?&sort=date Save the first listed file in the link above Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 5:2

$$Excel-Macros$$ Re: QUERY ON EXCEL

Hi The query is not very clear can u please explain what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 5:43 PM, big smile wrote: > Respected friends, > > I am new this group. >

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

the file can be opened only through a TORRENT application such as bitlord. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 4:52 PM, DEBASHIS BANERJEE wrote: > if Save target is clicked .. file

$$Excel-Macros$$ Re: Code to remove cache after running pivot table

Hi Ravi... I am not easy with pivots but guess the following link might be helpful http://www.brainbell.com/tutorials/Excel_VBA/Size_Of_A_Finished_Pivot_Table.html Hope it Helps Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul

$$Excel-Macros$$ Re: Removing leading Zeros

hi manoj this would remove all the zeros from inbetween... he wants to remove only the trailing zeros... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 4:14 PM, Manoj S Negi < manojsnegi.uttr

$$Excel-Macros$$ Re: Removing leading Zeros

, Position, 1) Do While vChar = "0" Position = Position + 1 vChar = Mid(vCells.Value, Position, 1) Loop vCells.Value = Mid(vCells.Value, Position, Len(vCells.Value)) Next End Sub = Hope it works Regards, Vivek Agrawal Skype ID - vivek

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Kunal I dont have the specified book. See if could search in on internet... torrents might be available Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 3:37 PM, kunal wrote: > > Hi, Vivek, >

Re: Fwd: $$Excel-Macros$$ Need earliest record based in unique identifier

Hi Attached is the module that does your work... Hope it suffices.. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 11:22 PM, Lee wrote: > > Here is the link to the file. > > www.progressivetel.

$$Excel-Macros$$ Re: How to retrieve the address of a cell used in a formula

Hi Can u please attach a sample sheet... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 1:22 AM, Telenochek wrote: > > Hello everyone, > > I have a worksheet that calculates system performan

Fwd: $$Excel-Macros$$ Need earliest record based in unique identifier

Hi i would suggest you send the file so that the workaround can be figured out... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 6:58 PM, Lee wrote: > > I have a bunch of test data. Column A is th

$$Excel-Macros$$ Re: PlZ Short This Pro.

Hi Anil The segregation of the full name into first and second name is based on self judgement in case of 3 word names... how would you like to separate into two names Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri

$$Excel-Macros$$ Re: Help for Data Avance Filters

ops up... enter the upper and the lower range in the appropriate boxes... DONE. :-) hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul 24, 2009 at 12:11 PM, Rehan Baig wrote: > I need help for usin

$$Excel-Macros$$ Re:

Hi Debashis go to this link http://groups.google.com/group/excel-macros/files?&sort=date right click on the first file and save it directly... it gets saved... i've checked it just now.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving en

$$Excel-Macros$$ Re: Unique Data summary problem

egards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:48 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: > Vivek, > > I understood the problem actually countifs is not there in excel 2003, and &g

$$Excel-Macros$$ Re: Unique Data summary problem

depends what formula you are putting... the referencing of cells need to be taken care of Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:16 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com>

$$Excel-Macros$$ Re: Saving Filename with variable

Hi Aman Can u please specify what kind of error you are facing which point the error comes does the file get saved.. or might be possible the file path doesnot exist. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On

$$Excel-Macros$$ Re: how to make unique key

. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:19 PM, Aamir Shahzad wrote: > Dear Vivek Agrawa, > > Thanks for reply. Please find attachment. In attachment two sheet available > "Main sheet

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Aamir go to this link http://groups.google.com/group/excel-macros/files?&sort=date right click on the first file and save it directly... it gets saved... i've checked it just now.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-S

$$Excel-Macros$$ Re: Duplicate colmuns

<> 0 Then vClmn(1)(x).Interior.ColorIndex = vColor(x) vClmn(2)(x).Interior.ColorIndex = vColor(x) End If Next End Sub ==== Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul

$$Excel-Macros$$ Re: Duplicate colmuns

End If Next For x = 1 To vRows_Count If vColor(x) <> 0 Then vClmn(1)(x).Interior.ColorIndex = vColor(x) vClmn(2)(x).Interior.ColorIndex = vColor(x) End If Next End Sub = hope it does the required.. Thanks

$$Excel-Macros$$ Re: Duplicate colmuns

ok ok now i got the query,.., will try to get a solution soon... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 12:51 PM, Mahesh wrote: > Hi vivek, > > I want that if both columns are same then i

$$Excel-Macros$$ Re: Duplicate colmuns

Hi Satish It would be really helpful of you if you could show the same in an excel sheet required is that different duplicate sets should be identified by different colors so that we can diffentiate them and find how many value are duplicated... Thanks a lot Regards, Vivek Agrawal Skype ID

$$Excel-Macros$$ Re: Duplicate colmuns

hi mahesh The requirement is still not clear... can u please explain which values u want to compare and in what manner to highlight Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:20 AM, Mahesh wrote

$$Excel-Macros$$ Re: Saving Filename with variable

'Define the filename vPath = "D:\extractfiles" ' Define the file path - can be changed accordingly ActiveWorkbook.SaveAs vPath & "\" & vFileName & ".xls" 'Saving the workbook. ActiveWorkbook.Close End Sub

$$Excel-Macros$$ Re: Books on MS 2007

it is working i just checked.. try saving the file from the "FILES" section of the group Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 12:17 AM, kanwaljit Singh wrote: > Hi Viv

$$Excel-Macros$$ Re: Count of Status

copy pasting would not work as the cell referencing takes place... u will need to edit the code according to the column and the row used. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 PM, Saurabh

$$Excel-Macros$$ Re: Count of Status

this includes HD too Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 PM, Saurabh wrote: > Exactly want the same.. Thanks.. > > One more query... > > 1). I m not able to use the sa

$$Excel-Macros$$ Re: Count of Status

to get the count of "HD"/2, just edit the code accordingly and will get the result... i hope u could figure out how the formula works Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 P

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

go the "FILES" section of the group ... try saving the file from there.. it should get saved... there is not question of not getting it... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 6:24

$$Excel-Macros$$ Re: Count of Status

Hello Saurabh Attached is the file with the proposed solution. Hope it helps ALL THE BEST Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 4:19 PM, Saurabh wrote: > Hi All, > > I m having a trouble in atta

$$Excel-Macros$$ Re: PLEASE SEND ME URGENT!~!!!!!!!!

Here is the same in 2003 format Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 3:48 PM, Pranaya Pradhan wrote: > Hi Vivek > > Could u send it in excel 2003 format. > plsss > > > On 7

$$Excel-Macros$$ Re: PLEASE SEND ME URGENT!~!!!!!!!!

Hi Amresh Here is one which i have created... Hope you'll understand the working... if not.. do write back All The Best Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 2:13 PM, amresh kumar wrote:

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

text which u have pasted comes only if u trying opening the file in the browser, where as i am asking you to right click on the link and save it directly on your computer system. Hope it helps.. Thanks Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving e

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Ankur, Right click on the link and click "Save Target/Link as". This would download the torrent file which would download the ebooks. Do write in case u face problems. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Problem with duplicating a Shape and defining OnAction property

Hello NandKumar Please scan through the recent posts and files on this group. You would find links and reference to books for learning VBA. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 10:26 AM

$$Excel-Macros$$ Microsoft Office 2007 ebooks collection

/Microsoft_Office_2007_eBooks_Collection_%5BPDF_CHM_-_ENG%5D.4573644.TPB.torrent Hope it helps. ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID :- vivek.agrawal83 --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: how to make unique key

Can u please mail a sample excel sheet to make your doubt somewhat more clear. Thanks and Regards,Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 21, 2009 at 11:54 PM, Aamir Shahzad wrote: > Dear all, > > Can anyone tell me pl

$$Excel-Macros$$ Re: Problem with duplicating a Shape and defining OnAction property

ile, SHAPE object as as *"onaction"* property where as the SHAPES object doesn't have one. I hope i have made myself clear. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 2:52 AM, Adrian wrote:

$$Excel-Macros$$ Re: HELP

Well Rajesh I do not think there is a specific formula... its just that i would create a vba application which would transfer the entries from the trial balance to the respective target reports... Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: HELP

Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 21, 2009 at 7:21 PM, Rajesh Janardanan wrote: > > Thanks Vivek. > But what are the tools or formulas in excel we can use for doing this > package ? I would like to

$$Excel-Macros$$ Re: HELP

Well Rajesh Regards, Vivei do not think there is a specific formula... its just that i would create a vba application which would transfer the entries from the trial balance to the respective target reports... Regards Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving

$$Excel-Macros$$ Re: Macros

, Vivek Agrawal Skype ID - vivek.agrawal83 On Jul 16, 8:06 am, vebhav jain wrote: > Hiii ... I want to learn the macro functions, so if u have any files > regarding basics of macro then plz mail to me. > >                    Thanks in Avance > > Reg

$$Excel-Macros$$ Re: looking for a good book or answers to these questions

hello your question doesnt seem to very clear. can u pls post an excel file with clearly depicting what u exactly want thanks On Jul 16, 8:09 pm, osiso wrote: > to basically help with proramming in vb excel to do things such as: > > 1. create if then statement where the =if(file\1.xls\sheet1!a

$$Excel-Macros$$ Re: HELP

Hello Rajesh For this you would require to send the following excel files so that the format and the structure can be used... 1. The report which you download from SAP 2. the format in which you want the P&L, Cash Flow and the Balance sheet.. Thanks On Jul 16, 7:42 pm, Rajesh Janardanan w

  1   2   >