RE: $$Excel-Macros$$ code

[Mohammed Muneer]

Mr. Noorain excellent! job,

 

Keep it up!

 

Miraculous, I was fed with the previous one whenever I prepared the
monthly reports.

 

Anyway Thanx a lot,

 

 

Praises, Prosperity & Prayers,

Muneer,

CC..

 

 

 

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Thursday, January 19, 2012 8:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ code

 

Dear Muneer,

You can use finally this formula in G1
=LEFT(A1,2)&"."&MID(A1,5,3)&"."&RIGHT(A1,1)
hope it help to you..
otherwise i wll send you macro(VBA Code)..

See attached sheet.
-- 

Thanks & regards,

Noorain Ansari

http://excelmacroworld.blogspot.com/
<http://excelmacroworld.blogspot.com/> 

http://noorain-ansari.blogspot.com/
<http://noorain-ansari.blogspot.com/> 

 

On Thu, Jan 19, 2012 at 9:56 AM, Mohammed Muneer 
wrote:

I want to change this column A to column G (means I want to remove the
additional zero figures from column A),

I have to pass through the cols - B, C, D, E and F.

 

steps involved here are very lengthy!

 

How can I avoid this lengthy process and do it in short!!

Finally I have to do again some manual work in the 'col G'.

 

Plz, help me to come out from this problem.

 

 

Regards,

Muneer,

CC...

 

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ code

[NOORAIN ANSARI]

Most Welcome Muneer..

On Thu, Jan 19, 2012 at 11:20 AM, Mohammed Muneer wrote:

>  Mr. Noorain excellent! job,
>
> ** **
>
> Keep it up!
>
> ** **
>
> Miraculous, I was fed with the previous one whenever I prepared the
> monthly reports.
>
> ** **
>
> Anyway Thanx a lot,
>
> ** **
>
> ** **
>
> Praises, Prosperity & Prayers,
>
> Muneer,
>
> CC..
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>  --
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Thursday, January 19, 2012 8:41 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ code
>
> ** **
>
> Dear Muneer,
>
> You can use finally this formula in G1
> =LEFT(A1,2)&"."&MID(A1,5,3)&"."&RIGHT(A1,1)
> hope it help to you..
> otherwise i wll send you macro(VBA Code)..
>
> See attached sheet.
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> 
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> 
>
> ** **
>
> On Thu, Jan 19, 2012 at 9:56 AM, Mohammed Muneer 
> wrote:
>
> I want to change this column A to column G (means I want to remove the
> additional zero figures from column A),
>
> I have to pass through the cols – B, C, D, E and F.
>
>  
>
> steps involved here are very lengthy!
>
>  
>
> How can I avoid this lengthy process and do it in short!!
>
> Finally I have to do again some manual work in the 'col G'.
>
>  
>
> Plz, help me to come out from this problem.
>
>  
>
>  
>
> Regards,
>
> Muneer,
>
> CC...
>
>  
>
>  
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
> 
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---

RE: $$Excel-Macros$$ code

[Rajan_Verma]

Try this :

=REPLACE(REPLACE(A1,3,2,"."),6,5,".")

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: Jan/Thu/2012 09:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code

 

I want to change this column A to column G (means I want to remove the
additional zero figures from column A),

I have to pass through the cols - B, C, D, E and F.

 

steps involved here are very lengthy!

 

How can I avoid this lengthy process and do it in short!!

Finally I have to do again some manual work in the 'col G'.

 

Plz, help me to come out from this problem.

 

 

Regards,

Muneer,

CC...

 

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ code requried

[Paul Schreiner]

What you're asking is easily done, in hundreds of different ways!
The method you choose depends on your specific conditions and level of 
expertise.Have you done VBA programming before? What have you tried?Does the 
"destination" workbook already have sheets of the same name?Are you ADDING the 
data from the Source workbook to the data in the Destination workbook or 
REPLACING the data?Will there be duplicate records?What do you do with the 
duplicates? 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
- 

On Friday, April 29, 2016 6:12 AM, Izhar  wrote:
 
 

 HI
I need code for a workbook in which I want to take four sheets from another 
workbook


MORE EXPLANATION
If I've a workbook namely "A", in this workbook I've different sheets having 
names like jan, feb, mar etc etc i need another workbook with four months data 
from "A" 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


 
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ code requried

[GENIUS]

first No I have not done vba programming before secondly the destination 
workbook will be new, there is no datasheet in it, just blank sheets as 
usual, third Yes I'm taking the data from the source workbook to the 
destination workbook.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Code Automatically

[Abhishek Jain]

Can you also provide a sample output?

On Tue, Mar 12, 2013 at 11:37 AM, Chaya  wrote:

> Dear Experts,
>
>  Once more help please, i am a new learner in macros, i love it. right now
> i am learning by only recording the macros in excel. even i don't know how
> to declare vaue and solve the query.
>
> Please see the attachment for you ref.
> i have recorded some few macros for my requirement. there i have to click
> manually in order to extract all the coloumns data  one by one, and i have
> more than 6000 columns, its means 6000 time i have to click  the button,
> please amend and add some more code to do automatically, once click it will
> do entire itself.
>  by this i can able to learn how and what is being used in macros coding.
>
> thank you in advance.
>
> Regards,
> Chaya
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Code Automatically

[Chaya]

Yes Sir,
   If you see the attached sheet, there one button is there, please click
on that  and go to second sheet. you will find that every time the datas
are shifting down


-Chaya

On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain wrote:

> Can you also provide a sample output?
>
>
> On Tue, Mar 12, 2013 at 11:37 AM, Chaya  wrote:
>
>> Dear Experts,
>>
>>  Once more help please, i am a new learner in macros, i love it. right
>> now i am learning by only recording the macros in excel. even i don't know
>> how to declare vaue and solve the query.
>>
>> Please see the attachment for you ref.
>> i have recorded some few macros for my requirement. there i have to click
>> manually in order to extract all the coloumns data  one by one, and i have
>> more than 6000 columns, its means 6000 time i have to click  the button,
>> please amend and add some more code to do automatically, once click it will
>> do entire itself.
>>  by this i can able to learn how and what is being used in macros coding.
>>
>> thank you in advance.
>>
>> Regards,
>> Chaya
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Code Automatically

[Abhishek Jain]

I still did not get your query. I have manually done what your code is
doing...the data is shifting down because you added 54 rows there, but
that's not my point of concern.

I also did not understand what you meant by you have to click 6000 times.
All your code is doing is copy and paste. Same values. No changes. Although
you have many different columns but its still difficult to understand your
query.

What I suggest is: give us a complete output sheet that you desire, for all
these columns, and may be we can help you out.

Cheers!

On Tue, Mar 12, 2013 at 12:18 PM, Chaya  wrote:

> Yes Sir,
>If you see the attached sheet, there one button is there, please click
> on that  and go to second sheet. you will find that every time the datas
> are shifting down
>
>
> -Chaya
>
> On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain wrote:
>
>> Can you also provide a sample output?
>>
>>
>> On Tue, Mar 12, 2013 at 11:37 AM, Chaya  wrote:
>>
>>> Dear Experts,
>>>
>>>  Once more help please, i am a new learner in macros, i love it. right
>>> now i am learning by only recording the macros in excel. even i don't know
>>> how to declare vaue and solve the query.
>>>
>>> Please see the attachment for you ref.
>>> i have recorded some few macros for my requirement. there i have to
>>> click manually in order to extract all the coloumns data  one by one, and i
>>> have more than 6000 columns, its means 6000 time i have to click  the
>>> button, please amend and add some more code to do automatically, once click
>>> it will do entire itself.
>>>  by this i can able to learn how and what is being used in macros coding.
>>>
>>> thank you in advance.
>>>
>>> Regards,
>>> Chaya
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Code Automatically

[Chaya]

Awesome Anil sir, as i expected you have solved my query.  Thanks all for
assist.
Thanks once again.

Sir, Can you please explain me your coding. step by step  so that i can
understand:

Dim a As Integer
Set ws = Worksheets("2")
Dim b As String
irow = ws.Cells(Columns.Count).End(xlToLeft).Column - 1
For a = 1 To irow Step 1

.
.

'If a > irow Then
'MsgBox "Successfully Donw", vbInformation, "Anil"
'Else
'End If
Next a

-Chaya

On Tue, Mar 12, 2013 at 12:44 PM, अनिल नारायण गवली
wrote:

> Dear Chaya,
>
> Pl find attached herewith.
>
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Mar 12, 2013 at 12:18 PM, Chaya  wrote:
>
>> Yes Sir,
>>If you see the attached sheet, there one button is there, please click
>> on that  and go to second sheet. you will find that every time the datas
>> are shifting down
>>
>>
>> -Chaya
>>
>> On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain 
>> wrote:
>>
>>> Can you also provide a sample output?
>>>
>>>
>>> On Tue, Mar 12, 2013 at 11:37 AM, Chaya  wrote:
>>>
 Dear Experts,

  Once more help please, i am a new learner in macros, i love it. right
 now i am learning by only recording the macros in excel. even i don't know
 how to declare vaue and solve the query.

 Please see the attachment for you ref.
 i have recorded some few macros for my requirement. there i have to
 click manually in order to extract all the coloumns data  one by one, and i
 have more than 6000 columns, its means 6000 time i have to click  the
 button, please amend and add some more code to do automatically, once click
 it will do entire itself.
  by this i can able to learn how and what is being used in macros
 coding.

 thank you in advance.

 Regards,
 Chaya

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 

Re: $$Excel-Macros$$ Code Help

[Mahesh parab]

Hi Nikhil

Insert this code in a standard module

Function FirstLetters(rng As Range) As String
Dim arrWords
Dim I As Long
arrWords = Split(rng, " ")

If IsArray(arrWords) Then
For I = LBound(arrWords) To UBound(arrWords)
FirstLetters = FirstLetters & Left(arrWords(I), 1)
Next I
Else
FirstLetters = Left(arrWords, 1)
End If

End Function

find info on below link
http://www.ozgrid.com/forum/showthread.php?t=50353

On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah  wrote:

> Hi Friends,
>
> In Column " A " .. I have written --- > Vishal Pravinchandra Shah .
>
> Now I want
>
> In Column " B " should be VPSautomatically..I want Formula
>
> I want First Letter Of First Name ; First Letter Of Middle Name ; First
> Letter Of Last Name in one column..
>
> Awaiting Reply..
>
> Thanks
> Nikhil
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code Help

[Mithlesh Sharma]

Hi Nikhil,

Try this one, will give result in VPS.

Vishal Pravinchandra Shah

=LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND("
",A1,1)+1)+1,1)


Regards,

Mithlesh Sharma

On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah  wrote:

> Hi Friends,
>
> In Column " A " .. I have written --- > Vishal Pravinchandra Shah .
>
> Now I want
>
> In Column " B " should be VPSautomatically..I want Formula
>
> I want First Letter Of First Name ; First Letter Of Middle Name ; First
> Letter Of Last Name in one column..
>
> Awaiting Reply..
>
> Thanks
> Nikhil
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code Help

[Nikhil Shah]

Hi Mithlesh,

Thanks for sending formula..it solve my problem..

Regards
Nikhil


On Mon, Aug 9, 2010 at 12:15 AM, Mithlesh Sharma wrote:

> Hi Nikhil,
>
> Try this one, will give result in VPS.
>
> Vishal Pravinchandra Shah
>
> =LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND("
> ",A1,1)+1)+1,1)
>
>
> Regards,
>
> Mithlesh Sharma
>
> On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah wrote:
>
>> Hi Friends,
>>
>> In Column " A " .. I have written --- > Vishal Pravinchandra Shah .
>>
>> Now I want
>>
>> In Column " B " should be VPSautomatically..I want Formula
>>
>> I want First Letter Of First Name ; First Letter Of Middle Name ; First
>> Letter Of Last Name in one column..
>>
>> Awaiting Reply..
>>
>> Thanks
>> Nikhil
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code Problem

[Paul Schreiner]

You really should use a better subject.
just about everyone who posts here has a "code problem"
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.

Some people here are EXPERTS in the use of pivot tables.
Others are great with accessing specific databases,
or in emailing workbooks.

If your problem relates to one of these topics, you want these experts
to spot your question and jump right in.

As presented, your question requires research on our part before we
even know if we have the expertise (or interest) in helping.

And really, if the person you want to give you assistance only has 10 minutes
to share, you don't want him/her spending 9 of those minutes trying to decide
if your question is in his area of expertise.

As it is... you question is why the code:
Workbooks.Open ("D:\12-13\book2.xls")

only works on one PC, and not the others.

My guess is that the other PC's do not have their D:\ drive is mapped the same 
as the first PC.

If you cannot go the machine in person and look for yourself,
I'd suggest send a link to the folder and see if they can open it.

Another item that's somewhat suspicious...
In nearly all of the PC's in my business (2,000 of them) and each of the (4) of 
my machines at home,
the C:\ is the internal hard drive, and D:\ drive is a CD drive or a second 
hard 
drive.
I believe Windows, by default, reserves the D:\ drive for use for removeable 
media.

I find the use here as "suspicious".

I'd say, go to the machines and check it out.

 
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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 9:41:10 AM
Subject: $$Excel-Macros$$ Code Problem


please guide me in my attachment file problem
 
Regards
 
Sajid 
-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

RE: $$Excel-Macros$$ Code Problem

[SAJID MEMON]

Dear My first machine name is Lenovo, 2nd name is Hp, & third name id Dell. in 
all the machines D:\ drives is there, same path.
Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or 
\\dell\d\12-13\book1.xls
Programe is installed only in lenovo, i want to excess it from hp or from dell.
please suggest me.
 
Awaiting 
sajid

 



Date: Mon, 12 Nov 2012 07:05:15 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com






You really should use a better subject.
just about everyone who posts here has a "code problem"
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.
 
Some people here are EXPERTS in the use of pivot tables.
Others are great with accessing specific databases,
or in emailing workbooks.
 
If your problem relates to one of these topics, you want these experts
to spot your question and jump right in.
 
As presented, your question requires research on our part before we
even know if we have the expertise (or interest) in helping.
 
And really, if the person you want to give you assistance only has 10 minutes
to share, you don't want him/her spending 9 of those minutes trying to decide
if your question is in his area of expertise.
 
As it is... you question is why the code:
Workbooks.Open ("D:\12-13\book2.xls")
 
only works on one PC, and not the others.
 
My guess is that the other PC's do not have their D:\ drive is mapped the same 
as the first PC.
 
If you cannot go the machine in person and look for yourself,
I'd suggest send a link to the folder and see if they can open it.
 
Another item that's somewhat suspicious...
In nearly all of the PC's in my business (2,000 of them) and each of the (4) of 
my machines at home,
the C:\ is the internal hard drive, and D:\ drive is a CD drive or a second 
hard drive.
I believe Windows, by default, reserves the D:\ drive for use for removeable 
media.
 
I find the use here as "suspicious".
 
I'd say, go to the machines and check it out.

 
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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 9:41:10 AM
Subject: $$Excel-Macros$$ Code Problem




please guide me in my attachment file problem
 
Regards
 
Sajid 

-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
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.

Re: $$Excel-Macros$$ Code Problem

[vba]

Hi,

You can access by this way also but for this to be worked your D drive should 
be shared.

Cheerz..

Sent on my BlackBerry® from Vodafone

-Original Message-
From: SAJID MEMON 
Sender: excel-macros@googlegroups.com
Date: Tue, 13 Nov 2012 04:12:48 
To: Sundarvelan Natarajan
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Code Problem


Dear My first machine name is Lenovo, 2nd name is Hp, & third name id Dell. in 
all the machines D:\ drives is there, same path.
Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or 
\\dell\d\12-13\book1.xls
Programe is installed only in lenovo, i want to excess it from hp or from dell.
please suggest me.
 
Awaiting 
sajid

 



Date: Mon, 12 Nov 2012 07:05:15 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com






You really should use a better subject.
just about everyone who posts here has a "code problem"
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.
 
Some people here are EXPERTS in the use of pivot tables.
Others are great with accessing specific databases,
or in emailing workbooks.
 
If your problem relates to one of these topics, you want these experts
to spot your question and jump right in.
 
As presented, your question requires research on our part before we
even know if we have the expertise (or interest) in helping.
 
And really, if the person you want to give you assistance only has 10 minutes
to share, you don't want him/her spending 9 of those minutes trying to decide
if your question is in his area of expertise.
 
As it is... you question is why the code:
Workbooks.Open ("D:\12-13\book2.xls")
 
only works on one PC, and not the others.
 
My guess is that the other PC's do not have their D:\ drive is mapped the same 
as the first PC.
 
If you cannot go the machine in person and look for yourself,
I'd suggest send a link to the folder and see if they can open it.
 
Another item that's somewhat suspicious...
In nearly all of the PC's in my business (2,000 of them) and each of the (4) of 
my machines at home,
the C:\ is the internal hard drive, and D:\ drive is a CD drive or a second 
hard drive.
I believe Windows, by default, reserves the D:\ drive for use for removeable 
media.
 
I find the use here as "suspicious".
 
I'd say, go to the machines and check it out.

 
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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 9:41:10 AM
Subject: $$Excel-Macros$$ Code Problem




please guide me in my attachment file problem
 
Regards
 
Sajid 

-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
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/pir

RE: $$Excel-Macros$$ Code Problem

[SAJID MEMON]

I have shared it but it not open from other PC except main (Lenovo)

 



Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com
From: v...@vabs.in
Date: Tue, 13 Nov 2012 04:56:33 +



Hi,

You can access by this way also but for this to be worked your D drive should 
be shared.

Cheerz..

Sent on my BlackBerry® from Vodafone


From: SAJID MEMON  
Sender: excel-macros@googlegroups.com 
Date: Tue, 13 Nov 2012 04:12:48 +
To: Sundarvelan Natarajan
ReplyTo: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ Code Problem


Dear My first machine name is Lenovo, 2nd name is Hp, & third name id Dell. in 
all the machines D:\ drives is there, same path.
Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or 
\\dell\d\12-13\book1.xls
Programe is installed only in lenovo, i want to excess it from hp or from dell.
please suggest me.
 
Awaiting 
sajid

 




Date: Mon, 12 Nov 2012 07:05:15 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com






You really should use a better subject.
just about everyone who posts here has a "code problem"
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.
 
Some people here are EXPERTS in the use of pivot tables.
Others are great with accessing specific databases,
or in emailing workbooks.
 
If your problem relates to one of these topics, you want these experts
to spot your question and jump right in.
 
As presented, your question requires research on our part before we
even know if we have the expertise (or interest) in helping.
 
And really, if the person you want to give you assistance only has 10 minutes
to share, you don't want him/her spending 9 of those minutes trying to decide
if your question is in his area of expertise.
 
As it is... you question is why the code:
Workbooks.Open ("D:\12-13\book2.xls")
 
only works on one PC, and not the others.
 
My guess is that the other PC's do not have their D:\ drive is mapped the same 
as the first PC.
 
If you cannot go the machine in person and look for yourself,
I'd suggest send a link to the folder and see if they can open it.
 
Another item that's somewhat suspicious...
In nearly all of the PC's in my business (2,000 of them) and each of the (4) of 
my machines at home,
the C:\ is the internal hard drive, and D:\ drive is a CD drive or a second 
hard drive.
I believe Windows, by default, reserves the D:\ drive for use for removeable 
media.
 
I find the use here as "suspicious".
 
I'd say, go to the machines and check it out.

 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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 9:41:10 AM
Subject: $$Excel-Macros$$ Code Problem




please guide me in my attachment file problem
 
Regards
 
Sajid 

-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
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 

Re: $$Excel-Macros$$ Code Problem

[अनिल नारायण गवली]

Dear Sajid,

first see that from different pc can you access manually to that folder
then see the details (the address) and confirm.

Regards,
Gawli Anil

On Tue, Nov 13, 2012 at 2:50 PM, SAJID MEMON  wrote:

>  I have shared it but it not open from other PC except main (Lenovo)
>
>
>  --
> Subject: Re: $$Excel-Macros$$ Code Problem
> To: excel-macros@googlegroups.com
> From: v...@vabs.in
> Date: Tue, 13 Nov 2012 04:56:33 +
>
>
> Hi,
>
> You can access by this way also but for this to be worked your D drive
> should be shared.
>
> Cheerz..
> Sent on my BlackBerry® from Vodafone
> --
> *From: *SAJID MEMON 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Tue, 13 Nov 2012 04:12:48 +
> *To: *Sundarvelan Natarajan
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *RE: $$Excel-Macros$$ Code Problem
>
> Dear My first machine name is Lenovo, 2nd name is Hp, & third name id
> Dell. in all the machines D:\ drives is there, same path.
> Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or
> \\dell\d\12-13\book1.xls
> Programe is installed only in lenovo, i want to excess it from hp or from
> dell.
> please suggest me.
>
> Awaiting
> sajid
>
>
>  ----------
> Date: Mon, 12 Nov 2012 07:05:15 -0800
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Code Problem
> To: excel-macros@googlegroups.com
>
>  You really should use a better subject.
> just about everyone who posts here has a "code problem"
> You have not provided any indication either in the subject, or the body
> of your post as to what your problem is, or even the area of the problem.
>
> Some people here are EXPERTS in the use of pivot tables.
> Others are great with accessing specific databases,
> or in emailing workbooks.
>
> If your problem relates to one of these topics, you want these experts
> to spot your question and jump right in.
>
> As presented, your question requires research on our part before we
> even know if we have the expertise (or interest) in helping.
>
> And really, if the person you want to give you assistance only has 10
> minutes
> to share, you don't want him/her spending 9 of those minutes trying to
> decide
> if your question is in his area of expertise.
>
> As it is... you question is why the code:
> Workbooks.Open ("D:\12-13\book2.xls")
>
> only works on one PC, and not the others.
>
> My guess is that the other PC's do not have their D:\ drive is mapped the
> same as the first PC.
>
> If you cannot go the machine in person and look for yourself,
> I'd suggest send a link to the folder and see if they can open it.
>
> Another item that's somewhat suspicious...
> In nearly all of the PC's in my business (2,000 of them) and each of the
> (4) of my machines at home,
> the C:\ is the internal hard drive, and D:\ drive is a CD drive or a
> second hard drive.
> I believe Windows, by default, reserves the D:\ drive for use for
> removeable media.
>
> I find the use here as "suspicious".
>
> I'd say, go to the machines and check it out.
>
>
> *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:* SAJID MEMON 
> *To:* Sundarvelan Natarajan 
> *Sent:* Mon, November 12, 2012 9:41:10 AM
> *Subject:* $$Excel-Macros$$ Code Problem
>
> please guide me in my attachment file problem
>
> Regards
>
> Sajid
>
> --
> 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
&

Re: $$Excel-Macros$$ Code Problem

[अनिल नारायण गवली]

Dear Sajid,

Just see if the extention is xls or xlsx or xlsm.
and confirm

Thanks & Regards
Gawli Anil

On Tue, Nov 13, 2012 at 2:57 PM, अनिल नारायण गवली
wrote:

> Dear Sajid,
>
> first see that from different pc can you access manually to that folder
> then see the details (the address) and confirm.
>
> Regards,
> Gawli Anil
>
> On Tue, Nov 13, 2012 at 2:50 PM, SAJID MEMON wrote:
>
>>  I have shared it but it not open from other PC except main (Lenovo)
>>
>>
>>  ------
>> Subject: Re: $$Excel-Macros$$ Code Problem
>> To: excel-macros@googlegroups.com
>> From: v...@vabs.in
>> Date: Tue, 13 Nov 2012 04:56:33 +
>>
>>
>> Hi,
>>
>> You can access by this way also but for this to be worked your D drive
>> should be shared.
>>
>> Cheerz..
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: *SAJID MEMON 
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Tue, 13 Nov 2012 04:12:48 +
>> *To: *Sundarvelan Natarajan
>> *ReplyTo: *excel-macros@googlegroups.com
>> *Subject: *RE: $$Excel-Macros$$ Code Problem
>>
>> Dear My first machine name is Lenovo, 2nd name is Hp, & third name id
>> Dell. in all the machines D:\ drives is there, same path.
>> Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or
>> \\dell\d\12-13\book1.xls
>> Programe is installed only in lenovo, i want to excess it from hp or from
>> dell.
>> please suggest me.
>>
>> Awaiting
>> sajid
>>
>>
>>  --
>> Date: Mon, 12 Nov 2012 07:05:15 -0800
>> From: schreiner_p...@att.net
>> Subject: Re: $$Excel-Macros$$ Code Problem
>> To: excel-macros@googlegroups.com
>>
>>  You really should use a better subject.
>> just about everyone who posts here has a "code problem"
>> You have not provided any indication either in the subject, or the body
>> of your post as to what your problem is, or even the area of the problem.
>>
>> Some people here are EXPERTS in the use of pivot tables.
>> Others are great with accessing specific databases,
>> or in emailing workbooks.
>>
>> If your problem relates to one of these topics, you want these experts
>> to spot your question and jump right in.
>>
>> As presented, your question requires research on our part before we
>> even know if we have the expertise (or interest) in helping.
>>
>> And really, if the person you want to give you assistance only has 10
>> minutes
>> to share, you don't want him/her spending 9 of those minutes trying to
>> decide
>> if your question is in his area of expertise.
>>
>> As it is... you question is why the code:
>> Workbooks.Open ("D:\12-13\book2.xls")
>>
>> only works on one PC, and not the others.
>>
>> My guess is that the other PC's do not have their D:\ drive is mapped the
>> same as the first PC.
>>
>> If you cannot go the machine in person and look for yourself,
>> I'd suggest send a link to the folder and see if they can open it.
>>
>> Another item that's somewhat suspicious...
>> In nearly all of the PC's in my business (2,000 of them) and each of the
>> (4) of my machines at home,
>> the C:\ is the internal hard drive, and D:\ drive is a CD drive or a
>> second hard drive.
>> I believe Windows, by default, reserves the D:\ drive for use for
>> removeable media.
>>
>> I find the use here as "suspicious".
>>
>> I'd say, go to the machines and check it out.
>>
>>
>> *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:* SAJID MEMON 
>> *To:* Sundarvelan Natarajan 
>> *Sent:* Mon, November 12, 2012 9:41:10 AM
>> *Subject:* $$Excel-Macros$$ Code Problem
>>
>> please guide me in my attachment file problem
>>
>> Regards
>>
>> Sajid
>>
>> --
>> 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
>> H

Re: $$Excel-Macros$$ Code Problem

[Paul Schreiner]

I'm sorry.. I need clarification.
You said on each of the machines, the "D:\ drive is there, same path"

So, you're saying that if you sit at ANY of the machines,
you can use Windows Explorer and navigate to the 
D:\12-13 folder and the book2.xls file is there, right?

And you can open it?
 


In answer to your question about using \\Lenovo\d\...
the answer is "no".

IF you've shared your pc through your Network manager (which is not common)
then you MAY be able to navigate to a drive attached to another machine.
But there's lots of network security that has to be set up to do so.
It's not very common..


---
On your PC, where is the D:\ physically located?
Is it a local drive or is it on a Local Area Network?
If you look at "My Computer", where does it show the D:\ drive is mapped?

(can you send a screen shot of your My Computer screen?)
 
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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 11:13:02 PM
Subject: RE: $$Excel-Macros$$ Code Problem


Dear My first machine name is Lenovo, 2nd name is Hp, & third name id Dell. in 
all the machines D:\ drives is there, same path.
Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or 
\\dell\d\12-13\book1.xls
Programe is installed only in lenovo, i want to excess it from hp or from dell.
please suggest me.
 
Awaiting 
sajid

 



Date: Mon, 12 Nov 2012 07:05:15 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Code Problem
To: excel-macros@googlegroups.com


You really should use a better subject.
just about everyone who posts here has a "code problem"
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.

Some people here are EXPERTS in the use of pivot tables.
Others are great with accessing specific databases,
or in emailing workbooks.

If your problem relates to one of these topics, you want these experts
to spot your question and jump right in.

As presented, your question requires research on our part before we
even know if we have the expertise (or interest) in helping.

And really, if the person you want to give you assistance only has 10 minutes
to share, you don't want him/her spending 9 of those minutes trying to decide
if your question is in his area of expertise.

As it is... you question is why the code:
Workbooks.Open ("D:\12-13\book2.xls")

only works on one PC, and not the others.

My guess is that the other PC's do not have their D:\ drive is mapped the same 
as the first PC.

If you cannot go the machine in person and look for yourself,
I'd suggest send a link to the folder and see if they can open it.

Another item that's somewhat suspicious...
In nearly all of the PC's in my business (2,000 of them) and each of the (4) of 
my machines at home,
the C:\ is the internal hard drive, and D:\ drive is a CD drive or a second 
hard 
drive.
I believe Windows, by default, reserves the D:\ drive for use for removeable 
media.

I find the use here as "suspicious".

I'd say, go to the machines and check it out.

 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: SAJID MEMON 
To: Sundarvelan Natarajan 
Sent: Mon, November 12, 2012 9:41:10 AM
Subject: $$Excel-Macros$$ Code Problem


please guide me in my attachment file problem
 
Regards
 
Sajid 

-- 
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 messa

Re: $$Excel-Macros$$ CODE FOR RANGE

[Paul Schreiner]

In your macro:Sub sbCompareColumns_2()
    iCntr = 1
    Do While Cells(iCntr, 1) <> ""
    If UCase(Cells(iCntr, 1)) = UCase(Cells(iCntr, 2)) Then
    Cells(iCntr, 3) = "Matched"
    Else
    Cells(iCntr, 3) = "Not Matched"
    End If
    iCntr = iCntr + 1
    Loop
End Sub
the Cells() function syntax is:Cells(Row,Column)
So, when you set iCntr = 1and use it in: Do While Cells(iCntr, 1) <> ""
the Do...Loop starts with row 1 in column 1 (A) and continues until the cell in 
column A is blank.
so, if you want to start the loop at row 12, simply change the iCntr to 12:
iCntr = 12

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
- 

On Friday, October 20, 2017 3:43 AM, Izhar  wrote:
 

 If I change the location of the data as shown in A12:B16, then where should I 
change the code, please do the needful
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ CODE FOR RANGE

[GENIUS]

Thanks for your help

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Code User Laval

[SUMIT VYAS]

Dear Madhu

This Sheet Not A Formulas V Lookup  Ok




On Wed, Jan 6, 2010 at 8:17 PM, madhu nair  wrote:

> Hi SUmit,
>
> I added Vlookup, i think thats what you need, check attached sheet,
>
> On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS  wrote:
>
>> Dear,
>>
>> I Make Some Excel Code User Lavel Setting Ags Report.
>>
>> Please Check & Modify Report
>>
>> Please Talk Any Problem.
>>
>> I Wating Your Reply .
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us in TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
>
>
> --
> Thanks,
>
> Madhu Nair
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code User Laval

[ankur]

hi sumit
please  tell me your requiremnet

On 1/7/10, SUMIT VYAS  wrote:
> Dear Madhu
>
> This Sheet Not A Formulas V Lookup  Ok
>
>
>
>
> On Wed, Jan 6, 2010 at 8:17 PM, madhu nair  wrote:
>
>> Hi SUmit,
>>
>> I added Vlookup, i think thats what you need, check attached sheet,
>>
>> On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS  wrote:
>>
>>> Dear,
>>>
>>> I Make Some Excel Code User Lavel Setting Ags Report.
>>>
>>> Please Check & Modify Report
>>>
>>> Please Talk Any Problem.
>>>
>>> I Wating Your Reply .
>>>
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us in TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain  @ jainayus...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Madhu Nair
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us in TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
>


-- 
Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code User Laval

[SUMIT VYAS]

Dear Ankur,

Thanks For Your Reply

I want Make Excel Advance Lavel

I show Code

But I Hide Code This List No Report Gen rate

I want Milty User Working This Excel Report Gen rate One Time .



On Thu, Jan 7, 2010 at 11:47 AM, ankur  wrote:

> hi sumit
> please  tell me your requiremnet
>
> On 1/7/10, SUMIT VYAS  wrote:
> > Dear Madhu
> >
> > This Sheet Not A Formulas V Lookup  Ok
> >
> >
> >
> >
> > On Wed, Jan 6, 2010 at 8:17 PM, madhu nair  wrote:
> >
> >> Hi SUmit,
> >>
> >> I added Vlookup, i think thats what you need, check attached sheet,
> >>
> >> On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS  wrote:
> >>
> >>> Dear,
> >>>
> >>> I Make Some Excel Code User Lavel Setting Ags Report.
> >>>
> >>> Please Check & Modify Report
> >>>
> >>> Please Talk Any Problem.
> >>>
> >>> I Wating Your Reply .
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>>
> >>>
> --
> >>> Some important links for excel users:
> >>> 1. Follow us in TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >>> http://www.excelitems.com
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>>
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>> If you find any spam message in the group, please send an email to:
> >>> Ayush Jain  @ jainayus...@gmail.com
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> HELP US GROW !!
> >>>
> >>> We reach over 6,500 subscribers worldwide and receive many nice notes
> >>> about the learning and support from the group.Let friends and
> co-workers
> >>> know they can subscribe to group at
> >>> http://groups.google.com/group/excel-macros/subscribe
> >>>
> >>>
> >>
> >>
> >> --
> >> Thanks,
> >>
> >> Madhu Nair
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us in TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >> http://www.excelitems.com
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >> If you find any spam message in the group, please send an email to:
> >> Ayush Jain  @ jainayus...@gmail.com
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 6,500 subscribers worldwide and receive many nice notes
> >> about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >>
> >>
> >
>
>
> --
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive ma

Re: $$Excel-Macros$$ Code User Laval

[Chanti-Hyderabad]

Hi Ankur,

That working file looks awesomebut i cant see see any data on 'New
Data' sheet. Is there a way i can see the data change according to my
requirement?

Thanks in Advance,
Ramesh

On Jan 7, 4:33 pm, ankur  wrote:
> hi sumit
>
> please check the attached file
>
> if any other modification needed?
>
> thanks
>
> On 1/7/10, SUMIT VYAS  wrote:
>
>
>
> > Dear Ankur,
>
> > Thanks For Your Reply
>
> > I want Make Excel Advance Lavel
>
> > I show Code
>
> > But I Hide Code This List No Report Gen rate
>
> > I want Milty User Working This Excel Report Gen rate One Time .
>
> > On Thu, Jan 7, 2010 at 11:47 AM, ankur  wrote:
>
> >> hi sumit
> >> please  tell me your requiremnet
>
> >> On 1/7/10, SUMIT VYAS  wrote:
> >> > Dear Madhu
>
> >> > This Sheet Not A Formulas V Lookup  Ok
>
> >> > On Wed, Jan 6, 2010 at 8:17 PM, madhu nair  wrote:
>
> >> >> Hi SUmit,
>
> >> >> I added Vlookup, i think thats what you need, check attached sheet,
>
> >> >> On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS  wrote:
>
> >> >>> Dear,
>
> >> >>> I Make Some Excel Code User Lavel Setting Ags Report.
>
> >> >>> Please Check & Modify Report
>
> >> >>> Please Talk Any Problem.
>
> >> >>> I Wating Your Reply .
>
> >> >>> --
>
> >> --
> >> >>> Some important links for excel users:
> >> >>> 1. Follow us in TWITTER for tips tricks and links :
> >> >>>http://twitter.com/exceldailytip
> >> >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >> >>>http://www.excelitems.com
> >> >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> >>> To post to this group, send email to excel-macros@googlegroups.com
> >> >>> If you find any spam message in the group, please send an email to:
> >> >>> Ayush Jain  @ jainayus...@gmail.com
> >> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >> >>> HELP US GROW !!
>
> >> >>> We reach over 6,500 subscribers worldwide and receive many nice notes
> >> >>> about the learning and support from the group.Let friends and
> >> co-workers
> >> >>> know they can subscribe to group at
> >> >>>http://groups.google.com/group/excel-macros/subscribe
>
> >> >> --
> >> >> Thanks,
>
> >> >> Madhu Nair
>
> >> >> --
>
> >> --
> >> >> Some important links for excel users:
> >> >> 1. Follow us in TWITTER for tips tricks and links :
> >> >>http://twitter.com/exceldailytip
> >> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >> >>http://www.excelitems.com
> >> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> >> To post to this group, send email to excel-macros@googlegroups.com
> >> >> If you find any spam message in the group, please send an email to:
> >> >> Ayush Jain  @ jainayus...@gmail.com
> >> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> >> HELP US GROW !!
>
> >> >> We reach over 6,500 subscribers worldwide and receive many nice notes
> >> >> about
> >> >> the learning and support from the group.Let friends and co-workers know
> >> >> they
> >> >> can subscribe to group at
> >> >>http://groups.google.com/group/excel-macros/subscribe
>
> >> --
> >> Have A Nice Time & Enjoy Life
>
> >> Regards:
> >> CMA Ankur Pandey
> >> (Someone Different)
>
> >> I'm not the best but i'm not like the rest~~
>
> >> --
>
> >> --
> >> Some important links for excel users:
> >> 1. Follow us in TWITTER for tips tricks and links :
> >>http://twitter.com/exceldailytip
> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >>http://www.excelitems.com
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >> If you find any spam message in the group, please send an email to:
> >> Ayush Jain  @ jainayus...@gmail.com
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
>
> >> We reach over 6,500 subscribers worldwide and receive many nice notes
> >> about
> >> the learning and support from the group.Let friends and co-workers know
> >> they
> >> can subscribe to group at
> >>http://groups.google.com/group/excel-macros/subscribe
>
> --
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>  New Reportin By Ankur Pandey..xlsx
> 122KViewDownload
-- 
--
Some impor

Re: $$Excel-Macros$$ Code User Laval

[SUMIT VYAS]

GREAT ANKUR

On Sat, Jan 9, 2010 at 10:32 AM, ankur  wrote:

> hi ramesh
>
> please check this file
>
>
> On 1/8/10, Chanti-Hyderabad  wrote:
> > Hi Ankur,
> >
> > That working file looks awesomebut i cant see see any data on 'New
> > Data' sheet. Is there a way i can see the data change according to my
> > requirement?
> >
> > Thanks in Advance,
> > Ramesh
> >
> > On Jan 7, 4:33 pm, ankur  wrote:
> >> hi sumit
> >>
> >> please check the attached file
> >>
> >> if any other modification needed?
> >>
> >> thanks
> >>
> >> On 1/7/10, SUMIT VYAS  wrote:
> >>
> >>
> >>
> >> > Dear Ankur,
> >>
> >> > Thanks For Your Reply
> >>
> >> > I want Make Excel Advance Lavel
> >>
> >> > I show Code
> >>
> >> > But I Hide Code This List No Report Gen rate
> >>
> >> > I want Milty User Working This Excel Report Gen rate One Time .
> >>
> >> > On Thu, Jan 7, 2010 at 11:47 AM, ankur 
> wrote:
> >>
> >> >> hi sumit
> >> >> please  tell me your requiremnet
> >>
> >> >> On 1/7/10, SUMIT VYAS  wrote:
> >> >> > Dear Madhu
> >>
> >> >> > This Sheet Not A Formulas V Lookup  Ok
> >>
> >> >> > On Wed, Jan 6, 2010 at 8:17 PM, madhu nair 
> >> >> > wrote:
> >>
> >> >> >> Hi SUmit,
> >>
> >> >> >> I added Vlookup, i think thats what you need, check attached
> sheet,
> >>
> >> >> >> On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS 
> >> >> >> wrote:
> >>
> >> >> >>> Dear,
> >>
> >> >> >>> I Make Some Excel Code User Lavel Setting Ags Report.
> >>
> >> >> >>> Please Check & Modify Report
> >>
> >> >> >>> Please Talk Any Problem.
> >>
> >> >> >>> I Wating Your Reply .
> >>
> >> >> >>> --
> >>
> >> >>
> --
> >> >> >>> Some important links for excel users:
> >> >> >>> 1. Follow us in TWITTER for tips tricks and links :
> >> >> >>>http://twitter.com/exceldailytip
> >> >> >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins
> downloads
> >> >> >>> at
> >> >> >>>http://www.excelitems.com
> >> >> >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> >> >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> >> >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >>
> >> >> >>> To post to this group, send email to
> excel-macros@googlegroups.com
> >> >> >>> If you find any spam message in the group, please send an email
> to:
> >> >> >>> Ayush Jain  @ jainayus...@gmail.com
> >> >> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >> >> >>> HELP US GROW !!
> >>
> >> >> >>> We reach over 6,500 subscribers worldwide and receive many nice
> >> >> >>> notes
> >> >> >>> about the learning and support from the group.Let friends and
> >> >> co-workers
> >> >> >>> know they can subscribe to group at
> >> >> >>>http://groups.google.com/group/excel-macros/subscribe
> >>
> >> >> >> --
> >> >> >> Thanks,
> >>
> >> >> >> Madhu Nair
> >>
> >> >> >> --
> >>
> >> >>
> --
> >> >> >> Some important links for excel users:
> >> >> >> 1. Follow us in TWITTER for tips tricks and links :
> >> >> >>http://twitter.com/exceldailytip
> >> >> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads
> >> >> >> at
> >> >> >>http://www.excelitems.com
> >> >> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> >> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> >> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >>
> >> >> >> To post to this group, send email to
> excel-macros@googlegroups.com
> >> >> >> If you find any spam message in the group, please send an email
> to:
> >> >> >> Ayush Jain  @ jainayus...@gmail.com
> >> >> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> >> >> HELP US GROW !!
> >>
> >> >> >> We reach over 6,500 subscribers worldwide and receive many nice
> >> >> >> notes
> >> >> >> about
> >> >> >> the learning and support from the group.Let friends and co-workers
> >> >> >> know
> >> >> >> they
> >> >> >> can subscribe to group at
> >> >> >>http://groups.google.com/group/excel-macros/subscribe
> >>
> >> >> --
> >> >> Have A Nice Time & Enjoy Life
> >>
> >> >> Regards:
> >> >> CMA Ankur Pandey
> >> >> (Someone Different)
> >>
> >> >> I'm not the best but i'm not like the rest~~
> >>
> >> >> --
> >>
> >> >>
> --
> >> >> Some important links for excel users:
> >> >> 1. Follow us in TWITTER for tips tricks and links :
> >> >>http://twitter.com/exceldailytip
> >> >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >> >>http://www.excelitems.com
> >> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >>
> >> >> To post to this group, send email to excel-macros@googlegroups.com
> >> >> If you find any spam message in the group, please send an email to:
> >> >> Ay

RE: $$Excel-Macros$$ CODE DOESN'T WORK

[Daniel]

Hello, 

What is not working ? Do you get an error ?

What are you trying to do ?

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de rakesh kumar
Envoyé : dimanche 20 février 2011 11:16
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ CODE DOESN'T WORK

 

Hi Dearests,

 

Could anyone help me and make the below code work  ?

 

Dim GetVarCounts As Integer

Dim ColName As Integer, RowCounter As Integer

Dim oRg As Range

 

 

RowCounter = 1

 

For ColName = 1 To 750

 

If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter,
1) Then

Sheets("1").Cells(1, ColName) = 1

RowCounter = RowCounter + 1

Else

Sheets("1").Cells(1, ColName) = 0

End If

'Application.ScreenUpdating = False

Next ColName

 

RowCounter = 1

For Each c In Worksheets("1").Range("A1:a750").Cells

If c.Value = 0 Then

Columns(RowCounter).EntireColumn.Delete

End If

RowCounter = RowCounter + 1

Next

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ CODE DOESN'T WORK

[rakesh kumar]

*thanks Daniel Ji for the reply... here what I need and what the code
doesn't do.*
*
*
*This code runs as long as the Sheets("1").Cells(2, ColNumber) =
Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some data
with a lot of variables in sheet "1" of which I need few variable listed in
Sheet "Name" Column A. I want to delete all column from Sheet 1 which
doesn't match with variable listed in Sheet "Name" Column A.*
*
*
*Thanks *

On Sun, Feb 20, 2011 at 6:39 PM, Daniel  wrote:

> Hello,
>
> What is not working ? Do you get an error ?
>
> What are you trying to do ?
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* rakesh kumar
> *Envoyé :* dimanche 20 février 2011 11:16
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ CODE DOESN'T WORK
>
>
>
> Hi Dearests,
>
>
>
> Could anyone help me and make the below code work  ?
>
>
>
> Dim GetVarCounts As Integer
>
> Dim ColName As Integer, RowCounter As Integer
>
> Dim oRg As Range
>
>
>
>
>
> RowCounter = 1
>
>
>
> For ColName = 1 To 750
>
>
>
> If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter,
> 1) Then
>
> Sheets("1").Cells(1, ColName) = 1
>
> RowCounter = RowCounter + 1
>
> Else
>
> Sheets("1").Cells(1, ColName) = 0
>
> End If
>
> 'Application.ScreenUpdating = False
>
> Next ColName
>
>
>
> RowCounter = 1
>
> For Each c In Worksheets("1").Range("A1:a750").Cells
>
> If c.Value = 0 Then
>
> Columns(RowCounter).EntireColumn.Delete
>
> End If
>
> RowCounter = RowCounter + 1
>
> Next
>
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
  Rakesh kumar khowal
 +91 9540084660
 +91 9868532105

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ CODE DOESN'T WORK

