Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread SG
Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com javascript: wrote: yeah got it...one more thing..in reports, we can't say customer to select * for All because it's not user

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread Vaibhav Joshi
Cheers!! On Thu, Jun 19, 2014 at 4:03 PM, SG sonal...@gmail.com wrote: Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com wrote: yeah got it...one more thing..in reports, we can't

$$Excel-Macros$$ Need VBA code to track log off and log on Time

2014-06-19 Thread sunil patil
Hi All, Can you provide me vba code to track when any user lock the system, time shoud start tracking in one excel sheet when user relogin . the final output shoud be logg off time to login time., E.g suppose user lock the computer by 6:30 and log in after 6:45, time shoud be calculated as

Re: $$Excel-Macros$$ Need VBA code to track log off and log on Time

2014-06-19 Thread Paul Schreiner
That's actually not that easy to do.   The problem is that you're dealing with Windows Events. Many Windows events (login, screen locking, etc) write to a system log. but many of these are set up by the workstation Policies.   The policies are handled by the network system administrator.  

$$Excel-Macros$$ Very Urgent

2014-06-19 Thread Ankur Gupta
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as

$$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

2014-06-19 Thread Ankur Gupta
I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

2014-06-19 Thread Anil Gawli
Dear Ankur, Pl share the workbook with us. Warm Regards, Gawli Anil. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta anky...@gmail.com wrote: I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but