date:20120813

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

2012-08-13 Thread amar takale

Dear Guillett Sir
I am confused about this code,I put this code but what changes in sheet,I
am not under stand.Pls in attached sheet solved problem if possible.I think
in to cell from date & Last date input through data validation & when I
change range date then update chart between that date range.
Thanks for reply
Amar

On Mon, Aug 13, 2012 at 7:08 PM, dguillett1  wrote:

>   Sub namechart()
> For Each c In ActiveSheet.ChartObjects
> c.Name = InputBox("Change the chart name " & c.Name)
> Next c
> End Sub
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* amar takale 
> *Sent:* Monday, August 13, 2012 1:58 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Chart Update Within Date Data Range
>
> I will Attached file Pls solved me problem
>
> On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI 
> wrote:
>
>> after typing = in Formula bar, Please select I2 cell then press Enter
>>
>>
>> On Fri, Aug 10, 2012 at 3:33 PM, Imran khan  wrote:
>>
>>> Hi Noorain,
>>>
>>> I am not able do it. When i am selecting Chart title, when typing =, it
>>> remains = only
>>>
>>>
>>> On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Hi Imran,

 First you select Chart Title then goto Formula Bar, Type = and select
 Cell "I2"

 Hope it will help to you.

 On Fri, Aug 10, 2012 at 3:11 PM, Imran khan  wrote:

> Hi Noorain,
>
> How we write formula in Text Box, as you write " Jan to May"
> (='Dynamic Char 2'$I$2). Could you please guide us. Can we do simply put =
> and then go to cell?
>
> Regards,
> Imran
>
>
> On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Amar,
>>
>> Please find attached Sample file, hope it will fulfill you
>> expectation.
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>> On Fri, Aug 10, 2012 at 2:19 PM, amar takale wrote:
>>
>>> Dear sir,
>>> I have One Chart File with Data,I want to if I changed Date from...
>>> to. (In particular two cell start & End date) Then automatically
>>> changed chart Range & Update Chart that within Date range.
>>> Pls send me Example file Then I will use that in my excel
>>>
>>> Thank Sir
>>> Amar --
>>> 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
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>> in signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>> allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>> .
>>>
>>>
>>>
>>
>>
>>
>>
>> --
>> 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
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> allowed.
>>

$$Excel-Macros$$ I need help on a macro which extracts rows which have a 7 digit number in a column.

2012-08-13 Thread Radhika


For ex i have thousands of records in which one col has 7 digit number in 
many rows. I need to extract only rows having that 7 digit number.
That number has digits 0-9.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ macro for detecting date in row

2012-08-13 Thread pawel lupinski

Hi All,
I'd like to have a macro that will detect curent date (eg in column "H")
then copy all all columns from "A" to column "H" (column "H" excuded so range 
A:G) and paste all these column as value
Thanks
Pawel

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




datemacro.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Rek : Need CRM Administrator (Salesforce)

2012-08-13 Thread Prince Dubey

Hi Ayush Pls ban this user.

On Monday, 13 August 2012 21:48:23 UTC+5:30, sudheer sudheer wrote:
>
> *Hi*
>
> *Need*
>
> *Role: CRM Administrator (Sales force)*
>
> *Duration: 1 Year*
>
> *Location: Austin, TX*
>
> *Job Specific *
>
> *Job Specific Required education & experience*
>
> ·   High School diploma or equivalent.  
>
> ·   3 years+ experience maintaining and configuring a CRM environment, 
> specifically 
> salesforce.com 
>
> ·   Salesforce.com Certification, specifically Salesforce 
> Administrator or Salesforce Advanced Administrator
>
> *Required soft skills*
>
> ·   Strong grasp of communication in English, both written and verbal
>
> ·   Strong team player with service oriented attitude and customer 
> focus
>
> ·   Ability to manage stressful situations in a calm, courteous and 
> efficient manner
>
> ·   Critical thinking
>
> ·   Excellent problem-solving methodology
>
> ·   Exceptional interpersonal and time management skills
>
> ·   Exceptional resourcefulness and the ability to retain information
>
> ·   Organize, prioritize and multi-task while managing users' 
> expectations 
>
> *Additional preferred requirements*
>
> ·   Experience balancing multiple salesforce.com implementations or 
> merging implementations together
>
> ·   Experience in improving existing salesforce.com implementations
>
> ·   Experience in architecting a salesforce.com deployment
>
> ·   Bachelors degree in technical field
>
>  
>
> Thank You!
>
>  
>   
> [image: image003]
>  
> *Sudheer*
>   
>  IT Recuiter 
> Sriven Infosys Inc
> Ph: 972-734-5299|| Fax: 516-977-0618
> E Mail: sud...@sriveninfosys.net  || Gmail id : 
> sudheer.sr...@gmail.com 
> URL: www.sriveninfosys.com
>   
> Sriven Infosys, Inc is an Equal Opportunity Employer. Qualified applicants 
> will receive consideration for employment without regard to race, color, 
> religion, sex, national origin, ancestry, citizenship, disability, age, 
> military or veteran status, and other characteristics* *
>  We help our clients, employees & partners compete and win!
>
>  
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Power pivot