[Daniel]

The code is correct. Simply, there is no match and the test is always false.
Can you post your data ?

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de rakesh kumar
Envoyé : dimanche 20 février 2011 21:35
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ CODE DOESN'T WORK

 

thanks Daniel Ji for the reply... here what I need and what the code doesn't
do.

 

This code runs as long as the Sheets("1").Cells(2, ColNumber) =
Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some data
with a lot of variables in sheet "1" of which I need few variable listed in
Sheet "Name" Column A. I want to delete all column from Sheet 1 which
doesn't match with variable listed in Sheet "Name" Column A.

 

Thanks 

On Sun, Feb 20, 2011 at 6:39 PM, Daniel  wrote:

Hello, 

What is not working ? Do you get an error ?

What are you trying to do ?

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de rakesh kumar
Envoyé : dimanche 20 février 2011 11:16
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ CODE DOESN'T WORK

 

Hi Dearests,

 

Could anyone help me and make the below code work  ?

 

Dim GetVarCounts As Integer

Dim ColName As Integer, RowCounter As Integer

Dim oRg As Range

 

 

RowCounter = 1

 

For ColName = 1 To 750

 

If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter,
1) Then

Sheets("1").Cells(1, ColName) = 1

RowCounter = RowCounter + 1

Else

Sheets("1").Cells(1, ColName) = 0

