$$Excel-Macros$$ help:increase the sheet number in a formula

[Sundarvelan N]

Hi Gurus,

Please help me in this formula

increase the sheet number in formula

=IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),"TRUE",0)="TRUE",TRIM(RIGHT(*
Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(":",SUBSTITUTE(*Sheet1*!$B1," ",":",LEN(*
Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1," ","")),0)

I would like to increase the *Sheet1 to sheet2, sheet3 *down the rows.


Thanks
N.Sundarvelan
9600160150

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect

[Rajan_Verma]

Sub DoSomething()

 

Sheet1.Unprotect Pwd

'Your code goes here

Sheet1.Protect Pwd

 

End sub

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: 20 October 2012 11:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect

 

Dear Friends,

 

I have an Macro / VBA enabled file with me.  If I protect the sheet which
has a VBA code, then macro doesn't work and displays the following error.
Kindly get the solution on it topic.  Thank you.

 

Inline image 1

 

Regards

Pravin Gunjal.

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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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


<>

Re: $$Excel-Macros$$

[Shrinivas Shevde]

Thanks to all
Just one question for Knowledge
I run the script by both way
1.By Making true at the end
2.Without making true at end
I could not notice any difference.
So please can any one explain me
What is the purpose of making true at end?
Aging I ma repeating this is just for Knowledge.

Regards
Shrinivas
On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma wrote:

>  *But also make them TRUE at end of code *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* 19 October 2012 5:25
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$
>
> ** **
>
> Dear Both,
>
>  
>
> Very very thanks for solution.
>
>  
>
> Regards
>
> Shrinivas
>
> On Fri, Oct 19, 2012 at 1:19 PM,  wrote:
>
> Hi
>
> Just put Application.Screenupdating = False
>
> Rgds// Vabs 
>
> ** **
>
> Sent on my BlackBerry® from Vodafone
>  --
>
> *From: *Shrinivas Shevde  
>
> *Sender: *excel-macros@googlegroups.com 
>
> *Date: *Fri, 19 Oct 2012 12:29:55 +0530
>
> *To: *
>
> *ReplyTo: *excel-macros@googlegroups.com 
>
> *Subject: *$$Excel-Macros$$
>
> ** **
>
> Dear Group member,
>
>  
>
> I wrote small macro which works fine.
>
> But when I run macro it shows all action i.e everything ishappening in
> front of user which I dont want .
>
> I want that when I run macro Worksheet should be steady and all actions
> should happen at backend.
>
> How to do it please let me know.
>
> Is ther any extra code needs to write.
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> --
> Shrini
>
> --
> 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. 

RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

[Rajan_Verma]

 

Try this 

ActiveChart.ChartArea.Format.Fill.GradientStops.Insert(RGB)

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 20 October 2012 12:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

 

Hello, all,

 

Someone asks me if it were possible to format a chart area with a gradient
fill of more than two colors. I can't find no clue to this one.

Can anyone help ?

TIA

 

Daniel

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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Excel 2007 - VBA - Chart format

[Daniel]

Hello, all,

 

Someone asks me if it were possible to format a chart area with a gradient
fill of more than two colors. I can't find no clue to this one.

Can anyone help ?

TIA

 

Daniel

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

[Mangesh Vimay]

Hi Friends,

I am using MS Access 2007.
I have table called "City".
The table "City" contains the information of the different cities of
INDIA with their details.

For example,
CityDetails
Mumbai  It is the Financial capital of India
Delhi Capital of India
I have also form for retrieving details of the city
It contains the drop down list for all cities of India
If I select Mumbai from the drop down list, then it should display the details.
However, I have another search option i.e. "Search by Keyword"
In Search by keyword, if we enter any string from the details column.
It should display all records that consists the specified string.
For example, if we enter the string "capital" in text box, then it
should display all records containing the string "capital".
I need the macro (or any other solution) to do this.
I hope, I am able to explain what I need.
I know, this group is dedicated to MS Excel only. But I also know
there are many experts who does well in Access as well.

So I request all please help me by providing suitable solutions.
Appreciate your help !!!

Thanks in Advance !!!


-- 
With regards,

*MaNgEsH*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings. *

[Hilary Lomotey]

THANKS BOSS

On Fri, Oct 19, 2012 at 5:20 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

>  [image: Boxbe]  This message is eligible
> for Automatic Cleanup! (palande.swapni...@gmail.com) Add cleanup 
> rule|
>  More
> info
>
> Hi,
>
> Try below formula.
>
> =IF(AND(A1<=-0.5,A1>=-1),"STRONG
> BUY",IF(AND(A1<=-0.2,A1>=-0.49),"BUY",IF(AND(A1<=0.19,A1>=-0.19),"HOLD",IF(AND(A1<=0.49,A1>=0.2),"STRONG
> SELL",IF(AND(A1<=1,A1>=0.5),"SELL",FALSE)
>
> Regards,
>
> Swapnik.
> On Oct 19, 2012 10:08 PM, "Hilary Lomotey"  wrote:
>
>> Hello Experts
>>
>> i need a formula such that if my results falls between the categories
>> listed below, i get the ratings eg if my result in cell A1 is -25.3% then i
>> shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating.
>>
>>
>>   -50% -100% STRONG BUY  -20% -49% BUY  -19% 19% HOLD  50% 100% SELL  20%
>> 49% STRONG SELL
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

[Constantin Zamfir]

Yes, but in the combobox "Save as type:" I don't have PDF format.

Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL  - Romania
Mobil: +40 741-105-012  (Orange)
Mobil: +40 726-226-021  (Cosmote)
*Before printing this e-mail please consider environment protection*
*
---
*
*
*



2012/10/19 

> **
> Hi,
>
> Insted of printing with the help of Nitro PDF you can save file as PDF.
>
> Rgds//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Constantin Zamfir 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Please help me to set default folder for
> print PDF's.
>
> I have a macro in an Excel document that print 5 sheets in different
> folders with different names. Always have to navigate to the desired folder
> and write the desired name, which slows my work, since I'm doing this for
> 30-50 times per day.
> I want to automate this in my macro, but I do not know how to change the
> default print folder for NitroPDF 7 and the default name for the file to be
> printed.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

[vba]

Hi,

Insted of printing with the help of Nitro PDF you can save file as PDF.

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Constantin Zamfir 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 10:35:38 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

I have a macro in an Excel document that print 5 sheets in different 
folders with different names. Always have to navigate to the desired folder 
and write the desired name, which slows my work, since I'm doing this for 
30-50 times per day. 
I want to automate this in my macro, but I do not know how to change the 
default print folder for NitroPDF 7 and the default name for the file to be 
printed.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Please help me to set default folder for print PDF's.

[Constantin Zamfir]

I have a macro in an Excel document that print 5 sheets in different 
folders with different names. Always have to navigate to the desired folder 
and write the desired name, which slows my work, since I'm doing this for 
30-50 times per day. 
I want to automate this in my macro, but I do not know how to change the 
default print folder for NitroPDF 7 and the default name for the file to be 
printed.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

[Swapnil Palande]

Hi,

Try below formula.

=IF(AND(A1<=-0.5,A1>=-1),"STRONG
BUY",IF(AND(A1<=-0.2,A1>=-0.49),"BUY",IF(AND(A1<=0.19,A1>=-0.19),"HOLD",IF(AND(A1<=0.49,A1>=0.2),"STRONG
SELL",IF(AND(A1<=1,A1>=0.5),"SELL",FALSE)

Regards,

Swapnik.
On Oct 19, 2012 10:08 PM, "Hilary Lomotey"  wrote:

> Hello Experts
>
> i need a formula such that if my results falls between the categories
> listed below, i get the ratings eg if my result in cell A1 is -25.3% then i
> shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating.
>
>
>   -50% -100% STRONG BUY  -20% -49% BUY  -19% 19% HOLD  50% 100% SELL  20%
> 49% STRONG SELL
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

[Hilary Lomotey]

Hello Experts

i need a formula such that if my results falls between the categories
listed below, i get the ratings eg if my result in cell A1 is -25.3% then i
shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating.


  -50% -100% STRONG BUY  -20% -49% BUY  -19% 19% HOLD  50% 100% SELL  20%
49% STRONG SELL

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ request to separate the no

[Shiva Prasad]

hi ashsih koul,

it is working

very thanks ,

regards,
shivaprasad.



On Fri, Oct 19, 2012 at 9:16 PM, ashish koul  wrote:

> check the attachment  see if it helps
>
>
> On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad 
> wrote:
>
>> hi ashish koul,
>>
>>  please find the attachment of example.
>>
>> i mentioned formula also but showing 0 value.
>> please provide the macro.
>>
>>
>> regards,
>> shivaprasad.
>>
>> On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote:
>>
>>> can u share any excel file with input and output u like to have
>>>
>>>
>>> On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad >> > wrote:
>>>
 hi ashish koul,

  please provide the example attachment.


 regards,
 shivaprasad.


 On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:

> try this udf
>
> Function numeric_value(x As String)
> Dim a As String
> a = ""
> For i = 1 To Len(x)
> If IsNumeric(Mid(x, i, 1)) Then
> a = a & Mid(x, i, 1)
> End If
> Next i
> numeric_value = a
> End Function
>
>
>
> On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad <
> shivaprasad1...@gmail.com> wrote:
>
>> hi experts,
>>
>> how to separate the number,
>> i mentioned in excel cell
>> please help me
>>
>> *example
>>
>> asdfhfgh9825101236sdfge,
>> 9855255689dffhjrr
>> *
>>
>> i want only number, can any one provide the macro.
>>
>>
>> regards,
>> shivaprasad.
>>
>>
>> --
>>
>>
>>
>>
>>
>> Regards,
>> Shivaprasad K.
>> +91-9866351016
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



 --





 Regards,
 Shivaprasad K.
 +91-9866351016

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

Re: $$Excel-Macros$$ request to separate the no

[ashish koul]

check the attachment  see if it helps

On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad wrote:

> hi ashish koul,
>
>  please find the attachment of example.
>
> i mentioned formula also but showing 0 value.
> please provide the macro.
>
>
> regards,
> shivaprasad.
>
> On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote:
>
>> can u share any excel file with input and output u like to have
>>
>>
>> On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad 
>> wrote:
>>
>>> hi ashish koul,
>>>
>>>  please provide the example attachment.
>>>
>>>
>>> regards,
>>> shivaprasad.
>>>
>>>
>>> On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:
>>>
 try this udf

 Function numeric_value(x As String)
 Dim a As String
 a = ""
 For i = 1 To Len(x)
 If IsNumeric(Mid(x, i, 1)) Then
 a = a & Mid(x, i, 1)
 End If
 Next i
 numeric_value = a
 End Function



 On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad <
 shivaprasad1...@gmail.com> wrote:

> hi experts,
>
> how to separate the number,
> i mentioned in excel cell
> please help me
>
> *example
>
> asdfhfgh9825101236sdfge,
> 9855255689dffhjrr
> *
>
> i want only number, can any one provide the macro.
>
>
> regards,
> shivaprasad.
>
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
> +91-9866351016
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



 --
 *Regards*
 * *
 *Ashish Koul*


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

 P Before printing, think about the environment.



  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

 6) Jobs posting is not allowed.

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

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



>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>> Shivaprasad K.
>>> +91-9866351016
>>>
>>>  --
>>> 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.
>>>

Re: $$Excel-Macros$$ request to separate the no

[Shiva Prasad]

hi ashish koul,

 please find the attachment of example.

i mentioned formula also but showing 0 value.
please provide the macro.


regards,
shivaprasad.

On Fri, Oct 19, 2012 at 9:02 PM, ashish koul  wrote:

> can u share any excel file with input and output u like to have
>
>
> On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad 
> wrote:
>
>> hi ashish koul,
>>
>>  please provide the example attachment.
>>
>>
>> regards,
>> shivaprasad.
>>
>>
>> On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:
>>
>>> try this udf
>>>
>>> Function numeric_value(x As String)
>>> Dim a As String
>>> a = ""
>>> For i = 1 To Len(x)
>>> If IsNumeric(Mid(x, i, 1)) Then
>>> a = a & Mid(x, i, 1)
>>> End If
>>> Next i
>>> numeric_value = a
>>> End Function
>>>
>>>
>>>
>>> On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad >> > wrote:
>>>
 hi experts,

 how to separate the number,
 i mentioned in excel cell
 please help me

 *example

 asdfhfgh9825101236sdfge,
 9855255689dffhjrr
 *

 i want only number, can any one provide the macro.


 regards,
 shivaprasad.


 --





 Regards,
 Shivaprasad K.
 +91-9866351016

  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

 6) Jobs posting is not allowed.

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

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



>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>>
>>>
>>> *Visit*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/*
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> Regards,
>> Shivaprasad K.
>> +91-9866351016
>>
>>  --
>> 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 ar

Re: $$Excel-Macros$$ request to separate the no

[ashish koul]

can u share any excel file with input and output u like to have


On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad wrote:

> hi ashish koul,
>
>  please provide the example attachment.
>
>
> regards,
> shivaprasad.
>
>
> On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:
>
>> try this udf
>>
>> Function numeric_value(x As String)
>> Dim a As String
>> a = ""
>> For i = 1 To Len(x)
>> If IsNumeric(Mid(x, i, 1)) Then
>> a = a & Mid(x, i, 1)
>> End If
>> Next i
>> numeric_value = a
>> End Function
>>
>>
>>
>> On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad 
>> wrote:
>>
>>> hi experts,
>>>
>>> how to separate the number,
>>> i mentioned in excel cell
>>> please help me
>>>
>>> *example
>>>
>>> asdfhfgh9825101236sdfge,
>>> 9855255689dffhjrr
>>> *
>>>
>>> i want only number, can any one provide the macro.
>>>
>>>
>>> regards,
>>> shivaprasad.
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>> Shivaprasad K.
>>> +91-9866351016
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
> +91-9866351016
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


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

Re: $$Excel-Macros$$ request to separate the no

[Shiva Prasad]

hi ashish koul,

 please provide the example attachment.


regards,
shivaprasad.

On Fri, Oct 19, 2012 at 8:55 PM, ashish koul  wrote:

> try this udf
>
> Function numeric_value(x As String)
> Dim a As String
> a = ""
> For i = 1 To Len(x)
> If IsNumeric(Mid(x, i, 1)) Then
> a = a & Mid(x, i, 1)
> End If
> Next i
> numeric_value = a
> End Function
>
>
>
> On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad 
> wrote:
>
>> hi experts,
>>
>> how to separate the number,
>> i mentioned in excel cell
>> please help me
>>
>> *example
>>
>> asdfhfgh9825101236sdfge,
>> 9855255689dffhjrr
>> *
>>
>> i want only number, can any one provide the macro.
>>
>>
>> regards,
>> shivaprasad.
>>
>>
>> --
>>
>>
>>
>>
>>
>> Regards,
>> Shivaprasad K.
>> +91-9866351016
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 





Regards,
Shivaprasad K.
+91-9866351016

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ request to separate the no

[ashish koul]

try this udf

Function numeric_value(x As String)
Dim a As String
a = ""
For i = 1 To Len(x)
If IsNumeric(Mid(x, i, 1)) Then
a = a & Mid(x, i, 1)
End If
Next i
numeric_value = a
End Function



On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad wrote:

> hi experts,
>
> how to separate the number,
> i mentioned in excel cell
> please help me
>
> *example
>
> asdfhfgh9825101236sdfge,
> 9855255689dffhjrr
> *
>
> i want only number, can any one provide the macro.
>
>
> regards,
> shivaprasad.
>
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
> +91-9866351016
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


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

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ request to separate the no

[Shiva Prasad]

hi experts,

how to separate the number,
i mentioned in excel cell
please help me

*example

asdfhfgh9825101236sdfge,
9855255689dffhjrr
*

i want only number, can any one provide the macro.


regards,
shivaprasad.


-- 





Regards,
Shivaprasad K.
+91-9866351016

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

[Sam Mathai Chacko]

This might help

http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/

Regards,
Sam

On Fri, Oct 19, 2012 at 8:24 PM, Shiva Prasad wrote:

> hi experts,
>
> how to separate the number,
> i mentioned in excel cell
> mentioned example
>
>
> *example
>
> asdfhfgh9825101236sdfge,
> 9855255689dffhjrr
> *
>
> i want only number, can any one provide the macro.
>
>
> regards,
> shivaprasad.
>
>
>
>
>
> On Fri, Oct 19, 2012 at 7:09 PM, ashish koul wrote:
>
>> hi i tried ur file its working fine at my place. Can you share the actual
>> file and output in word document
>>
>>
>>
>> On Fri, Oct 19, 2012 at 4:54 PM, amar takale wrote:
>>
>>> Pls help me on below topic
>>>
>>>
>>> On Thu, Oct 18, 2012 at 6:31 PM, amar takale wrote:
>>>
 Dear Hilary
 Your code not working it show out of range I will attached file as per
 you suggest link below It also not working Pl see file


 On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey wrote:

> try this
>
> Sub exportToWord()
>
> Dim SheetName As String, NumLines As Integer
> Dim WordApp As Object
> Set WordApp = CreateObject("Word.Application")
> WordApp.Visible = True
> Worksheets(SheetName).Range("frontcover").Copy
> 'you can replace the next line of code with
> ===>WordApp.Documents.Add.Content.Paste
> WordApp.Documents.Add.Content.PasteSpecial DataType:=wdPasteText
> Application.CutCopyMode = False
> Set WordApp = Nothing
>
> End Sub
>
> On Wed, Oct 17, 2012 at 4:51 PM, ashish koul wrote:
>
>>  [image: Boxbe]  This message is
>> eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup
>> rule|
>>  More
>> info
>>
>> share excel file and word document
>>
>> or visit
>>
>>
>> http://www.excelvbamacros.com/2011/11/find-row-and-column-number-of.html
>>
>> http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html
>>
>>
>>
>> On Wed, Oct 17, 2012 at 10:07 AM, amar takale 
>> wrote:
>>
>>> Pls help me for this solution
>>>
>>>
>>> On Tue, Oct 16, 2012 at 5:26 PM, amar takale 
>>> wrote:
>>>
 *Hi All Champs*
 Can anybody tell me how to copy paste excel table in word as it
 with formatting.So I want to VBA code for that then I will create 
 button &
 only click it So table automatically copy paste in word.For other 
 sheet in
 code I will change only range of table as per data size table & click
 button.

 please help me to solve this question
 waiting your response

 Amar


>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>> in signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>> allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/

Re: $$Excel-Macros$$ Google Map and Excel Integration Using VBA

[Sam Mathai Chacko]

This is very good Ashish. Thanks for sharing.

Regards,
Sam

On Fri, Oct 19, 2012 at 7:20 PM, ashish koul  wrote:

> Hi All,
>
> If you want to get latitude and longitude of any address   or you want to
> find the distance between two cities , etc using Google Map. Please find
> below links of macros which will automatically fetch or get data from
> Google  Maps using VBA
>
>
> Find Distance and Time between two cities using Google API In excel
>
> http://excelvbaprogramming.wordpress.com/2012/09/24/find-distance-and-time-between-two-cities-using-google-api-in-excel/
>
>
> Display Google Map in Excel using VBA and Google API
>
> http://excelvbaprogramming.wordpress.com/2012/09/24/display-google-map-in-excel-using-vba-and-google-api/
>
>
> Plot locations on Google map using VBA and Import updated map to Excel
>
> http://excelvbaprogramming.wordpress.com/2012/09/26/plot-locations-on-google-map-using-vba-and-import-updated-map-to-excel/
>
>
> Plot Origin and destination city on Google Map and import Map to Excel
>
> http://excelvbaprogramming.wordpress.com/2012/09/27/plot-origin-and-destination-city-on-google-map-and-import-map-to-excel/
>
> Google Translation Using VBA
>
> http://excelvbaprogramming.wordpress.com/2012/09/29/google-translation-using-vba/
>
> Find Latitude and Longitude of any address using Google Map API and VBA
>
> http://excelvbaprogramming.wordpress.com/2012/10/18/find-latitude-and-longitude-of-any-address-using-google-map-api-and-vba/
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Sam Mathai Chacko

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

[ashish koul]

hi i tried ur file its working fine at my place. Can you share the actual
file and output in word document



On Fri, Oct 19, 2012 at 4:54 PM, amar takale  wrote:

> Pls help me on below topic
>
>
> On Thu, Oct 18, 2012 at 6:31 PM, amar takale  wrote:
>
>> Dear Hilary
>> Your code not working it show out of range I will attached file as per
>> you suggest link below It also not working Pl see file
>>
>>
>> On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey wrote:
>>
>>> try this
>>>
>>> Sub exportToWord()
>>>
>>> Dim SheetName As String, NumLines As Integer
>>> Dim WordApp As Object
>>> Set WordApp = CreateObject("Word.Application")
>>> WordApp.Visible = True
>>> Worksheets(SheetName).Range("frontcover").Copy
>>> 'you can replace the next line of code with
>>> ===>WordApp.Documents.Add.Content.Paste
>>> WordApp.Documents.Add.Content.PasteSpecial DataType:=wdPasteText
>>> Application.CutCopyMode = False
>>> Set WordApp = Nothing
>>>
>>> End Sub
>>>
>>> On Wed, Oct 17, 2012 at 4:51 PM, ashish koul wrote:
>>>
  [image: Boxbe]  This message is
 eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup
 rule|
  More
 info

 share excel file and word document

 or visit

 http://www.excelvbamacros.com/2011/11/find-row-and-column-number-of.html

 http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html



 On Wed, Oct 17, 2012 at 10:07 AM, amar takale wrote:

> Pls help me for this solution
>
>
> On Tue, Oct 16, 2012 at 5:26 PM, amar takale wrote:
>
>> *Hi All Champs*
>> Can anybody tell me how to copy paste excel table in word as it with
>> formatting.So I want to VBA code for that then I will create button & 
>> only
>> click it So table automatically copy paste in word.For other sheet in 
>> code
>> I will change only range of table as per data size table & click button.
>>
>> please help me to solve this question
>> waiting your response
>>
>> Amar
>>
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



 --
 *Regards*
 * *
 *Ashish Koul*


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

 P Before printing, think about the environment.



  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

 6) Jobs posting is not allowed.

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

RE: $$Excel-Macros$$

[Rajan_Verma]

But also make them TRUE at end of code 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 19 October 2012 5:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$

 

Dear Both,

 

Very very thanks for solution.

 

Regards

Shrinivas

On Fri, Oct 19, 2012 at 1:19 PM,  wrote:

Hi

Just put Application.Screenupdating = False

Rgds// Vabs 

 

Sent on my BlackBerryR from Vodafone

  _  

From: Shrinivas Shevde  

Sender: excel-macros@googlegroups.com 

Date: Fri, 19 Oct 2012 12:29:55 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$

 

Dear Group member,

 

I wrote small macro which works fine.

But when I run macro it shows all action i.e everything ishappening in front
of user which I dont want .

I want that when I run macro Worksheet should be steady and all actions
should happen at backend.

How to do it please let me know.

Is ther any extra code needs to write.

-- 
Shrini

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

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




-- 
Shrini

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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) D

Re: $$Excel-Macros$$

[Vabz]

Hi

Also dont forget to put a the end..

application.displayalerts = true

Application.screenupdating= true

Else user will wonder whats going wrong..

Rgds//Vabs

On Friday, October 19, 2012 5:25:18 PM UTC+5:30, shrini wrote:
>
> Dear Both,
>  
> Very very thanks for solution.
>  
> Regards
> Shrinivas
>
> On Fri, Oct 19, 2012 at 1:19 PM, > wrote:
>
>> ** 
>> Hi
>>
>> Just put Application.Screenupdating = False
>>
>> Rgds// Vabs 
>>
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: *Shrinivas Shevde > 
>> *Sender: *excel-...@googlegroups.com  
>> *Date: *Fri, 19 Oct 2012 12:29:55 +0530
>> *To: *>
>> *ReplyTo: *excel-...@googlegroups.com  
>> *Subject: *$$Excel-Macros$$
>>
>>  Dear Group member,
>>  
>> I wrote small macro which works fine.
>> But when I run macro it shows all action i.e everything ishappening in 
>> front of user which I dont want .
>> I want that when I run macro Worksheet should be steady and all actions 
>> should happen at backend.
>> How to do it please let me know.
>> Is ther any extra code needs to write.
>>
>> -- 
>> Shrini
>>
>> -- 
>> 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-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>  
>> -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> 6) Jobs posting is not allowed.
>>  
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>
>
>
>
> -- 
> Shrini
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Re: Pls Help Me on this

[NOORAIN ANSARI]

Brother send a sample sheet.


On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली
wrote:

> suppose there is one two excel file
> one is A
> second is B
> in A file there is 2 fields like (Shiptocode) and (Productcode).
> in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type)
> Type field is only two value (TRUE or FALSE) and (DP) and (RSP).
> i have inserted and new field in A file beside Productcode say (Price).
> now under (Price) i want the value.
> if Shiptocode and productcode of A file match with B file Shiptocode and
> productcode and the (Type) field is TRUE then it should take DP field value
> of B file and if (Type) field is FALSE then it should take (RSP) value from
> B file.
>
>
> Pls Help me on this. ITs Urgent
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>



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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$

[Shrinivas Shevde]

Dear Both,

Very very thanks for solution.

Regards
Shrinivas

On Fri, Oct 19, 2012 at 1:19 PM,  wrote:

> **
> Hi
>
> Just put Application.Screenupdating = False
>
> Rgds// Vabs
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: *Shrinivas Shevde 
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 12:29:55 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$
>
>  Dear Group member,
>
> I wrote small macro which works fine.
> But when I run macro it shows all action i.e everything ishappening in
> front of user which I dont want .
> I want that when I run macro Worksheet should be steady and all actions
> should happen at backend.
> How to do it please let me know.
> Is ther any extra code needs to write.
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

[amar takale]

Pls help me on below topic

On Thu, Oct 18, 2012 at 6:31 PM, amar takale  wrote:

> Dear Hilary
> Your code not working it show out of range I will attached file as per you
> suggest link below It also not working Pl see file
>
>
> On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey wrote:
>
>> try this
>>
>> Sub exportToWord()
>>
>> Dim SheetName As String, NumLines As Integer
>> Dim WordApp As Object
>> Set WordApp = CreateObject("Word.Application")
>> WordApp.Visible = True
>> Worksheets(SheetName).Range("frontcover").Copy
>> 'you can replace the next line of code with
>> ===>WordApp.Documents.Add.Content.Paste
>> WordApp.Documents.Add.Content.PasteSpecial DataType:=wdPasteText
>> Application.CutCopyMode = False
>> Set WordApp = Nothing
>>
>> End Sub
>>
>> On Wed, Oct 17, 2012 at 4:51 PM, ashish koul wrote:
>>
>>>  [image: Boxbe]  This message is
>>> eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup 
>>> rule|
>>>  More
>>> info
>>>
>>> share excel file and word document
>>>
>>> or visit
>>>
>>> http://www.excelvbamacros.com/2011/11/find-row-and-column-number-of.html
>>>
>>> http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html
>>>
>>>
>>>
>>> On Wed, Oct 17, 2012 at 10:07 AM, amar takale wrote:
>>>
 Pls help me for this solution


 On Tue, Oct 16, 2012 at 5:26 PM, amar takale wrote:

> *Hi All Champs*
> Can anybody tell me how to copy paste excel table in word as it with
> formatting.So I want to VBA code for that then I will create button & only
> click it So table automatically copy paste in word.For other sheet in code
> I will change only range of table as per data size table & click button.
>
> please help me to solve this question
> waiting your response
>
> Amar
>
>
  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

 6) Jobs posting is not allowed.

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

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



>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>>
>>>
>>> *Visit*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/*
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.

Re: $$Excel-Macros$$ Pls Help Me on this

[NOORAIN ANSARI]

Anil, if possible pls share a sample sheet with group.

On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली
wrote:

> suppose there is one two excel file
> one is A
> second is B
> in A file there is 2 fields like (Shiptocode) and (Productcode).
> in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type)
> Type field is only two value (TRUE or FALSE) and (DP) and (RSP).
> i have inserted and new field in A file beside Productcode say (Price).
> now under (Price) i want the value.
> if Shiptocode and productcode of A file match with B file Shiptocode and
> productcode and the (Type) field is TRUE then it should take DP field value
> of B file and if (Type) field is FALSE then it should take (RSP) value from
> B file.
>
>
> Pls Help me on this. ITs Urgent
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Pls Help Me on this

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

suppose there is one two excel file
one is A
second is B
in A file there is 2 fields like (Shiptocode) and (Productcode).
in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type)
Type field is only two value (TRUE or FALSE) and (DP) and (RSP).
i have inserted and new field in A file beside Productcode say (Price).
now under (Price) i want the value.
if Shiptocode and productcode of A file match with B file Shiptocode and
productcode and the (Type) field is TRUE then it should take DP field value
of B file and if (Type) field is FALSE then it should take (RSP) value from
B file.


Pls Help me on this. ITs Urgent


-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ How to crack the VBA password

[Pravin Gunjal]

*Dear Friend,*
*
*
*Can you update on this please.*
*
*
*Regards*
*Pravin Gunjal*
*
*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$

[vba]

Hi

Just put Application.Screenupdating = False

Rgds// Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Shrinivas Shevde 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 12:29:55 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 

Dear Group member,

I wrote small macro which works fine.
But when I run macro it shows all action i.e everything ishappening in
front of user which I dont want .
I want that when I run macro Worksheet should be steady and all actions
should happen at backend.
How to do it please let me know.
Is ther any extra code needs to write.

-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ need formula

[Kuldeep Singh]

Hi Rajesh,

Try this one.

For Max: =MAX(IF(ISERROR(A2:A40),0,A2:A40))
For Min: =MIN(IF(ISERROR(A2:A40),40,A2:A40))

With Ctrl+Shift+Enter.

Regards,
Kuldeep Singh

On Fri, Oct 19, 2012 at 1:05 PM, NOORAIN ANSARI wrote:

> Dear Rajesh,
>
> Please try it..
> =MAX(IF(ISERROR(A2:A40),0,A2:A40))
>
> =MIN(IF(ISERROR(A2:A40),0,A2:A40))
>
>
>
> On Fri, Oct 19, 2012 at 12:54 PM, Rajesh Agarwal wrote:
>
>> Dear Sir
>> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
>> other than numbers.
>> rgds
>>
>> --
>> *Rajesh Kumar Agarwal*
>> *9811063001*
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ need formula

[NOORAIN ANSARI]

Dear Rajesh,

Please try it..
=MAX(IF(ISERROR(A2:A40),0,A2:A40))

=MIN(IF(ISERROR(A2:A40),0,A2:A40))


On Fri, Oct 19, 2012 at 12:54 PM, Rajesh Agarwal  wrote:

> Dear Sir
> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
> other than numbers.
> rgds
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



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

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ need formula

[Aamir Shahzad]

 Following formulas for Max & Min with C+S+E

=MAX(IF(ISNUMBER(A2:A40),A2:A40))
=MIN(IF(ISNUMBER(A2:A40),A2:A40))

Regards,

Aamir Shahzad

On Fri, Oct 19, 2012 at 12:24 PM, Rajesh Agarwal  wrote:

> Dear Sir
> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
> other than numbers.
> rgds
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ need formula

[Rajesh Agarwal]

Dear Sir
I need formula in b2 and c2 max and minimum value of a2:a40 excluding other
than numbers.
rgds

-- 
*Rajesh Kumar Agarwal*
*9811063001*

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




need formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$

[koul . ashish]

Use 
application.displayalerts = false

Application.screenupdating= false
At the beginning of code

And turn them true at the end of code before end sub
   
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Shrinivas Shevde 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 12:29:55 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 

Dear Group member,

I wrote small macro which works fine.
But when I run macro it shows all action i.e everything ishappening in
front of user which I dont want .
I want that when I run macro Worksheet should be steady and all actions
should happen at backend.
How to do it please let me know.
Is ther any extra code needs to write.

-- 
Shrini

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

6) Jobs posting is not allowed.

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

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