2012-08-13 Thread Rajan_Verma

Noorain bhai,

She is asking about Power pivot. Not power point.

If you have some material on Power pivot , would be helpful .

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 13 August 2012 10:20
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Power pivot

 

Hi Rekha,

Please see attached study materials.

On Mon, Aug 13, 2012 at 6:55 PM, rekha siri 
wrote:

hi Team,

 

Please share if anyone is having PPT tutorial on Power pivot, usuage of
sparklines/slicer in Excel 2010.

 

Thanks,

Rekha

-- 
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 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 




-- 
With Regards,
Noorain Ansari
  http://noorainansari.com
 
  http://excelvbaclinic.com
  

 

 

-- 
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 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Power pivot

2012-08-13 Thread ashish koul

http://msdn.microsoft.com/en-us/library/office/gg619397.aspx
http://www.gaelduhamel.com/tag/power-pivot/
http://msdn.microsoft.com/en-us/LIBRary/gg670985




On Mon, Aug 13, 2012 at 6:55 PM, rekha siri wrote:

> hi Team,
>
> Please share if anyone is having PPT tutorial on Power pivot, usuage of
> sparklines/slicer in Excel 2010.
>
> Thanks,
> Rekha
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Prince Dubey

Hi Divaker,

Can you plz share ur work book with group.

regards
prince

On Thursday, 9 August 2012 19:17:50 UTC+5:30, Divaker Pandey wrote:
>
> Hi Expert,
>
> can any one help me to show last available date in chart -xaxis range.
>
>
> Divaker
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner

I have a "solution" that I use.
I place most of the files in network locations, so they are backed up regularly.
Where necessary, SHORCUTS are created to utilize these files. 
It has some limitations, since I could not use the Group Policy approach (thank 
you I.T.)

It consists of (4) files. 
---
File #1) I have a simple text file called pctime.txt that is in the format:
Day|  Date    | IN    |   OUT
Mon|01/02/2012|||Holiday
Tue|01/03/2012|07:10:00 AM|04:20:00 PM
Wed|01/04/2012|07:10:00 AM|04:05:00 PM
Thu|01/05/2012|07:00:00 AM|04:05:00 PM
Fri|01/06/2012|07:10:00 AM|03:35:00 PM

It is located in a Network Folder, but can be placed anywhere. 
---
File #2) is the "Login" file:  LogIn.vbs
A shortcut to this file is placed in the Startup Folder so that it executes 
whenever Windows STARTS.
(note, this does NOT run if the computer is "locked" and a password is used to 
unlock the computer)
This file makes an entry into File #1 unless a previous exists. 
---
File #3) is the "Logout" file.
After making the appropriate entry in File #1, this file CURRENTLY opens a web 
page used for updating a company time sheet.
But since my computer must remain logged in so that nightly jobs can run, it no 
longer loggs off.
However, I'm sure I have an older version that forces a reboot.
---
File #4) is an excel Workbook.
This workbook contains all weeks for the current year.
Setting the first workday of the year automatically resets the dates for the 
rest of the year.
When opened, this workbook opens File #1 and updates the start/stop time for 
missing cells.
---

If you feel that this technique is suitable, I will "clean up" my files and 
send 
them to you.


Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Mangesh Vimay 
To: excel-macros@googlegroups.com
Sent: Mon, August 13, 2012 10:35:43 AM
Subject: Re: $$Excel-Macros$$ Need your help

Hi Paul/Friends, 

I would like to use this concept for my personal computer. I knew very well 
that 
It is going to be tough job but as many experts are part of this group, I hope 
someone would definitely try to get answer. 
Let me know if you need more information on same.
Please find the attached sheet that can be use as start up sheet to solve the 
problem.