End If

'Application.ScreenUpdating = False

Next ColName

 

RowCounter = 1

For Each c In Worksheets("1").Range("A1:a750").Cells

If c.Value = 0 Then

Columns(RowCounter).EntireColumn.Delete

End If

RowCounter = RowCounter + 1

Next

 

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 
  Rakesh kumar khowal
 +91 9540084660
 +91 9868532105

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  <http://exceldailytip.blogspot.com>
http://exceldailytip.blogspot.com

To post to this group, send email to  <mailto:excel-macros@googlegroups.com>
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
 <http://www.facebook.com/discussexcel> http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ CODE DOESN'T WORK

[Paul Schreiner]

Let's step through the code:
RowCounter = 1
 
For ColName = 1 To 750
 
        If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter, 1) 
Then
        Sheets("1").Cells(1, ColName) = 1
        RowCounter = RowCounter + 1
        Else
        Sheets("1").Cells(1, ColName) = 0
        End If
        'Application.ScreenUpdating = False
Next ColName
 
You have two sheets named "1" and "Name".
You set RowCounter = 1.
The code looks through 750 columns in sheet named "1"
and checks the value in row 2 to see if it matches the value in the sheet "Name"
column 1, row (1) (from Rowcounter)

If the cell doesn't match, it puts a "0" in row 1 of the column it's checking.
If it MATCHES, then it puts a "1" in row 1, and increments RowCounter to begin 
checking
for the next "name".
That means that if a match is found in column 101,
then  you'll check columns 102-750 for the rest of the "names" in the list,
but you'll no longer check 1-100 for ANY more names.

Plus, the whole thing stops the first time a "name" is searched for and there 
is 
NO matches.
Because, let's say that the FIRST name in the list (Sheets("Name").Cells(1,1))
does not exist in row 2 of Sheets("1").

Then the loop: For ColName = 1 to 750
will run check all cells, and never find a match, so RowCounter will never be 
incremented,
so no more names will be checked!

Now, if the "Names" ALWAYS exist when you run this program, 
AND they appear in sheets("1") in the EXACT same order as they appear in 
sheets("Name")
then it might work OK the FIRST time.
But once you remove one of the columns, then the script will no longer complete 
successfully.
---
Next, your loop:
    For Each c In Worksheets("1").Range("A1:a750").Cells
        If c.Value = 0 Then
        Columns(RowCounter).EntireColumn.Delete
        End If
        RowCounter = RowCounter + 1
    Next
 
Since you're placing a 0/1 in the first ROW of sheets("1") then you should be 
looping through row 1, not column A.
So your loop should read:
For Each c In Worksheets("1").Range("A1:ABV1").Cells

Now, instead of incrementing RowCounter, you could use the C object:
C.Column like:

Columns(C.Column).EntireColumn.Delete

But this loop has another problem.

In the first iteration:
Column 1
if Column 1 has a "0", then you delete it and check the next column.
However, since you deleted column 1, then column 2 is now column 1.
you increment your counter and check column 2.
Which means that the "current" column 1 (formerly column 2) was never
checked.
If two adjacent columns happen to both have a "0", then you'll only delete
the first.

As in:
A B C D E
1 1 0 0 1
becomes:
A B C D E
1 1 0 1
when column C is deleted, the loop then checks column D
in the next iteration.

When deleting rows or columns, I prefer to work "backwards", like:

For ColNo = 750 To 1 Step -1
    If Cells(1, ColNo).Value = 0 Then
    Cells(1, ColNo).EntireColumn.Delete
    End If
Next


hope this helps,

Paul


From: Daniel 
To: excel-macros@googlegroups.com
Sent: Mon, February 21, 2011 10:40:31 AM
Subject: RE: $$Excel-Macros$$ CODE DOESN'T WORK


The code is correct. Simply, there is no match and the test is always false. 
Can 
you post your data ?
Daniel
 
De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la 
part de rakesh kumar
Envoyé : dimanche 20 février 2011 21:35
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ CODE DOESN'T WORK
 
thanks Daniel Ji for the reply... here what I need and what the code doesn't do.
 
This code runs as long as the Sheets("1").Cells(2, ColNumber) = 
Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some data 
with a lot of variables in sheet "1" of which I need few variable listed in 
Sheet "Name" Column A. I want to delete all column from Sheet 1 which doesn't 
match with variable listed in Sheet "Name" Column A.
 
Thanks 
On Sun, Feb 20, 2011 at 6:39 PM, Daniel  wrote:
Hello, 
What is not working ? Do you get an error ?
What are you trying to do ?
Daniel
 
De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la 
part de rakesh kumar
Envoyé : dimanche 20 février 2011 11:16
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ CODE DOESN'T WORK
 
Hi Dearests,
 
Could anyone help me and make the below code work  ?
 
Dim GetVarCounts As Integer
Dim ColName As Integer, RowCounter As Integer
Dim oRg As Range
 
 
RowCounter = 1
 
For ColName = 1 To 750
 
        If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter, 1) 
Then

Re: $$Excel-Macros$$ CODE DOESN'T WORK

[rakesh kumar]

Paul Dada, You are great .. Thanks for the explanation will work on your
suggestions and get in touch with you again.

*Many Regards,*
*Rakesh*

On Mon, Feb 21, 2011 at 9:51 PM, Paul Schreiner wrote:

> Let's step through the code:
>
> RowCounter = 1
>
>
>
> For ColName = 1 To 750
>
>
>
> If Sheets("1").Cells(2, ColName) = Sheets("Name").Cells(RowCounter,
> 1) Then
>
> Sheets("1").Cells(1, ColName) = 1
>
> RowCounter = RowCounter + 1
>
> Else
>
> Sheets("1").Cells(1, ColName) = 0
>
> End If
>
> 'Application.ScreenUpdating = False
>
> Next ColName
>
>
> You have two sheets named "1" and "Name".
> You set RowCounter = 1.
> The code looks through 750 columns in sheet named "1"
> and checks the value in row 2 to see if it matches the value in the sheet
> "Name"
> column 1, row (1) (from Rowcounter)
>
> If the cell doesn't match, it puts a "0" in row 1 of the column it's
> checking.
> If it MATCHES, then it puts a "1" in row 1, and increments RowCounter to
> begin checking
> for the next "name".
> That means that if a match is found in column 101,
> then  you'll check columns 102-750 for the rest of the "names" in the list,
> but you'll no longer check 1-100 for ANY more names.
>
> Plus, the whole thing stops the first time a "name" is searched for and
> there is NO matches.
> Because, let's say that the FIRST name in the list
> (Sheets("Name").Cells(1,1))
> does not exist in row 2 of Sheets("1").
>
> Then the loop: For ColName = 1 to 750
> will run check all cells, and never find a match, so RowCounter will never
> be incremented,
> so no more names will be checked!
>
> Now, if the "Names" ALWAYS exist when you run this program,
> AND they appear in sheets("1") in the EXACT same order as they appear in
> sheets("Name")
> then it might work OK the FIRST time.
> But once you remove one of the columns, then the script will no longer
> complete successfully.
> ---
> Next, your loop:
>
> For Each c In Worksheets("1").Range("A1:a750").Cells
>
> If c.Value = 0 Then
>
> Columns(RowCounter).EntireColumn.Delete
>
> End If
>
> RowCounter = RowCounter + 1
>
> Next
>
>
>
> Since you're placing a 0/1 in the first ROW of sheets("1") then you should
> be looping through row 1, not column A.
>
> So your loop should read:
>
> For Each c In Worksheets("1").Range("A1:ABV1").Cells
>
> Now, instead of incrementing RowCounter, you could use the C object:
> C.Column like:
>
> Columns(C.Column).EntireColumn.Delete
>
> But this loop has another problem.
>
> In the first iteration:
> Column 1
> if Column 1 has a "0", then you delete it and check the next column.
> However, since you deleted column 1, then column 2 is now column 1.
> you increment your counter and check column 2.
> Which means that the "current" column 1 (formerly column 2) was never
> checked.
> If two adjacent columns happen to both have a "0", then you'll only delete
> the first.
>
> As in:
> A B C D E
> 1 1 0 0 1
> becomes:
> A B C D E
> 1 1 0 1
> when column C is deleted, the loop then checks column D
> in the next iteration.
>
> When deleting rows or columns, I prefer to work "backwards", like:
>
> For ColNo = 750 To 1 Step -1
> If Cells(1, ColNo).Value = 0 Then
> Cells(1, ColNo).EntireColumn.Delete
> End If
> Next
>
>
> hope this helps,
>
> Paul
>  --
> *From:* Daniel 
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, February 21, 2011 10:40:31 AM
> *Subject:* RE: $$Excel-Macros$$ CODE DOESN'T WORK
>
>  The code is correct. Simply, there is no match and the test is always
> false. Can you post your data ?
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* rakesh kumar
> *Envoyé :* dimanche 20 février 2011 21:35
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ CODE DOESN'T WORK
>
>
>
> *thanks Daniel Ji for the reply... here what I need and what the code
> doesn't do.*
>
>
>
> *This code runs as long as the Sheets("1").Cells(2, ColNumber) =
> Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some data
> 

Re: $$Excel-Macros$$ code explanation please

[STDEV(i)]

excel is opening a text File
the array are data for  column index and length of string string to be
converted to a cells

Array(Array(1, 2), Array(2, 4))

text file contents:  "ABCDEFG"

converted to 2 columns
column 1  = "AB"
column 2 = "CDEF"

If you use [Text To Column] ( of DATA menu) you will understand this code.
CMIIW



On Wed, Mar 16, 2011 at 12:04 AM, Skanda  wrote:

> What does the following code do?especially the array part!
>
> Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data
> File"
> Workbooks.OpenText FileName:=FileLoc, Origin _
> :=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
> xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,
> Semicolon:=False, _
> Comma:=False, Space:=False, Other:=True, OtherChar:="~",
> FieldInfo:= _
> Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 2), Array(5,
> 2), Array(6, 2), _
>   Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2),
> Array(11, 2), Array(12, 2), _
>   Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1),
> Array(17, 1), Array(18, 1), _
>   Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1),
> Array(23, 1), Array(24, 1), _
>   Array(25, 1), Array(26, 1), Array(27, 1), Array(28, 1),
> Array(29, 1), Array(30, 1), _
>   Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1),
> Array(35, 1), Array(36, 1), _
>   Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1),
> Array(41, 1), _
>   Array(52, 2))
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ code explanation please

[Skanda]

The data actually pouplates till AS column.When the report is generated it
stops at cloumn AL.
Does this array thing has to do anything about it?

 Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data
File"
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,
Semicolon:=False, _
Comma:=False, Space:=False, Other:=True, OtherChar:="~", FieldInfo:=
_
Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 2), Array(5,
2), Array(6, 2), _
  Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2), Array(11,
2), Array(12, 2), _
  Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1),
Array(17, 1), Array(18, 1), _
  Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1),
Array(23, 1), Array(24, 1), _
  Array(25, 1), Array(26, 1), Array(27, 1), Array(28, 1),
Array(29, 1), Array(30, 1), _
  Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1),
Array(35, 1), Array(36, 1), _
  Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1),
Array(41, 1), _
  Array(52, 2))



On Wed, Mar 16, 2011 at 12:56 AM, STDEV(i) wrote:

> excel is opening a text File
> the array are data for  column index and length of string string to be
> converted to a cells
>
> Array(Array(1, 2), Array(2, 4))
>
> text file contents:  "ABCDEFG"
>
> converted to 2 columns
> column 1  = "AB"
> column 2 = "CDEF"
>
> If you use [Text To Column] ( of DATA menu) you will understand this code.
> CMIIW
>
>
>
>  On Wed, Mar 16, 2011 at 12:04 AM, Skanda wrote:
>
>> What does the following code do?especially the array part!
>>
>> Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data
>> File"
>> Workbooks.OpenText FileName:=FileLoc, Origin _
>> :=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
>> xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True,
>> Semicolon:=False, _
>> Comma:=False, Space:=False, Other:=True, OtherChar:="~",
>> FieldInfo:= _
>> Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 2), Array(5,
>> 2), Array(6, 2), _
>>   Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2),
>> Array(11, 2), Array(12, 2), _
>>   Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1),
>> Array(17, 1), Array(18, 1), _
>>   Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1),
>> Array(23, 1), Array(24, 1), _
>>   Array(25, 1), Array(26, 1), Array(27, 1), Array(28, 1),
>> Array(29, 1), Array(30, 1), _
>>   Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1),
>> Array(35, 1), Array(36, 1), _
>>   Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1),
>> Array(41, 1), _
>>   Array(52, 2))
>>
>>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ code for search

[dguillett1]

How about a formula
  
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
 


From: Shankar Bheema 
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ code for search

Hai all good evening

I am attaching the excel sheet which contains file numbers and names in 
corresponding file number.  I placed an userform with file no. and name with a 
command button for search.   

If we know the name and dont know the file no. by giving little part of the 
name and if pressed on the search button it should show the file number and 

if we know the file number and dont know the name by giving the file number on 
the corresponding textbox and pressing the button it should return the name of 
the employee