On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner  wrote:

I've worked through quite a bit of this.
>Spent MANY hours trying to work it out.
>
>There's LOTS of things to consider.
>
>#1.. is this for personal use, or for many people in an office?
>1a)  If it is an office, is there an I.T. department that controls PC and 
>Windows configuration?
>
>Windows has a "Group Policy" that allows you to create login/logouts scripts 
>for 
>Windows.
>Since my work environment has an I.T. Department that controlls our system 
>configurations,
>I could not utilize this method. (They locked out the Group Policy Editor)
>
>Instead, I created a login and logout VB script that writes to a text file.
>It looks for today's date.
>If found, it compares the current time to the time record.
>If for some reason, the current time is EARLIER than the login time recorded, 
>it 
>overwrites it.
>(this should only happen if someone manually modified the file)
>
>This vbscript is placed in the Startup folder and runs when windows Starts.
>
>logOUT is a bit of a problem.
>
>I created a vbscript to use to log out.
>It records the time, then exits windows.
>
>However, the user MUST use this script to log out.
>If windows is exited normally, (or abnormally for that matter)...
>basically.. if any other method is used to log out, the time is not recorded.
>
>For Personal use, I am very disciplined about using this.
>But for widespread use? I wouldn't trust it.
>
>Another security issue is that the file it updates is a simple text file.
>Therefore, a user COULD modify the values...
>(i.e.: I was 10 minutes late getting to my desk because my boss was talking to 
>me at the coffee machine on the way in.
>So, I wanted to "back out" the time so it wouldn't show up as "late"...)
>I've CONSIDERED trying to open the file as "Binary".
>I've done this from Excel before, but not from VBScript.
>
>My excel file then updates from this log file when opened.
> 
>Paul
>-
>“Do all the good you can,
>By all the means you can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay

Hi Paul/Friends,

I would like to use this concept for my personal computer. I knew very well
that It is going to be tough job but as many experts are part of this
group, I hope someone would definitely try to get answer.
Let me know if you need more information on same.
Please find the attached sheet that can be use as start up sheet to solve
the problem.

On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner wrote:

> I've worked through quite a bit of this.
> Spent MANY hours trying to work it out.
>
> There's LOTS of things to consider.
>
> #1.. is this for personal use, or for many people in an office?
> 1a)  If it is an office, is there an I.T. department that controls PC and
> Windows configuration?
>
> Windows has a "Group Policy" that allows you to create login/logouts
> scripts for Windows.
> Since my work environment has an I.T. Department that controlls our system
> configurations,
> I could not utilize this method. (They locked out the Group Policy Editor)
>
> Instead, I created a login and logout VB script that writes to a text file.
> It looks for today's date.
> If found, it compares the current time to the time record.
> If for some reason, the current time is EARLIER than the login time
> recorded, it overwrites it.
> (this should only happen if someone manually modified the file)
>
> This vbscript is placed in the Startup folder and runs when windows Starts.
>
> logOUT is a bit of a problem.
>
> I created a vbscript to use to log out.
> It records the time, then exits windows.
>
> However, the user MUST use this script to log out.
> If windows is exited normally, (or abnormally for that matter)...
> basically.. if any other method is used to log out, the time is not
> recorded.
>
> For Personal use, I am very disciplined about using this.
> But for widespread use? I wouldn't trust it.
>
> Another security issue is that the file it updates is a simple text file.
> Therefore, a user COULD modify the values...
> (i.e.: I was 10 minutes late getting to my desk because my boss was
> talking to me at the coffee machine on the way in.
> So, I wanted to "back out" the time so it wouldn't show up as "late"...)
> I've CONSIDERED trying to open the file as "Binary".
> I've done this from Excel before, but not from VBScript.
>
> My excel file then updates from this log file when opened.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* David Grugeon 
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, August 13, 2012 9:25:56 AM
> *Subject:* Re: $$Excel-Macros$$ Need your help
>
> Magnesh and Paul
>
> I think you could put an excel file (or a shortcut to one), in the startup
> folder.  have an on open macro in the sheet to record the opening time.
>  Then have a before close macro to record the time and save itself.
>
> My only concern would be whether Windows kills excel before the saving
> process is complete.  Otherwise it should work, provided you don't mind
> having the file, and excel, open all day.
>
> On 13 August 2012 22:55, Paul Schreiner  wrote:
>
>>   This is going to be a tough one.
>> It involves access to the Windows environment.
>> I REALLY hope someone has an alternative,
>> but I think you're going to have to write some
>> VBscript files that run at Windows Login and Logout
>> that will make entries to a log file.
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>>  --
>> *From:* Mangesh Vimay 
>> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI <
>> noorain.ans...@gmail.com>; rajan verma 
>> *Sent:* Mon, August 13, 2012 8:48:16 AM
>> *Subject:* $$Excel-Macros$$ Need your help
>>
>> Hi Friends,
>>
>> Please help me on issue below.
>> *Issue :-*  I need such excel file which can automatically stored login
>> time with date and logout time so that I could able to analysis for how
>> much time my computer was switched on/in use.
>> For example,
>> If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date *
>> 13/8/2012*.
>> Then it should feed all these data in an excel sheet like as -
>> [image: Inline image 1]
>>
>> We can take help of VBA also.
>> I hope I am able to tell you my need. If not please let me know.
>> Thanks in advance.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accu

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Kishan Reddy, K

One way is to display every value on x axis.  But this will work only for 
limited values on x.
Means your date range is below 20 or 30.

Here you have to format the x axis. Select the scale tab. set the minor 
unit = 1 and major unit = 1.

Another way is to display the max date above or some where around the graph 
for information purpose or add a suitable title reflecting the from date 
and to date.

This is the way I found a solution, when i faced the same problem.

Regards,
Kishan Reddy, k

On Thursday, August 9, 2012 7:17:50 PM UTC+5:30, Divaker Pandey wrote:
>
> Hi Expert,
>
> can any one help me to show last available date in chart -xaxis range.
>
>
> Divaker
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner

I've worked through quite a bit of this.
Spent MANY hours trying to work it out.

There's LOTS of things to consider.

#1.. is this for personal use, or for many people in an office?
1a)  If it is an office, is there an I.T. department that controls PC and 
Windows configuration?

Windows has a "Group Policy" that allows you to create login/logouts scripts 
for 
Windows.
Since my work environment has an I.T. Department that controlls our system 
configurations,
I could not utilize this method. (They locked out the Group Policy Editor)

Instead, I created a login and logout VB script that writes to a text file.
It looks for today's date.
If found, it compares the current time to the time record.
If for some reason, the current time is EARLIER than the login time recorded, 
it 
overwrites it.
(this should only happen if someone manually modified the file)

This vbscript is placed in the Startup folder and runs when windows Starts.

logOUT is a bit of a problem.

I created a vbscript to use to log out.
It records the time, then exits windows.

However, the user MUST use this script to log out.
If windows is exited normally, (or abnormally for that matter)...
basically.. if any other method is used to log out, the time is not recorded.

For Personal use, I am very disciplined about using this.
But for widespread use? I wouldn't trust it.

Another security issue is that the file it updates is a simple text file.
Therefore, a user COULD modify the values...
(i.e.: I was 10 minutes late getting to my desk because my boss was talking to 
me at the coffee machine on the way in.
So, I wanted to "back out" the time so it wouldn't show up as "late"...)
I've CONSIDERED trying to open the file as "Binary".
I've done this from Excel before, but not from VBScript.

My excel file then updates from this log file when opened.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-

From: David Grugeon 
To: excel-macros@googlegroups.com
Sent: Mon, August 13, 2012 9:25:56 AM
Subject: Re: $$Excel-Macros$$ Need your help

Magnesh and Paul 

I think you could put an excel file (or a shortcut to one), in the startup 
folder.  have an on open macro in the sheet to record the opening time.  Then 
have a before close macro to record the time and save itself.

My only concern would be whether Windows kills excel before the saving process 
is complete.  Otherwise it should work, provided you don't mind having the 
file, 
and excel, open all day.

On 13 August 2012 22:55, Paul Schreiner  wrote:

This is going to be a tough one.
>It involves access to the Windows environment.
>I REALLY hope someone has an alternative,
>but I think you're going to have to write some 
>VBscript files that run at Windows Login and Logout
>that will make entries to a log file.
> 
>Paul
>-
>“Do all the good you can,
>By all the means you can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-
>
>
>
>
>

From: Mangesh Vimay 
>To: excel-macros@googlegroups.com; NOORAIN ANSARI ; 
>rajan verma 
>Sent: Mon, August 13, 2012 8:48:16 AM
>Subject: $$Excel-Macros$$ Need your help
>
>
>Hi Friends, 
>
>
>Please help me on issue below.
>Issue :-  I need such excel file which can automatically stored login time 
>with 
>date and logout time so that I could able to analysis for how much time my 
>computer was switched on/in use.
>For example,
>If I login by the time 7:00:00 AM and logout on 12:30:00 PM on Date 13/8/2012.
>Then it should feed all these data in an excel sheet like as -
>
>
>
>
>We can take help of VBA also.
>I hope I am able to tell you my need. If not please let me know.
>Thanks in advance.
>
>-- 
>With regards, 
>
>
>MaNgEsH
>-- 
>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 Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
> 
>2) Don't post a question in the thread of another member.
> 
>3) Don't post questions regarding breaking or bypassing any security measure.
> 
>4) Acknowledge the responses you receive, good or bad.
> 
>5) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
>
> 
>6) Jobs posting is not allowed.
> 
>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> 
>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>owners 
>and me