pls suggest me the code
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ code for search

[Shankar Bheema]

not working. and where to put this code.  I made it on userform not on
sheet.  So in your formula there is no representation of the objects na. how
it works ?

On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:

>   How about a formula
>
> =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
>
>  *From:* Shankar Bheema 
> *Sent:* Wednesday, September 07, 2011 8:14 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ code for search
>
>  Hai all good evening
>
> I am attaching the excel sheet which contains file numbers and names in
> corresponding file number.  I placed an userform with file no. and name with
> a command button for search.
>
> If we know the name and dont know the file no. by giving little part of the
> name and if pressed on the search button it should show the file number and
>
> if we know the file number and dont know the name by giving the file number
> on the corresponding textbox and pressing the button it should return the
> name of the employee
>
> pls suggest me the code
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ code for search

[dguillett1]

I’m one of those people who  doesn’t much care for pivot tables and userforms. 
KISS (Keep it simple, stupid). Not meant personally.

From: Shankar Bheema 
Sent: Wednesday, September 07, 2011 9:04 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ code for search

not working. and where to put this code.  I made it on userform not on sheet.  
So in your formula there is no representation of the objects na. how it works ?


On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:

  How about a formula

=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
 


  From: Shankar Bheema 
  Sent: Wednesday, September 07, 2011 8:14 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ code for search

  Hai all good evening

  I am attaching the excel sheet which contains file numbers and names in 
corresponding file number.  I placed an userform with file no. and name with a 
command button for search.   

  If we know the name and dont know the file no. by giving little part of the 
name and if pressed on the search button it should show the file number and 

  if we know the file number and dont know the name by giving the file number 
on the corresponding textbox and pressing the button it should return the name 
of the employee

  pls suggest me the code
  -- 
  
--
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

  -- 
  
--
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ code for search

[Shankar Bheema]

how to place grid control in vba excel ?

On Wed, Sep 7, 2011 at 8:04 PM, dguillett1  wrote:

>   I’m one of those people who  doesn’t much care for pivot tables and
> userforms. KISS (Keep it simple, stupid). Not meant personally.
>
>  *From:* Shankar Bheema 
> *Sent:* Wednesday, September 07, 2011 9:04 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ code for search
>
> not working. and where to put this code.  I made it on userform not on
> sheet.  So in your formula there is no representation of the objects na. how
> it works ?
>
> On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:
>
>>   How about a formula
>>
>> =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
>>
>>  *From:* Shankar Bheema 
>> *Sent:* Wednesday, September 07, 2011 8:14 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ code for search
>>
>>   Hai all good evening
>>
>> I am attaching the excel sheet which contains file numbers and names in
>> corresponding file number.  I placed an userform with file no. and name with
>> a command button for search.
>>
>> If we know the name and dont know the file no. by giving little part of
>> the name and if pressed on the search button it should show the file number
>> and
>>
>> if we know the file number and dont know the name by giving the file
>> number on the corresponding textbox and pressing the button it should return
>> the name of the employee
>>
>> pls suggest me the code
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code or Formula Required

[Puttaswamy]

Attached is the spread sheet. Please do the needful.

On Fri, Mar 26, 2010 at 12:49 PM, Puttu  wrote:

> Hi Group,
>
> I have sheet where I get a details of the company in different format,
> which the output need in one excel row.
>
> Example
>
> Jamrut Trading Co.  Send Mail
>
> BusinessEstablished Sales
>
>Manufacturer1977250,000 to 1 million USD
>
>  Deals In Export Of :
>Spices, grounded spices, processed foods, canned vegetables, dals,
> rice, pickles, chutneys, jam, papads, agarbattis
>
>
>  Email: Send Mail   Contact Person: Rajesh Jesrani
>605, Cotton Exchange Building
>175, Kalbadevi Rd
>Mumbai 41
>Maharashtra India
>
>
> Output Should Be:-
>
> Company NameAddress CityState   Phone   Mobile  Fax Email
> Website Contact
> Person  Bussiness Details
> Jamrut Trading Co.  "605, Cotton Exchange Building
> 175, Kalbadevi Rd
> Mumbai 41
> Maharashtra India"  Mumbai  Maharashtra
> Rajesh Jesrani  Spices,
> grounded spices, processed foods, canned vegetables, dals, rice,
> pickles, chutneys, jam, papads, agarbattis
>
>
> Could you please advise how to do that.
>
> Thanks
> Puttu
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.


Code Required.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Code or Formula Required

[Puttaswamy]

Hi Group,

Could you please help on this.

Thanks
Puttu

On Fri, Mar 26, 2010 at 3:44 PM, Puttaswamy  wrote:

> Attached is the spread sheet. Please do the needful.
>
>
> On Fri, Mar 26, 2010 at 12:49 PM, Puttu  wrote:
>
>> Hi Group,
>>
>> I have sheet where I get a details of the company in different format,
>> which the output need in one excel row.
>>
>> Example
>>
>> Jamrut Trading Co.  Send Mail
>>
>> BusinessEstablished Sales
>>
>>Manufacturer1977250,000 to 1 million USD
>>
>>  Deals In Export Of :
>>Spices, grounded spices, processed foods, canned vegetables, dals,
>> rice, pickles, chutneys, jam, papads, agarbattis
>>
>>
>>  Email: Send Mail   Contact Person: Rajesh Jesrani
>>605, Cotton Exchange Building
>>175, Kalbadevi Rd
>>Mumbai 41
>>Maharashtra India
>>
>>
>> Output Should Be:-
>>
>> Company NameAddress CityState   Phone   Mobile  Fax Email
>> Website Contact
>> Person  Bussiness Details
>> Jamrut Trading Co.  "605, Cotton Exchange Building
>> 175, Kalbadevi Rd
>> Mumbai 41
>> Maharashtra India"  Mumbai  Maharashtra
>>   Rajesh Jesrani  Spices,
>> grounded spices, processed foods, canned vegetables, dals, rice,
>> pickles, chutneys, jam, papads, agarbattis
>>
>>
>> Could you please advise how to do that.
>>
>> Thanks
>> Puttu
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe from this group, send email to excel-macros+
>> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
>> ME" as the subject.
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

Re: $$Excel-Macros$$ code vba pour une date automatique

[Mustapha LMIDMANI]

Please try to use function " now() " it gives the actual date and hour when
you write it. but it will updated each time you open the file ... and this
is not what you're looking for I think...

2015-05-21 16:43 GMT+01:00 siga :

> bonjour
>  je cherche un code vba qui affiche la date dans la cellule e après qu'on
> a saisie les données dans le cellule a b c d et que cette date soit fixe et
> ne change pas avec le temps.
>  merci pour l'aid
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ code vba pour une date automatique

[elhechmi eladeb]

thanks
yes the problem is what you just said, each time you open the file the date
changes. in this case I find a vien code in Internet. the problem that
execute from i = 2 to i = 100 beyond the 100 code is not working. the code
you find in this link:
http://familycomputerclub.com/auomatic-date-time-entry-excel-vba.html



2015-05-21 16:56 GMT+01:00 Mustapha LMIDMANI :

> Please try to use function " now() " it gives the actual date and hour
> when you write it. but it will updated each time you open the file ... and
> this is not what you're looking for I think...
>
> 2015-05-21 16:43 GMT+01:00 siga :
>
>> bonjour
>>  je cherche un code vba qui affiche la date dans la cellule e après qu'on
>> a saisie les données dans le cellule a b c d et que cette date soit fixe et
>> ne change pas avec le temps.
>>  merci pour l'aid
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/a1cR3saIVrY/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 


*Cordialement   Elhechmi  Eladeb*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ code vba pour une date automatique

[Mustapha LMIDMANI]

without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?

2015-05-21 17:12 GMT+01:00 elhechmi eladeb :

> thanks
> yes the problem is what you just said, each time you open the file the
> date changes. in this case I find a vien code in Internet. the problem that
> execute from i = 2 to i = 100 beyond the 100 code is not working. the code
> you find in this link:
> http://familycomputerclub.com/auomatic-date-time-entry-excel-vba.html
>
>
>
> 2015-05-21 16:56 GMT+01:00 Mustapha LMIDMANI 
> :
>
>> Please try to use function " now() " it gives the actual date and hour
>> when you write it. but it will updated each time you open the file ... and
>> this is not what you're looking for I think...
>>
>> 2015-05-21 16:43 GMT+01:00 siga :
>>
>>> bonjour
>>>  je cherche un code vba qui affiche la date dans la cellule e après
>>> qu'on a saisie les données dans le cellule a b c d et que cette date soit
>>> fixe et ne change pas avec le temps.
>>>  merci pour l'aid
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/a1cR3saIVrY/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
>
>
> *Cordialement   Elhechmi  Eladeb*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this 

Re: $$Excel-Macros$$ code vba pour une date automatique

[elhechmi eladeb]

thanks

2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI :

> without reading in deep of the code, you can just give to i a verry big
> value this will solve your issue ?
>
> 2015-05-21 17:12 GMT+01:00 elhechmi eladeb :
>
>> thanks
>> yes the problem is what you just said, each time you open the file the
>> date changes. in this case I find a vien code in Internet. the problem that
>> execute from i = 2 to i = 100 beyond the 100 code is not working. the code
>> you find in this link:
>> http://familycomputerclub.com/auomatic-date-time-entry-excel-vba.html
>>
>>
>>
>> 2015-05-21 16:56 GMT+01:00 Mustapha LMIDMANI > >:
>>
>>> Please try to use function " now() " it gives the actual date and hour
>>> when you write it. but it will updated each time you open the file ... and
>>> this is not what you're looking for I think...
>>>
>>> 2015-05-21 16:43 GMT+01:00 siga :
>>>
 bonjour
  je cherche un code vba qui affiche la date dans la cellule e après
 qu'on a saisie les données dans le cellule a b c d et que cette date soit
 fixe et ne change pas avec le temps.
  merci pour l'aid

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/a1cR3saIVrY/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>>
>>
>> *Cordialement   Elhechmi  Eladeb*
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and

Re: $$Excel-Macros$$ code required to clear active sheet.

[Prabhu Pinky]

hi experts,

i got the answer for my latest post.

below is the one i found myself :

Sub clearcontents()
ActiveSheet.Cells.clearcontents
End Sub


Regards,
Prabhu R

On 15 May 2013 10:25, Prabhu Pinky  wrote:

> hi experts,
>
> what is the code to clear the contents including formats in active sheet?
>
> if im in sheet 1and if i run the macro it should clear only the sheet 1
> data, if i go to sheet to and if i run the macro it should clear only the
> sheet 2 data.
>
> please help.
>
>
> regards,
> prabhu r
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ code required to clear active sheet.

[Prabhu Pinky]

hi experts..

actually its not working...

kindly help me on this...it clears only sheet 1 contents... if i select
sheet 2 or other sheets and if i run the macro its not clearing. its works
only on sheet 1.


On 15 May 2013 10:35, Prabhu Pinky  wrote:

> hi experts,
>
> i got the answer for my latest post.
>
> below is the one i found myself :
>
> Sub clearcontents()
> ActiveSheet.Cells.clearcontents
>
 Range("A1").select

> End Sub
>
>
> Regards,
> Prabhu R
>
>
> On 15 May 2013 10:25, Prabhu Pinky  wrote:
>
>> hi experts,
>>
>> what is the code to clear the contents including formats in active sheet?
>>
>> if im in sheet 1and if i run the macro it should clear only the sheet 1
>> data, if i go to sheet to and if i run the macro it should clear only the
>> sheet 2 data.
>>
>> please help.
>>
>>
>> regards,
>> prabhu r
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ code required to clear active sheet.

[Abhishek Jain]

It should work for all sheets upon selection.

May be you have put it at a wrong place. See the attached example.

HTH

On Wed, May 15, 2013 at 10:55 AM, Prabhu Pinky wrote:

> hi experts..
>
> actually its not working...
>
> kindly help me on this...it clears only sheet 1 contents... if i select
> sheet 2 or other sheets and if i run the macro its not clearing. its works
> only on sheet 1.
>
>
> On 15 May 2013 10:35, Prabhu Pinky  wrote:
>
>> hi experts,
>>
>> i got the answer for my latest post.
>>
>> below is the one i found myself :
>>
>> Sub clearcontents()
>> ActiveSheet.Cells.clearcontents
>>
>  Range("A1").select
>
>> End Sub
>>
>>
>> Regards,
>> Prabhu R
>>
>>
>> On 15 May 2013 10:25, Prabhu Pinky  wrote:
>>
>>> hi experts,
>>>
>>> what is the code to clear the contents including formats in active sheet?
>>>
>>> if im in sheet 1and if i run the macro it should clear only the sheet 1
>>> data, if i go to sheet to and if i run the macro it should clear only the
>>> sheet 2 data.
>>>
>>> please help.
>>>
>>>
>>> regards,
>>> prabhu r
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Clear Contents example.xlsm
Desc

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

[Mack Mans]

http://tutorialway.com/use-named-range-in-excel/
 helpful site

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[ashish koul]

use application.enableevents = false at the beginning

and application.enableevents  = true at end

On Mon, Jul 27, 2015 at 5:29 PM, gargee singh  wrote:

>
> Dear Experts
>
>
>
> I wrote a code to multiply or divide a range of numbers by 1000 if
> depending on whether a user selects a yes or no from a drop down in cell k2
> in the active sheet.  The problem is that once I select “yes” or “no” the
> code loops indefinitely because it finds a yes or no in the cell k2.
>
>
>
> What I want is to run the code only once when a user  selects “yes” and
> once when the user selects “no”, how can I code to terminate the process
> after the first run. Also I realized that the code runs if I change any
> cell on the sheet and not just K2 , how can this be fixed ?
>
>
>
> Codes below :-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If (Range("k2") = "Yes") Then
>
> Call inthousand
>
> End If
>
> End Sub
>
> Sub inthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell * 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> Sub notinthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell / 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> please  help.
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on Facebook 
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

its perfect!  thanks a lot...  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul"  
wrote:
use application.enableevents = false at the beginning

and application.enableevents  = true at end

On Mon, Jul 27, 2015 at 5:29 PM, gargee singh  wrote:

>
> Dear Experts
>
>
>
> I wrote a code to multiply or divide a range of numbers by 1000 if
> depending on whether a user selects a yes or no from a drop down in cell k2
> in the active sheet.  The problem is that once I select “yes” or “no” the
> code loops indefinitely because it finds a yes or no in the cell k2.
>
>
>
> What I want is to run the code only once when a user  selects “yes” and
> once when the user selects “no”, how can I code to terminate the process
> after the first run. Also I realized that the code runs if I change any
> cell on the sheet and not just K2 , how can this be fixed ?
>
>
>
> Codes below :-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If (Range("k2") = "Yes") Then
>
> Call inthousand
>
> End If
>
> End Sub
>
> Sub inthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell * 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> Sub notinthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell / 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> please  help.
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



--
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on Facebook 
Join Us on Facebook 


P Before printing, think about the environment.

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential dat

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

Hello,


i just realized that it also runs the code when i change some other cell on the 
sheet e.g i use some other validation on the sheet or calculate something 
elsewhere , why would that happen.


i want it to run the code only when cell k2 is changed to a yes or no.


thanks again.




Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:13 AM -0700,  wrote:
its perfect!  thanks a lot...  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul"  
wrote:
use application.enableevents = false at the beginning

and application.enableevents  = true at end

On Mon, Jul 27, 2015 at 5:29 PM, gargee singh  wrote:

>
> Dear Experts
>
>
>
> I wrote a code to multiply or divide a range of numbers by 1000 if
> depending on whether a user selects a yes or no from a drop down in cell k2
> in the active sheet.  The problem is that once I select “yes” or “no” the
> code loops indefinitely because it finds a yes or no in the cell k2.
>
>
>
> What I want is to run the code only once when a user  selects “yes” and
> once when the user selects “no”, how can I code to terminate the process
> after the first run. Also I realized that the code runs if I change any
> cell on the sheet and not just K2 , how can this be fixed ?
>
>
>
> Codes below :-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If (Range("k2") = "Yes") Then
>
> Call inthousand
>
> End If
>
> End Sub
>
> Sub inthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell * 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> Sub notinthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell / 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> please  help.
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



--
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on Facebook 
Join Us on Facebook 


P Before printing, think about the environment.

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not g

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[ashish koul]

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
If Target.Cells.Count = 1 Then

If Target.Address = "$K$2" Then
'  ADD UR CODE HERE


End If



End If
Application.EnableEvents = True

End Sub

On Mon, Jul 27, 2015 at 5:54 PM,  wrote:

>  Hello,
>
> i just realized that it also runs the code when i change some other cell
> on the sheet e.g i use some other validation on the sheet or calculate
> something elsewhere , why would that happen.
>
> i want it to run the code only when cell k2 is changed to a yes or no.
>
> thanks again.
>
>  Sent by Outlook  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:13 AM -0700,  wrote:
>
>  its perfect!  thanks a lot...  :)
>
> Sent by Outlook  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul" <
> koul.ash...@gmail.com> wrote:
>
>   use application.enableevents = false at the beginning
>
>  and application.enableevents  = true at end
>
> On Mon, Jul 27, 2015 at 5:29 PM, gargee singh 
> wrote:
>
>
>  Dear Experts
>
>
>
> I wrote a code to multiply or divide a range of numbers by 1000 if
> depending on whether a user selects a yes or no from a drop down in cell k2
> in the active sheet.  The problem is that once I select “yes” or “no” the
> code loops indefinitely because it finds a yes or no in the cell k2.
>
>
>
> What I want is to run the code only once when a user  selects “yes” and
> once when the user selects “no”, how can I code to terminate the process
> after the first run. Also I realized that the code runs if I change any
> cell on the sheet and not just K2 , how can this be fixed ?
>
>
>
> Codes below :-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If (Range("k2") = "Yes") Then
>
> Call inthousand
>
> End If
>
> End Sub
>
> Sub inthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell * 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> Sub notinthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell / 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> please  help.
>
>
>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
> --
>  *Regards*
>
> *Ashish Koul*
>
>
>  *Visit*
> http://www.excelvbamacros.in
>  Like Us on Facebook 
> Join Us on Facebook 
>
>
>  P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email t

Re: $$Excel-Macros$$ Code Loops indefiniely due to cell value

[gargee28]

absolutely perfect now. thanks a lot.  :)  :)


Sent by Outlook for Android





On Mon, Jul 27, 2015 at 5:27 AM -0700, "ashish koul"  
wrote:
Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
If Target.Cells.Count = 1 Then

If Target.Address = "$K$2" Then
'  ADD UR CODE HERE


End If



End If
Application.EnableEvents = True

End Sub

On Mon, Jul 27, 2015 at 5:54 PM,  wrote:

>  Hello,
>
> i just realized that it also runs the code when i change some other cell
> on the sheet e.g i use some other validation on the sheet or calculate
> something elsewhere , why would that happen.
>
> i want it to run the code only when cell k2 is changed to a yes or no.
>
> thanks again.
>
>  Sent by Outlook  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:13 AM -0700,  wrote:
>
>  its perfect!  thanks a lot...  :)
>
> Sent by Outlook  for Android
>
>
>
> On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul" <
> koul.ash...@gmail.com> wrote:
>
>   use application.enableevents = false at the beginning
>
>  and application.enableevents  = true at end
>
> On Mon, Jul 27, 2015 at 5:29 PM, gargee singh 
> wrote:
>
>
>  Dear Experts
>
>
>
> I wrote a code to multiply or divide a range of numbers by 1000 if
> depending on whether a user selects a yes or no from a drop down in cell k2
> in the active sheet.  The problem is that once I select “yes” or “no” the
> code loops indefinitely because it finds a yes or no in the cell k2.
>
>
>
> What I want is to run the code only once when a user  selects “yes” and
> once when the user selects “no”, how can I code to terminate the process
> after the first run. Also I realized that the code runs if I change any
> cell on the sheet and not just K2 , how can this be fixed ?
>
>
>
> Codes below :-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If (Range("k2") = "Yes") Then
>
> Call inthousand
>
> End If
>
> End Sub
>
> Sub inthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell * 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> Sub notinthousand()
>
> Range("G17:W23").Select
>
> Dim cell As Range
>
> For Each cell In Selection
>
> cell = cell / 1000
>
> Next
>
> Selection.NumberFormat = "#,##0.00 ;[Red](#,##0.00)"
>
> End Sub
>
> please  help.
>
>
>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
> --
>  *Regards*
>
> *Ashish Koul*
>
>
>  *Visit*
> http://www.excelvbamacros.in
>  Like Us on Facebook 
> Join Us on Facebook 
>
>
>  P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from th

Re: $$Excel-Macros$$ Code for range shifting based on month

[ashish koul]

see if it helps
cell c3  enter this formula

=SUMPRODUCT(--($A$104:$A$65536>=DATE(LEFT($A3,4),RIGHT($A3,2),1)),--($A$104:$A$65536wrote:

> Dear all,
>
> I have a spreadsheet containing daily customer transaction data. I have
> used SUMIF to find out the monthly customer transaction data.
> However, it is tedious to copy the formula and paste for next month when
> next month comes.
>
> Can anyone suggest any VBA code / idea to help shifting the formula?
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

[Dave Bonallack]

Hi Kurt,

If your named ranges are really called WS1Data, WS2Data, WS3Data, WS4Data, then 
your code can be reduced to just a few lines.

 

Sub NoData()
Dim i As Integer, c As Range
'   Cycle thru each Named Range
For i = 1 To 4
'   Cycle thru each cell within the Named Range
For Each c In Range("WS" & i & "Data")
If IsNull(c) Or c = "" Then c = "no data"
Next c
Next i
End Sub


When you use Named Ranges, most of the time you don't need to state the sheet 
name. In your case, we have 4, so we need only cycle through them, and ignore 
the sheet names. This is one BIG advantage of using Named Ranges.

Note that the 'i' from the 'For i = 1 to 4' thingy has also been used to help 
construct the name of each range. Range("WS" & i & "Data")

By the way, note that I've used 'c' as my variable to represent each cell in 
the range. It's generally bad practice to use a word like 'cell' as a variable, 
since VBA has already allotted it a special meaning. VBA might pout if you use 
its favourite words for other things.

Hope this helps.

Regards - Dave.

 

 

 

 
> Date: Wed, 25 Aug 2010 12:14:21 -0700
> Subject: $$Excel-Macros$$ Code to enter value in multiple worksheets
> From: heislerk...@gmail.com
> To: excel-macros@googlegroups.com
> 
> I have 4 worksheets (WS1, WS2, etc.) with cells that get populated
> with data from a linked source sheet. In Column B on each worksheet is
> a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data,"
> etc.) When rows in the range are blank, I'd like to insert the word
> "no data."
> 
> I can do this with the following code, which manually selects the
> sheet, the cells, and the range, and then inserts "no data" in blank
> cells:
> 
> Sub InsertData()
> 
> ' Insert "no data" in empty cells
> 
> ' Do Worksheet 1
> 
> Sheets("WS1").Select
> Cells.Select ' is this line needed?
> Range("WS1Data").Activate
> 
> For Each Cell In Range("WS1Data")
> If IsNull(Cell.Value) Or Cell.Value = "" Then
> Cell.Value = "no data"
> End If
> Next
> 
> ' Do Worksheet 2
> 
> Sheets("WS2").Select
> Cells.Select
> Range("WS2Data").Activate
> 
> For Each Cell In Range("WS2Data")
> If IsNull(Cell.Value) Or Cell.Value = "" Then
> Cell.Value = "no data"
> End If
> Next
> 
> [etc. for the remaining two worksheets]
> 
> End Sub
> 
> #
> 
> As you can see, the code sets the focus to the corresponding worksheet
> as it goes through the code. Is there a more efficient way to perform
> this procedure, perhaps one that's transparent to the user? If not,
> I'd be interested in suggestions for making the code more economical.
> For instance, I suspect I don't need to rewrite the For ... Each
> segment four times, and instead just plug in a range value. Just not
> sure how.
> 
> Thank you.
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 7000 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

[Kurt]

Wow! This works great. The advantage of not always having to specify
the sheet when using Named Ranges never occurred to me.

As for this line:

c As Range

I would have expected to see something like 'c As Cell', but I guess
in Excel terms a cell is a range (albeit a very small one)?

Thanks much.

On Aug 26, 5:22 am, Dave Bonallack  wrote:
> Hi Kurt,
>
> If your named ranges are really called WS1Data, WS2Data, WS3Data, WS4Data, 
> then your code can be reduced to just a few lines.
>
> Sub NoData()
>     Dim i As Integer, c As Range
> '   Cycle thru each Named Range
>     For i = 1 To 4
> '       Cycle thru each cell within the Named Range
>         For Each c In Range("WS" & i & "Data")
>             If IsNull(c) Or c = "" Then c = "no data"
>         Next c
>     Next i
> End Sub
>
> When you use Named Ranges, most of the time you don't need to state the sheet 
> name. In your case, we have 4, so we need only cycle through them, and ignore 
> the sheet names. This is one BIG advantage of using Named Ranges.
>
> Note that the 'i' from the 'For i = 1 to 4' thingy has also been used to help 
> construct the name of each range. Range("WS" & i & "Data")
>
> By the way, note that I've used 'c' as my variable to represent each cell in 
> the range. It's generally bad practice to use a word like 'cell' as a 
> variable, since VBA has already allotted it a special meaning. VBA might pout 
> if you use its favourite words for other things.
>
> Hope this helps.
>
> Regards - Dave.
>
> > Date: Wed, 25 Aug 2010 12:14:21 -0700
> > Subject: $$Excel-Macros$$ Code to enter value in multiple worksheets
> > From: heislerk...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > I have 4 worksheets (WS1, WS2, etc.) with cells that get populated
> > with data from a linked source sheet. In Column B on each worksheet is
> > a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data,"
> > etc.) When rows in the range are blank, I'd like to insert the word
> > "no data."
>
> > I can do this with the following code, which manually selects the
> > sheet, the cells, and the range, and then inserts "no data" in blank
> > cells:
>
> > Sub InsertData()
>
> > ' Insert "no data" in empty cells
>
> > ' Do Worksheet 1
>
> > Sheets("WS1").Select
> > Cells.Select ' is this line needed?
> > Range("WS1Data").Activate
>
> > For Each Cell In Range("WS1Data")
> > If IsNull(Cell.Value) Or Cell.Value = "" Then
> > Cell.Value = "no data"
> > End If
> > Next
>
> > ' Do Worksheet 2
>
> > Sheets("WS2").Select
> > Cells.Select
> > Range("WS2Data").Activate
>
> > For Each Cell In Range("WS2Data")
> > If IsNull(Cell.Value) Or Cell.Value = "" Then
> > Cell.Value = "no data"
> > End If
> > Next
>
> > [etc. for the remaining two worksheets]
>
> > End Sub
>
> > #
>
> > As you can see, the code sets the focus to the corresponding worksheet
> > as it goes through the code. Is there a more efficient way to perform
> > this procedure, perhaps one that's transparent to the user? If not,
> > I'd be interested in suggestions for making the code more economical.
> > For instance, I suspect I don't need to rewrite the For ... Each
> > segment four times, and instead just plug in a range value. Just not
> > sure how.
>
> > Thank you.
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

[Dave Bonallack]

Yes, that's correct. A single cell is a range.  And when you type 'Dim c as' a 
list appears for us to choose from, and 'Cell' is not in it.

By the way, at times I have had problems not stating the sheet with a named 
range, and don't know why it works sometimes and not others. I use trial and 
error a lot.

Regards - Dave.
 
> Date: Fri, 27 Aug 2010 11:20:10 -0700
> Subject: Re: $$Excel-Macros$$ Code to enter value in multiple worksheets
> From: heislerk...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Wow! This works great. The advantage of not always having to specify
> the sheet when using Named Ranges never occurred to me.
> 
> As for this line:
> 
> c As Range
> 
> I would have expected to see something like 'c As Cell', but I guess
> in Excel terms a cell is a range (albeit a very small one)?
> 
> Thanks much.
> 
> On Aug 26, 5:22 am, Dave Bonallack  wrote:
> > Hi Kurt,
> >
> > If your named ranges are really called WS1Data, WS2Data, WS3Data, WS4Data, 
> > then your code can be reduced to just a few lines.
> >
> > Sub NoData()
> > Dim i As Integer, c As Range
> > '   Cycle thru each Named Range
> > For i = 1 To 4
> > '   Cycle thru each cell within the Named Range
> > For Each c In Range("WS" & i & "Data")
> > If IsNull(c) Or c = "" Then c = "no data"
> > Next c
> > Next i
> > End Sub
> >
> > When you use Named Ranges, most of the time you don't need to state the 
> > sheet name. In your case, we have 4, so we need only cycle through them, 
> > and ignore the sheet names. This is one BIG advantage of using Named Ranges.
> >
> > Note that the 'i' from the 'For i = 1 to 4' thingy has also been used to 
> > help construct the name of each range. Range("WS" & i & "Data")
> >
> > By the way, note that I've used 'c' as my variable to represent each cell 
> > in the range. It's generally bad practice to use a word like 'cell' as a 
> > variable, since VBA has already allotted it a special meaning. VBA might 
> > pout if you use its favourite words for other things.
> >
> > Hope this helps.
> >
> > Regards - Dave.
> >
> > > Date: Wed, 25 Aug 2010 12:14:21 -0700
> > > Subject: $$Excel-Macros$$ Code to enter value in multiple worksheets
> > > From: heislerk...@gmail.com
> > > To: excel-macros@googlegroups.com
> >
> > > I have 4 worksheets (WS1, WS2, etc.) with cells that get populated
> > > with data from a linked source sheet. In Column B on each worksheet is
> > > a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data,"
> > > etc.) When rows in the range are blank, I'd like to insert the word
> > > "no data."
> >
> > > I can do this with the following code, which manually selects the
> > > sheet, the cells, and the range, and then inserts "no data" in blank
> > > cells:
> >
> > > Sub InsertData()
> >
> > > ' Insert "no data" in empty cells
> >
> > > ' Do Worksheet 1
> >
> > > Sheets("WS1").Select
> > > Cells.Select ' is this line needed?
> > > Range("WS1Data").Activate
> >
> > > For Each Cell In Range("WS1Data")
> > > If IsNull(Cell.Value) Or Cell.Value = "" Then
> > > Cell.Value = "no data"
> > > End If
> > > Next
> >
> > > ' Do Worksheet 2
> >
> > > Sheets("WS2").Select
> > > Cells.Select
> > > Range("WS2Data").Activate
> >
> > > For Each Cell In Range("WS2Data")
> > > If IsNull(Cell.Value) Or Cell.Value = "" Then
> > > Cell.Value = "no data"
> > > End If
> > > Next
> >
> > > [etc. for the remaining two worksheets]
> >
> > > End Sub
> >
> > > #
> >
> > > As you can see, the code sets the focus to the corresponding worksheet
> > > as it goes through the code. Is there a more efficient way to perform
> > > this procedure, perhaps one that's transparent to the user? If not,
> > > I'd be interested in suggestions for making the code more economical.
> > > For instance, I suspect I don't need to rewrite the For ... Each
> > > segment four times, and instead just plug in a range v

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[dguillett1]