$$Excel-Macros$$ Re: What is the future of VBA?

2012-08-13 Thread Kishan Reddy, K

Comparing to Programming languages, application packages do have a long 
life.

Still, why do you worry, about the future of VBA.

Softwares are born, evolve & become obsolete over a period of time.

But software concepts, which have deep foundation in physical sciences & 
mathematics do have a long life.

While software professionals spend their time and resources to learn 
softwares, 
but will not try to understand the concepts & fundamentals.

The persons who (at least try to) understands the concepts & fundamentals 
of various softwares 
will not bother about the life span of a particular software.

Also, You can't project the life span of a software, just like you can't 
assess the life span of your own life.

So, enjoy the fun of softwares and also the life.

Regards,
Kishan Reddy, K

On Sunday, August 12, 2012 2:01:17 AM UTC+5:30, (%Allmydreams%) wrote:
>
> Dear All,
>
> What is the future of VBA?  
>
> Or will it be killed suddenly like VB6? 
>
> Do write back all your thoughts on given subject
>
>
>
> Regards
> Yogananda Muthaiah
>
>
>  

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

2012-08-13 Thread dguillett1

Sub namechart()
For Each c In ActiveSheet.ChartObjects
c.Name = InputBox("Change the chart name " & c.Name)
Next c
End Sub

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Monday, August 13, 2012 1:58 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

I will Attached file Pls solved me problem


On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI  
wrote:

  after typing = in Formula bar, Please select I2 cell then press Enter 



  On Fri, Aug 10, 2012 at 3:33 PM, Imran khan  wrote:

Hi Noorain, 

I am not able do it. When i am selecting Chart title, when typing =, it 
remains = only  



On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI  
wrote:

  Hi Imran,

  First you select Chart Title then goto Formula Bar, Type = and select 
Cell "I2"

  Hope it will help to you. 

  On Fri, Aug 10, 2012 at 3:11 PM, Imran khan  wrote:

Hi Noorain, 