VBA Should do it. Change date and folder and file type to suit.

Sub DeleteFilesIfDay()
If Date = DateValue("1/25/2012") Then
On Error Resume Next
  Kill "C:\yourfoldernamehere\*.*"
On Error GoTo 0
End If
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mr excel 
Sent: Wednesday, January 25, 2012 6:32 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Code for deleting files in a folder.

hi all,

  i would like to know the code for deleting all the files in a folder on a 
desired day or say a particular date using vba or any script for that 
matter.Can i achieve the same using DOS commands or any software is required to 
do.
Kindly help.
Regards
excelkeechak.
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks a lot guillet for your support.i would further like to know whether
this code works simply by installing it in the code window of an excel
sheet and triggers itself on that particular date (checking the date with
the system date). Tell me how to get this code work with out any problems.
Thanks in advance.

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[dguillett1]

Just copy into a regular module. Change the date, folder, as I said.. It’s 
automatic based on the date.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mr excel 
Sent: Wednesday, January 25, 2012 6:51 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Code for deleting files in a folder.

thanks a lot guillet for your support.i would further like to know whether this 
code works simply by installing it in the code window of an excel sheet and 
triggers itself on that particular date (checking the date with the system 
date). Tell me how to get this code work with out any problems.
Thanks in advance.
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks for the update guillett

On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:

>   Just copy into a regular module. Change the date, folder, as I
> said.. It’s automatic based on the date.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Mr excel 
> *Sent:* Wednesday, January 25, 2012 6:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>
> thanks a lot guillet for your support.i would further like to know whether
> this code works simply by installing it in the code window of an excel
> sheet and triggers itself on that particular date (checking the date with
> the system date). Tell me how to get this code work with out any problems.
> Thanks in advance.
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

will this work automatically or should the excel sheet should be open for
the macro to run.

On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:

> thanks for the update guillett
>
>
> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:
>
>>   Just copy into a regular module. Change the date, folder, as I
>> said.. It’s automatic based on the date.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Mr excel 
>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>
>> thanks a lot guillet for your support.i would further like to know
>> whether this code works simply by installing it in the code window of an
>> excel sheet and triggers itself on that particular date (checking the date
>> with the system date). Tell me how to get this code work with out any
>> problems.
>> Thanks in advance.
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[NOORAIN ANSARI]

Dear Mr. excel,

It will work automatically when you run macro.



On Fri, Jan 27, 2012 at 5:35 PM, Mr excel  wrote:

> will this work automatically or should the excel sheet should be open for
> the macro to run.
>
>
> On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:
>
>> thanks for the update guillett
>>
>>
>> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:
>>
>>>   Just copy into a regular module. Change the date, folder, as I
>>> said.. It’s automatic based on the date.
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Mr excel 
>>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>>
>>> thanks a lot guillet for your support.i would further like to know
>>> whether this code works simply by installing it in the code window of an
>>> excel sheet and triggers itself on that particular date (checking the date
>>> with the system date). Tell me how to get this code work with out any
>>> problems.
>>> Thanks in advance.
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
*http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[Mr excel]

thanks noorain for the reply.but my requirement is to delete the files &
folders dynamically on the date in the code.any other way around.pls tell
me.

On Fri, Jan 27, 2012 at 5:40 PM, NOORAIN ANSARI wrote:

> Dear Mr. excel,
>
> It will work automatically when you run macro.
>
>
>
>
> On Fri, Jan 27, 2012 at 5:35 PM, Mr excel  wrote:
>
>> will this work automatically or should the excel sheet should be open for
>> the macro to run.
>>
>>
>> On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:
>>
>>> thanks for the update guillett
>>>
>>>
>>> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 wrote:
>>>
>>>>   Just copy into a regular module. Change the date, folder, as I
>>>> said.. It’s automatic based on the date.
>>>>
>>>> Don Guillett
>>>> SalesAid Software
>>>> dguille...@gmail.com
>>>>
>>>>  *From:* Mr excel 
>>>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>>>> *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>>>
>>>> thanks a lot guillet for your support.i would further like to know
>>>> whether this code works simply by installing it in the code window of an
>>>> excel sheet and triggers itself on that particular date (checking the date
>>>> with the system date). Tell me how to get this code work with out any
>>>> problems.
>>>> Thanks in advance.
>>>> --
>>>> FORUM RULES (986+ 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.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> --
>>>> FORUM RULES (986+ 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.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>
>>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[NOORAIN ANSARI]

Dear Excel,

Have you tried Don's VBA Code
I think it will perfect for your requirement.

Please try it once again..

Sub DeleteFilesIfDay()
If Date = DateValue("1/28/2012") Then
On Error Resume Next
  Kill "C:\yourfoldernamehere\*.*"
On Error GoTo 0
End If
End Sub

or

Sub DeleteFilesbetweentwodays()
if day(date) >= 5 and day(date) <=10 then
On Error Resume Next
  Kill "C:\yourfoldernamehere\*.*"
On Error GoTo 0
end if
end Sub


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
*http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>


On Fri, Jan 27, 2012 at 6:16 PM, Mr excel  wrote:

> thanks noorain for the reply.but my requirement is to delete the files &
> folders dynamically on the date in the code.any other way around.pls tell
> me.
>
>
> On Fri, Jan 27, 2012 at 5:40 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Mr. excel,
>>
>> It will work automatically when you run macro.
>> ** <http://noorain-ansari.blogspot.com/>
>>
>>
>>
>>
>> On Fri, Jan 27, 2012 at 5:35 PM, Mr excel  wrote:
>>
>>> will this work automatically or should the excel sheet should be open
>>> for the macro to run.
>>>
>>>
>>> On Thu, Jan 26, 2012 at 8:32 AM, Mr excel wrote:
>>>
>>>> thanks for the update guillett
>>>>
>>>>
>>>> On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 wrote:
>>>>
>>>>>   Just copy into a regular module. Change the date, folder, as I
>>>>> said.. It’s automatic based on the date.
>>>>>
>>>>> Don Guillett
>>>>> SalesAid Software
>>>>> dguille...@gmail.com
>>>>>
>>>>>  *From:* Mr excel 
>>>>> *Sent:* Wednesday, January 25, 2012 6:51 PM
>>>>> *To:* excel-macros@googlegroups.com
>>>>> *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder.
>>>>>
>>>>> thanks a lot guillet for your support.i would further like to know
>>>>> whether this code works simply by installing it in the code window of an
>>>>> excel sheet and triggers itself on that particular date (checking the date
>>>>> with the system date). Tell me how to get this code work with out any
>>>>> problems.
>>>>> Thanks in advance.
>>>>> --
>>>>> FORUM RULES (986+ 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.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> --
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>> --
>>>>> FORUM RULES (986+ 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.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.

Re: $$Excel-Macros$$ Code for deleting files in a folder.

[dguillett1]

If placed in the Thisworkbook module in the workbook_open event it will fire 
when you open the workbook.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mr excel 
Sent: Friday, January 27, 2012 6:05 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Code for deleting files in a folder.

will this work automatically or should the excel sheet should be open for the 
macro to run.


On Thu, Jan 26, 2012 at 8:32 AM, Mr excel  wrote:

  thanks for the update guillett 



  On Thu, Jan 26, 2012 at 6:31 AM, dguillett1  wrote:

Just copy into a regular module. Change the date, folder, as I said.. 
It’s automatic based on the date.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mr excel 
Sent: Wednesday, January 25, 2012 6:51 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Code for deleting files in a folder.

thanks a lot guillet for your support.i would further like to know whether 
this code works simply by installing it in the code window of an excel sheet 
and triggers itself on that particular date (checking the date with the system 
date). Tell me how to get this code work with out any problems.
Thanks in advance.

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com



-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Code for deleting files in a folder.

[Rajan_Verma]

For deleting all files from a folder..

 

Sub deleteFiles()

Dim MyFile As File

Dim MyFolder As Folder

Dim fso As Scripting.FileSystemObject

Set fso = New Scripting.FileSystemObject



Set MyFolder = fso.GetFolder(YourFolderPath)

For Each MyFile In MyFolder.Files

MyFile.Delete

Next

End Sub

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr excel
Sent: Jan/Thu/2012 06:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Code for deleting files in a folder.

 

hi all,

  i would like to know the code for deleting all the files in a folder on a
desired day or say a particular date using vba or any script for that
matter.Can i achieve the same using DOS commands or any software is required
to do.
Kindly help.
Regards
excelkeechak.

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code in Workbook_Open macro inadvertently crashes the file!!!

[Paul Schreiner]

For your second question:Here's what I would do:
Open a NEW workbook and create two 
macros:'Sub 
Events_Enabled()
    Application.EnableEvents = True
End Sub'
Sub Events_Disabled()
    Application.EnableEvents = False
End Sub' Run the 
Events_Disabled macro.
this will make it so that the event macros like "Workbook_Open" do not 
run.Then, open your workbook.
you can then edit your vba to do as you wish.
As to your first question:You seem to be doing it.In order to open a userform 
when the workbook is opened, place the code in the Workbook_Open event 
macro.Which it sounds like you have done!
hope this helps.
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
- 

On Saturday, March 19, 2016 2:17 AM, Rob Flott  wrote:
 
 

 Mayday MaydayI need help

My workbook contains several sheets displaying various report forms. The 
content of each report is based on the selections made from a UserForm.  

On the Workbook_Open macro I have 'Call OpenUF1' code to open the UserForm.

Sub OpenUF1()
  Load UserForm1
  UserForm1.Show
End Sub

My problem occurs when the workbook is opened...a message stating "Path/File 
access error"pops up. Then it give me a Run-Time error 75 stating 'Could not 
find the specified object'. Then when I try to debug it returns a message 
stating "Microsoft Excel has stopped working". So I am unable to open the VBE 
to correct or remove the code to open the UserForm.

I have two questions:
1. Is it possible to code it such that when the workbook is opened it 
automatically opens the UserForm? If so, what is the code to do this?

2. In the meantime how can I open the file with the Workbook_Open macro 
disabled so I can correct the code...or at lease remove it.

I am using MS Excel 2013
Thank you,

Rob-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


 
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Code for extracting google search results in excel

[ashish koul]

Hi seema


long time back I created this addin to search on Google  . I am not
sure how much accurate result will it give now . you can try it and
make changes in the code as per your requirement.

Download Link http://www.box.com/s/ab954ee4970bae3bf815

(File is too heavy so i have uploaded it on box.net please download it
from above link)



Also check Ron's (Excel Genius)  Google search Addin




http://www.rondebruin.nl/Google.htm


Regards,
Ashish Koul


On 3/30/12, seema mba  wrote:
> Hi,
>
> I have a sheet with the list of companies.I want a code which picks up the
> name of the company, search in google and extract the first url of search
> results(not the advertisement url).
>
> Thanks in advance for your help.
>
> Regards,
>
> Seema Nagdev
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code to refresh information from external data source

[ashish koul]

what is the source of external information

On Thu, Nov 29, 2012 at 1:52 AM, Hilary Lomotey  wrote:

> Hello Expert
>
> can i get help with a code to refresh information coming from a data
> source. i know the short cut ctrl + alt +f5 to refresh such data, but i
> would be grateful to get a code to do that thanks
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*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

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Code needed that would rename same name sub-folders

[ashish koul]

try this
Public Const oldnm As String = "f1"
Public Const newnm As String = "test_f1"


Sub renam_folders()

Dim fldpath As String
Dim fso As Object, folder1 As Object

fldpath = "C:\Users\admin\Desktop\sample" ' choose folder
Set fso = CreateObject("Scripting.FileSystemObject")
Set folder1 = fso.getfolder(fldpath)
get_sub_folder folder1
End Sub

Sub get_sub_folder(ByRef prntfld As Object)

Dim SubFolder As Object, subfld As Object, j As Long

For Each SubFolder In prntfld.SubFolders
If UCase(SubFolder.Name) = UCase(oldnm) Then
Name SubFolder.Path As Left(SubFolder.Path,
InStrRev(SubFolder.Path, "\")) & newnm
End If
Next SubFolder
For Each subfld In prntfld.SubFolders
get_sub_folder subfld
Next subfld

End Sub




On Sun, Jul 28, 2013 at 5:18 AM, Ruslan Idrisov
wrote:

> Hi, everyone, can you suggest a code that would help me find all
> sub-folders called "abc" and rename each to "1. abc"?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ code to clear all the values at a one go

[NOORAIN ANSARI]

Dear Santosh,

Please find & see attached sheet, if it help..

-- 
Thanks & regards,
Noorain Ansari

On Wed, Apr 6, 2011 at 3:00 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Group,
>
> Need a code to clear the values of all  the text boxes ,comboboxes in one
> click in a excel sheet with the name "calculator"
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


tryit.xlsm
Description: Binary data

RE: $$Excel-Macros$$ code to clear all the values at a one go

[Daniel]

Hi,

Try :

 

Sub test2()

Dim c

With Sheets("calculator")

On Error Resume Next

For i = 1 To .Shapes.Count

Var = .Shapes(i).OLEFormat.progID

If Err.Number <> 0 Then

Err.Clear

Else

If .Shapes(i).OLEFormat.progID = "Forms.TextBox.1" _

Or .Shapes(i).OLEFormat.progID = "Forms.ComboBox.1" Then

strname = .Shapes(i).Name

.OLEObjects(strname).Object.Value = ""

End If

End If

Next i

End With

End Sub

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de santosh subudhi
Envoyé : mardi 5 avril 2011 23:31
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ code to clear all the values at a one go

 

Hi Group,

 

Need a code to clear the values of all  the text boxes ,comboboxes in one
click in a excel sheet with the name "calculator"

-- 
Regards
Santosh 
santoshkumar.subu...@gmail.com

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  
http://exceldailytip.blogspot.com

To post to this group, send email to  
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Code to control the database not to accept repeated number

[Daniel]

Use COUNTIF to check filenumber is unique :
=COUNTIF(the filenumber column,filenumber)=0

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bheema Shankar
Envoyé : mardi 6 septembre 2011 16:40
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Code to control the database not to accept repeated
number

I made a userform. linked it with the datasheet.  the filenumber acts as a
bridge between userform and datasheet.  I have to make the file number
unique in excel. Because the duplicate numbers also accepting by the
datasheet.  If it happened so, my intention will not fulfill.
So kindly provide solution to make the filenumber column of the datasheet as
unique.

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

[NOORAIN ANSARI]

Dear Bheema,

Please see attached Sheet...

On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote:

> I made a userform. linked it with the datasheet.  the filenumber acts
> as a bridge between userform and datasheet.  I have to make the file
> number unique in excel. Because the duplicate numbers also accepting
> by the datasheet.  If it happened so, my intention will not fulfill.
> So kindly provide solution to make the filenumber column of the
> datasheet as unique.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Duplicate Entry.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

[Venkat CV]

Hi Bheema,

See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*

[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote:

> I made a userform. linked it with the datasheet.  the filenumber acts
> as a bridge between userform and datasheet.  I have to make the file
> number unique in excel. Because the duplicate numbers also accepting
> by the datasheet.  If it happened so, my intention will not fulfill.
> So kindly provide solution to make the filenumber column of the
> datasheet as unique.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

[Shankar Bheema]

thank you all very muchh
On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV  wrote:

> Hi Bheema,
>
> See below image and Try Data Validation and use custom and formula as *
> =COUNTIF(C:C,C1)=1*
>
> [image: image.png]
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
> *
> *
>
> On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote:
>
>> I made a userform. linked it with the datasheet.  the filenumber acts
>> as a bridge between userform and datasheet.  I have to make the file
>> number unique in excel. Because the duplicate numbers also accepting
>> by the datasheet.  If it happened so, my intention will not fulfill.
>> So kindly provide solution to make the filenumber column of the
>> datasheet as unique.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

[NOORAIN ANSARI]

Dear Santosh,

Please see attached sheet i hope it will help to you.

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Mon, Nov 28, 2011 at 3:00 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi All,
>
> In the user form I have coded a date validation which should take data for
> current date or the previous date only with the help of *calendar only*.
>
> However, the code is not working properly.
>
> Moreover in the textbox3 I want it to restrict it only for numbers and no
> character should be allowed to be entered for which I need help.
>
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
> FORUM RULES (934+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


** 

-- 
FORUM RULES (934+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com


Testing-1(Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

[Sam Mathai Chacko]

A TEXT can never be lesser than a number. At least in the Excel world.

Santhosh, please replace the entire code in form1 with this

Private Sub CommandButton1_Click()

If CDate(TextBox1.Value) > Date Then
msg = MsgBox("You cannot make a transaction for a future date",
vbCritical, "Your Personal Banking")
Exit Sub
End If
With Cells(Rows.Count, 1).End(xlUp)(2)
.NumberFormat = "[$-409]d-mmm-yy;@"
.Resize(1, 3).Value = Array(TextBox1.Value, TextBox2.Value,
TextBox3.Value)
End With

End Sub

Private Sub CommandButton2_Click()

Unload UserForm1

End Sub

Private Sub CommandButton3_Click()

Userform2.Show

End Sub

Private Sub TextBox3_Change()

Application.EnableEvents = 0
If Len(TextBox3.Text) = 1 Then
If InStr(1, "0123456789", TextBox3.Text) = 0 Then
TextBox3.Text = ""
End If
End If

If Len(CStr(Val(TextBox3.Text))) <> Len(TextBox3.Text) Then
TextBox3.Text = ""
End If
Application.EnableEvents = 1

End Sub

Regards,
Sam Mathai Chacko
On Mon, Nov 28, 2011 at 6:47 PM, NOORAIN ANSARI wrote:

> Dear Santosh,
>
> Please see attached sheet i hope it will help to you.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Mon, Nov 28, 2011 at 3:00 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
>> Hi All,
>>
>> In the user form I have coded a date validation which should take data
>> for current date or the previous date only with the help of *calendar
>> only*.
>>
>> However, the code is not working properly.
>>
>> Moreover in the textbox3 I want it to restrict it only for numbers and no
>> character should be allowed to be entered for which I need help.
>>
>> --
>> Regards
>> Santosh
>> santoshkumar.subu...@gmail.com
>>
>> --
>> FORUM RULES (934+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
> ** 
>
> --
> FORUM RULES (934+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ 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. 

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

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[ashish koul]

can you attach any workbook and word document how you will like the output
to be

On Tue, Aug 2, 2011 at 12:06 AM, skyping1 wrote:

> I have many Excel files in a folder which all have labelled Worksheets
> from 1 to X where X is always an integer.
>
> Most of the files have about 10 worksheets, and these can have both
> text and pictures in.
>
> I have searched, for some code (to no avail and through quite a few
> forums!!), that would copy the content of the worksheets in numeric
> order to a blank Word document.
>
> I am using 2010, and ideally would like to select any number of files
> and even perhaps the order(!) that they can be pasted into Word.
>
> Hope you guys can help.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[Rajan_Verma]

Please Attached  a sample file

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of skyping1
Sent: Tuesday, August 02, 2011 12:07 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1
to X to Word.

I have many Excel files in a folder which all have labelled Worksheets
from 1 to X where X is always an integer.

Most of the files have about 10 worksheets, and these can have both
text and pictures in.

I have searched, for some code (to no avail and through quite a few
forums!!), that would copy the content of the worksheets in numeric
order to a blank Word document.

I am using 2010, and ideally would like to select any number of files
and even perhaps the order(!) that they can be pasted into Word.

Hope you guys can help.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[skyping1]

Please find attached files...hope you can help

On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
> Please Attached  a sample file
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of skyping1
> Sent: Tuesday, August 02, 2011 12:07 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1
> to X to Word.
>
> I have many Excel files in a folder which all have labelled Worksheets
> from 1 to X where X is always an integer.
>
> Most of the files have about 10 worksheets, and these can have both
> text and pictures in.
>
> I have searched, for some code (to no avail and through quite a few
> forums!!), that would copy the content of the worksheets in numeric
> order to a blank Word document.
>
> I am using 2010, and ideally would like to select any number of files
> and even perhaps the order(!) that they can be pasted into Word.
>
> Hope you guys can help.
>
> --
> --- -
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[skyping1]

Please see the following link, as I cant seem to upload files to this
site:

http://www.excelforum.com/excel-programming/784924-export-all-worksheets-in-order-to-word-including-pictures-etc.html

Thanks!

On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
> Please Attached  a sample file
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of skyping1
> Sent: Tuesday, August 02, 2011 12:07 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1
> to X to Word.
>
> I have many Excel files in a folder which all have labelled Worksheets
> from 1 to X where X is always an integer.
>
> Most of the files have about 10 worksheets, and these can have both
> text and pictures in.
>
> I have searched, for some code (to no avail and through quite a few
> forums!!), that would copy the content of the worksheets in numeric
> order to a blank Word document.
>
> I am using 2010, and ideally would like to select any number of files
> and even perhaps the order(!) that they can be pasted into Word.
>
> Hope you guys can help.
>
> --
> --- -
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[Venkat CV]

Hi

There is No attachment.

*Best Regards,*
*Venkat*
*Chennai*

On Tue, Aug 2, 2011 at 10:41 PM, skyping1 wrote:

> Please find attached files...hope you can help
>
> On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
> > Please Attached  a sample file
> >
> >
> >
> >
> >
> >
> >
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> >
> > On Behalf Of skyping1
> > Sent: Tuesday, August 02, 2011 12:07 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
> 1
> > to X to Word.
> >
> > I have many Excel files in a folder which all have labelled Worksheets
> > from 1 to X where X is always an integer.
> >
> > Most of the files have about 10 worksheets, and these can have both
> > text and pictures in.
> >
> > I have searched, for some code (to no avail and through quite a few
> > forums!!), that would copy the content of the worksheets in numeric
> > order to a blank Word document.
> >
> > I am using 2010, and ideally would like to select any number of files
> > and even perhaps the order(!) that they can be pasted into Word.
> >
> > Hope you guys can help.
> >
> > --
> >
> ---
> -
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below linkhttp://
> www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[skyping1]

Anyone have any ideas on this please?

On Aug 3, 9:50 pm, Kevin gray  wrote:
> Please see attachments
>
> Date: Wed, 3 Aug 2011 07:48:44 +0530
> Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 
> 1 to X to Word.
> From: venkat1@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi
> There is No attachment.
>
> Best Regards,Venkat
> Chennai
>
> On Tue, Aug 2, 2011 at 10:41 PM, skyping1  wrote:
>
> Please find attached files...hope you can help
>
> On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
>
>
>
>
>
>
>
>
>
> > Please Attached  a sample file
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> > On Behalf Of skyping1
> > Sent: Tuesday, August 02, 2011 12:07 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1
> > to X to Word.
>
> > I have many Excel files in a folder which all have labelled Worksheets
> > from 1 to X where X is always an integer.
>
> > Most of the files have about 10 worksheets, and these can have both
> > text and pictures in.
>
> > I have searched, for some code (to no avail and through quite a few
> > forums!!), that would copy the content of the worksheets in numeric
> > order to a blank Word document.
>
> > I am using 2010, and ideally would like to select any number of files
> > and even perhaps the order(!) that they can be pasted into Word.
>
> > Hope you guys can help.
>
> > --
> > --- 
> > -
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below 
> > linkhttp://www.facebook.com/discussexcel
>
> --
>
> --- 
> ---
>
> Some important links for excel users:
>
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
>
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
>
> Like our page on facebook , Just follow below link
>
> http://www.facebook.com/discussexcel
>
> --
>
> --
>
> --- 
> ---
>
> Some important links for excel users:
>
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
>
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
>
> Like our page on facebook , Just follow below link
>
> http://www.facebook.com/discussexcel
>
>  Start.xlsm
> 971KViewDownload
>
>  finish.docx
> 154KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[dguillett1]

What do you need to do in Word that you can't do in excel?

-Original Message- 
From: skyping1

Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
labelled 1 to X to Word.


Anyone have any ideas on this please?

On Aug 3, 9:50 pm, Kevin gray  wrote:

Please see attachments

Date: Wed, 3 Aug 2011 07:48:44 +0530
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
labelled 1 to X to Word.

From: venkat1@gmail.com
To: excel-macros@googlegroups.com

Hi
There is No attachment.

Best Regards,Venkat
Chennai

On Tue, Aug 2, 2011 at 10:41 PM, skyping1  
wrote:


Please find attached files...hope you can help

On Aug 2, 10:23 am, "Rajan_Verma"  wrote:









> Please Attached  a sample file

> -Original Message-
> From: excel-macros@googlegroups.com 
> [mailto:excel-macros@googlegroups.com]


> On Behalf Of skyping1
> Sent: Tuesday, August 02, 2011 12:07 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
> labelled 1

> to X to Word.

> I have many Excel files in a folder which all have labelled Worksheets
> from 1 to X where X is always an integer.

> Most of the files have about 10 worksheets, and these can have both
> text and pictures in.

> I have searched, for some code (to no avail and through quite a few
> forums!!), that would copy the content of the worksheets in numeric
> order to a blank Word document.

> I am using 2010, and ideally would like to select any number of files
> and even perhaps the order(!) that they can be pasted into Word.

> Hope you guys can help.

> --
> --- 
>  -

> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip

> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

> To post to this group, send email to excel-macros@googlegroups.com

> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel


--

--- 
 ---


Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links 
:http://twitter.com/exceldailytip


2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials athttp://www.excel-macros.blogspot.com

4. Learn VBA Macros athttp://www.quickvba.blogspot.com

5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

--

--

--- 
 ---


Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links 
:http://twitter.com/exceldailytip


2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials athttp://www.excel-macros.blogspot.com

4. Learn VBA Macros athttp://www.quickvba.blogspot.com

5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel

 Start.xlsm
971KViewDownload

 finish.docx
154KViewDownload


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><>&l

RE: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

[Kevin gray]

Thanks for the reply...the issue is all previous documents (to which there are 
many 1000's are in Word.   My predecessor however wrote work instructions in 
Excel, but all written procedures should really be in a Word processing 
program, hence my question!  
There are still several hundred Excel files with instructions in each Worksheet 
labelled 1 to X which really is not a good idea (in my humble opinion) 
especially using Excel as a Word processor.
I really need some help to transfer these Excel tabs systematically to Word, so 
please help!!

> From: dguille...@gmail.com
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 
> 1 to X to Word.
> Date: Mon, 8 Aug 2011 14:40:00 -0500
> 
> What do you need to do in Word that you can't do in excel?
> 
> -Original Message- 
> From: skyping1
> Sent: Monday, August 08, 2011 12:07 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
> labelled 1 to X to Word.
> 
> Anyone have any ideas on this please?
> 
> On Aug 3, 9:50 pm, Kevin gray  wrote:
> > Please see attachments
> >
> > Date: Wed, 3 Aug 2011 07:48:44 +0530
> > Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
> > labelled 1 to X to Word.
> > From: venkat1@gmail.com
> > To: excel-macros@googlegroups.com
> >
> > Hi
> > There is No attachment.
> >
> > Best Regards,Venkat
> > Chennai
> >
> > On Tue, Aug 2, 2011 at 10:41 PM, skyping1  
> > wrote:
> >
> > Please find attached files...hope you can help
> >
> > On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > Please Attached  a sample file
> >
> > > -Original Message-
> > > From: excel-macros@googlegroups.com 
> > > [mailto:excel-macros@googlegroups.com]
> >
> > > On Behalf Of skyping1
> > > Sent: Tuesday, August 02, 2011 12:07 AM
> > > To: MS EXCEL AND VBA MACROS
> > > Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
> > > labelled 1
> > > to X to Word.
> >
> > > I have many Excel files in a folder which all have labelled Worksheets
> > > from 1 to X where X is always an integer.
> >
> > > Most of the files have about 10 worksheets, and these can have both
> > > text and pictures in.
> >
> > > I have searched, for some code (to no avail and through quite a few
> > > forums!!), that would copy the content of the worksheets in numeric
> > > order to a blank Word document.
> >
> > > I am using 2010, and ideally would like to select any number of files
> > > and even perhaps the order(!) that they can be pasted into Word.
> >
> > > Hope you guys can help.
> >
> > > --
> > > ---
> > >  
> > >  -
> > > --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links 
> > > :http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below 
> > > linkhttp://www.facebook.com/discussexcel
> >
> > --
> >
> > --- 
> >  ---
> >
> > Some important links for excel users:
> >
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> >
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> >
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><>&