How we write formula in Text Box, as you write " Jan to May" (='Dynamic 
Char 2'$I$2). Could you please guide us. Can we do simply put = and then go to 
cell?

Regards,
Imran 



On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI 
 wrote:

  Dear Amar,

  Please find attached Sample file, hope it will fulfill you 
expectation.



  -- 
  With Regards,
  Noorain Ansari
  http://noorainansari.com
  http://excelvbaclinic.com 



  On Fri, Aug 10, 2012 at 2:19 PM, amar takale  
wrote:

Dear sir,
I have One Chart File with Data,I want to if I changed Date from... 
to. (In particular two cell start & End date) Then automatically changed 
chart Range & Update Chart that within Date range.
Pls send me Example file Then I will use that in my excel

Thank Sir
Amar -- 
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 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
will not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any 
security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this 
forum in signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
 
 





  -- 
  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 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
will not get quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security 
measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum 
in signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   




-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for viol

$$Excel-Macros$$ Power pivot

2012-08-13 Thread rekha siri

hi Team,

Please share if anyone is having PPT tutorial on Power pivot, usuage of
sparklines/slicer in Excel 2010.

Thanks,
Rekha

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread David Grugeon

Magnesh and Paul

I think you could put an excel file (or a shortcut to one), in the startup
folder.  have an on open macro in the sheet to record the opening time.
 Then have a before close macro to record the time and save itself.

My only concern would be whether Windows kills excel before the saving
process is complete.  Otherwise it should work, provided you don't mind
having the file, and excel, open all day.

On 13 August 2012 22:55, Paul Schreiner  wrote:

> This is going to be a tough one.
> It involves access to the Windows environment.
> I REALLY hope someone has an alternative,
> but I think you're going to have to write some
> VBscript files that run at Windows Login and Logout
> that will make entries to a log file.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Mangesh Vimay 
> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI <
> noorain.ans...@gmail.com>; rajan verma 
> *Sent:* Mon, August 13, 2012 8:48:16 AM
> *Subject:* $$Excel-Macros$$ Need your help
>
> Hi Friends,
>
> Please help me on issue below.
> *Issue :-*  I need such excel file which can automatically stored login
> time with date and logout time so that I could able to analysis for how
> much time my computer was switched on/in use.
> For example,
> If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date *
> 13/8/2012*.
> Then it should feed all these data in an excel sheet like as -
> [image: Inline image 1]
>
> We can take help of VBA also.
> I hope I am able to tell you my need. If not please let me know.
> Thanks in advance.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards
David Grugeon

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner

This is going to be a tough one.
It involves access to the Windows environment.
I REALLY hope someone has an alternative,
but I think you're going to have to write some 
VBscript files that run at Windows Login and Logout
that will make entries to a log file.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Mangesh Vimay 
To: excel-macros@googlegroups.com; NOORAIN ANSARI ; 
rajan verma 
Sent: Mon, August 13, 2012 8:48:16 AM
Subject: $$Excel-Macros$$ Need your help

Hi Friends, 

Please help me on issue below.
Issue :-  I need such excel file which can automatically stored login time with 
date and logout time so that I could able to analysis for how much time my 
computer was switched on/in use.
For example,
If I login by the time 7:00:00 AM and logout on 12:30:00 PM on Date 13/8/2012.
Then it should feed all these data in an excel sheet like as -


We can take help of VBA also.
I hope I am able to tell you my need. If not please let me know.
Thanks in advance.

-- 
With regards, 

MaNgEsH
-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

$$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay

Hi Friends,

Please help me on issue below.
*Issue :-*  I need such excel file which can automatically stored login
time with date and logout time so that I could able to analysis for how
much time my computer was switched on/in use.
For example,
If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date *
13/8/2012*.
Then it should feed all these data in an excel sheet like as -
[image: Inline image 1]

We can take help of VBA also.
I hope I am able to tell you my need. If not please let me know.
Thanks in advance.

-- 
With regards,

MaNgEsH

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

2012-08-13 Thread Sundarvelan N

Dear Friends,

Please help me, after i updated the cell C17 the cursor should go to the
update button so that i dont use mouse to update please please help me
Thanks
N.Sundarvelan
9600160150



On Mon, Aug 13, 2012 at 3:46 PM, Sundarvelan N  wrote:

> Hello Friends,
>
> Some how i finished my project. Last one help to finish my project.
>
> My task is after i passedcorssed the cell C17 the cursor should go to
> update button, please help me as soon as possible.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon wrote:
>
>> This looks like school homework to me.  If we do your homework for you,
>> you learn nothing.  Use the resource materials you have no doubt been
>> given, read the book.  Try to do it yourself - even if you can only do part
>> of it.  Than come back to the group to help you with any specific aspect
>> that is causing you problems.
>>
>>
>> On 11 August 2012 20:10, Sundarvelan N  wrote:
>>
>>> Brothers please help me
>>>
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>>
>>>
>>> -- Forwarded message --
>>> From: Sundarvelan N 
>>> Date: Wed, Aug 8, 2012 at 2:32 PM
>>> Subject: Data Entry - Need insert rows when i press enter button
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Hello Friends,
>>>
>>> I need to complete a projec. The requirement as follows
>>>
>>>
>>>1. When i press ENTER button in the INPUT sheet the data should add
>>>in the DATA sheet
>>>2. The cursor should automatically go to the next tex box when i hit
>>>enter button
>>>
>>> I would be thankfull if it is done as soon as possible.
>>>
>>> Thanks
>>> N.Sundarvelan
>>> 9600160150
>>>
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Regards
>> David Grugeon
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

2012-08-13 Thread Ashish Pradhan



Hi

Very Limited Knowledge of Excel as compared to most others. I use Excel 
2003. What I did was to add another column with the formula 
=text(C2,"") C2 is the date column. (I converted 05.04.2012 into a 
proper date format first).


The above formula gave me a month like "April". Then used the regular 
"Filter" to sort on the additional column created -- Month.


Most likely a longer method of solving the issue. CoRe's solution works 
great. (And without the need to add any column).


Thanks

Ashish Pradhan

On 13-08-2012 15:55, CoRe wrote:

Hello Gunjal ,



Please check the file attached.


My result (excel 2007 or older) : Select all your date , go to Home > 
Sort & Filter > Custom Sort




On Monday, August 13, 2012 1:00:20 PM UTC+3, Pravin Gunjal wrote:

Dear Friends

Greetings for the day!

I have attached herewith one file in which three columns are
there. viz. 1) Doc. No. 2) Doc. Date & 3) Party Name

1) I would like to sort this file as per the serial doc. numbers
but unable to do.  If we do the date wise sorting it takes day
wise only and not as month wise day wise.

2) As we are having some customer data in different excel file and
need to be gathered in a single file.  But we can not do the
v-lookup use directly, as this file is having customer names along
with the places.  And in other file we are having only names
without their places  - At present we are doing it manually like :
we are sorting it customer wise and removing the place by using
edit function for a stockist and using copy-paste for that
particular stockist.

As approximately we are having 98 customers and it is very
difficult to do it manually.

Kindly help me out on this issue.  Thank you.

*With regards,
**Pravin Gunjal**
*

--
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 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum 
in signatures are prohibited.


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.





--
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

2012-08-13 Thread Ashish Pradhan



Hi

Very Limited Knowledge of Excel as compared to most others. I use Excel 
2003. What I did was to add another column with the formula 
=text(C2,"") C2 is the date column. (I converted 05.04.2012 into a 
proper date format first).


The above formula gave me a month like "April". Then used the regular 
"Filter" to sort on the additional column created -- Month.


Most likely a longer method of solving the issue. CoRe's solution works 
great. (And without the need to add any column).


Thanks

Ashish Pradhan
(M) 9167594244

On 13-08-2012 15:55, CoRe wrote:

Hello Gunjal ,



Please check the file attached.


My result (excel 2007 or older) : Select all your date , go to Home > 
Sort & Filter > Custom Sort




On Monday, August 13, 2012 1:00:20 PM UTC+3, Pravin Gunjal wrote:

Dear Friends

Greetings for the day!

I have attached herewith one file in which three columns are
there. viz. 1) Doc. No. 2) Doc. Date & 3) Party Name

1) I would like to sort this file as per the serial doc. numbers
but unable to do.  If we do the date wise sorting it takes day
wise only and not as month wise day wise.

2) As we are having some customer data in different excel file and
need to be gathered in a single file.  But we can not do the
v-lookup use directly, as this file is having customer names along
with the places.  And in other file we are having only names
without their places  - At present we are doing it manually like :
we are sorting it customer wise and removing the place by using
edit function for a stockist and using copy-paste for that
particular stockist.

As approximately we are having 98 customers and it is very
difficult to do it manually.

Kindly help me out on this issue.  Thank you.

*With regards,
**Pravin Gunjal**
*

--
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 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum 
in signatures are prohibited.


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.





--
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

2012-08-13 Thread Sundarvelan N

Hello Friends,

Some how i finished my project. Last one help to finish my project.

My task is after i passedcorssed the cell C17 the cursor should go to
update button, please help me as soon as possible.
Thanks
N.Sundarvelan
9600160150



On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon  wrote:

> This looks like school homework to me.  If we do your homework for you,
> you learn nothing.  Use the resource materials you have no doubt been
> given, read the book.  Try to do it yourself - even if you can only do part
> of it.  Than come back to the group to help you with any specific aspect
> that is causing you problems.
>
>
> On 11 August 2012 20:10, Sundarvelan N  wrote:
>
>> Brothers please help me
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>>
>> -- Forwarded message --
>> From: Sundarvelan N 
>> Date: Wed, Aug 8, 2012 at 2:32 PM
>> Subject: Data Entry - Need insert rows when i press enter button
>> To: excel-macros@googlegroups.com
>>
>>
>> Hello Friends,
>>
>> I need to complete a projec. The requirement as follows
>>
>>
>>1. When i press ENTER button in the INPUT sheet the data should add
>>in the DATA sheet
>>2. The cursor should automatically go to the next tex box when i hit
>>enter button
>>
>> I would be thankfull if it is done as soon as possible.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Regards
> David Grugeon
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

2012-08-13 Thread Shekhar Sharma

Hi David,

A sample file has been shared with you

Regards
Shekhar Sharma

On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon  wrote:

> Post a sheet with a sample of the data (at least 20 rows). then we can
> test our formulae.
>
>
> On 8 August 2012 20:35, Shekhar Sharma  wrote:
>
>> Guyz,
>>
>> Can you suggest a VBA code for the same, as I think no formula is working.
>>
>> I have lots of row and multiple of conditions
>>
>> Regards
>> Shekhar Sharma
>>
>>  On Wed, Aug 8, 2012 at 4:03 PM, Shekhar Sharma wrote:
>>
>>> Sorry David,
>>>
>>> Its not working.
>>>
>>>  On Tue, Aug 7, 2012 at 5:58 PM, David Grugeon wrote:
>>>
 =MID(A1&B1&C1,SEARCH("(",A1&B1&C1),SEARCH(")",A1&B1&C1)-SEARCH("(",A1&B1&C1)+1)



 On 7 August 2012 21:45, RAJA SEKAR  wrote:

> Try This
>
> =RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND(")",C1,1),
> LEFT(C1,FIND(")",C1,1)-1),"")
>
>
>
> On 7 August 2012 16:48, Shekhar Sharma  wrote:
>
>> Hi Friends
>>
>> I am struggling with one problem and need your help.
>>
>> I have three columns available like:
>>  *Column A* *Column B* *Column C* 92683 (1 18067.0 1)   (8625.11)
>>
>>
>>
>> 1)  Now I would like to have a formula in Column D where it will
>> check the destination of "(" (if exist) and merge the data coming after 
>> "("
>> (along with "("  from column A) with column B
>>
>>  Column B value should become (118067.0
>>
>> 2)  After this I need a formula in Column E where it will check the
>> destination of ")" (if exist) and merge the data coming before ")" (along
>> with ")" from Column C) with Column D value
>>
>>  Column E should become (118067.01)
>>
>>
>> Note:
>>
>> 1) If "(" is coming in Column A as (92683, formula should update
>> Column D with value as 18067.0
>> 2) if ")" is coming in Column C as 8625.11) formula should update
>> Column E with Value as 18067.0
>> 3) if any VBA code can be built that would be really great otherwise
>> I am ok with formula.
>>
>> --
>> Shekhar Sharma
>> 9910010060
>> "Life consists not in holding good cards but in playing
>> those  you hold well"
>>  "Before you judge another, think of your own last mistake."
>>
>> --
>> 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
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> "Making a million friends is not a miracle, the miracle is to make a
> friend who will stand by you when a million are against you. "
>
>
>
> 
>
>
> Have a Smileness Day
> With A Smile
> Rs.
>
>
>  --
> 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
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post p

$$Excel-Macros$$ FW: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}]

2012-08-13 Thread Azeem Quraishi (HAB5)

From: MS EXCEL AND VBA MACROS [mailto:excel-macros+subconf...@googlegroups.com] 
Sent: Monday, August 13, 2012 11:32 AM
To: Azeem Quraishi (HAB5)
Subject: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}]

We received your request to join excel-macros 
 . 

In order for us to complete the request, please reply to this email or click 
below: 

Join This Group  

Start   your own 
group, visit   the help 
center, or report   
abuse. 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

<<~WRD000.jpg>>

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

$$Excel-Macros$$ I need help on a macro which extracts rows which have a 7 digit number in a column.

$$Excel-Macros$$ macro for detecting date in row

$$Excel-Macros$$ Re: Rek : Need CRM Administrator (Salesforce)

RE: $$Excel-Macros$$ Power pivot

Re: $$Excel-Macros$$ Power pivot

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

Re: $$Excel-Macros$$ Need your help

Re: $$Excel-Macros$$ Need your help

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

Re: $$Excel-Macros$$ Need your help

$$Excel-Macros$$ Re: What is the future of VBA?

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

$$Excel-Macros$$ Power pivot

Re: $$Excel-Macros$$ Need your help

Re: $$Excel-Macros$$ Need your help

$$Excel-Macros$$ Need your help

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

$$Excel-Macros$$ FW: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}]

23 matches

Site Navigation

Mail list logo

Footer information