$$Excel-Macros$$ Issue with English (United States) number format to Germany(Germany) Number format

[Divaker Pandey]

I have an issue with English (United States) number format to
Germany(Germany) Number format
I am downloading data form a webpage those are available in English (United
States) on worksheet using Query table on machine that is having
Germany(Germany) Number format settings.

As Excel Query table download data data it converts automatically from US
to German format like below

-71.69578162 convert into -7169578162

Please suggest me workaround it.

Divaker Pandey

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ find exact value contains special characters like *, ?, #, " excel cells using match function

[Divaker Pandey]

say if cell a1 contains a text 
and a2 contains aaa*
and i used match function =match("aaa*",A1:A2",0)
it should return 2

Thanks

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ help in Excel Add-ins

[Divaker Pandey]

1. I need to made a macro-enabled workbook (like add-in).
2. Which should have a visible formatted input tab and one Read Me tab, and
other hidden tab
3. In Input tab  will have be definite number of rows and columns with
detailed captions
4. User will use this tab to input their required data.
5. and finally he can get resultant output on the basis of input data.
which data can be used by user on their own need.


finally user can install my addin in their own workbook. and he should able
to visible and entry data add-in worksheet( "Read ME, InputTab).

Regards
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Is it possible to visible an Add ins own worksheets when it installed with a new workbook.

[Divaker Pandey]

Hi Experts,


I created an add-in in excel 2010, having multiple worksheets with custom
menu. I need when this add ins installed with another workbook, add-ins tab
must be visible, is it possible?

Regards,
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Is it possible to visible an Add ins own tab when it installed with a new workbook.

[Divaker Pandey]

Hi Expert,

Is it possible to visible an Add ins own tab when it installed with a new
workbook.

Regards,

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel -Tally Integration through XML

[Divaker Pandey]

hi expert,

can any one provide me a code sample to integrate excel with tally via XML?

Expert please suggest me steps to follow for integration.

Regards,
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel 2007 & Excel 2010

[Divaker Pandey]

hi expert ,

below code take different execution time on Excel 2007 and Excel 2010
Excel2007 =20 Sec
Excel2010 =1 sec
can any one suggest what may be reason

Thanks
Regards,



Sub ImportXMLtoList(shtTemp As Worksheet, strTargetFile As String)

Dim wb As Workbook
shtTemp.UsedRange.Clear
 Debug.Print Format(Time, "HH:MM:SS:MS")
 With Application
   .ScreenUpdating = False
   .DisplayAlerts = False

 Set wb = Workbooks.OpenXML(Filename:=strTargetFile,
LoadOption:=xlXmlLoadImportToList)
  .DisplayAlerts = True
Debug.Print Format(Time, "HH:MM:SS:MS")
 wb.Sheets(1).UsedRange.Copy
ThisWorkbook.Sheets(shtTemp.Name).Range("A1")
 wb.Close False


 .ScreenUpdating = True
End With

Debug.Print Format(Time, "HH:MM:SS:MS")
End Sub

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ how to create add-in

[Divaker Pandey]

http://www.cpearson.com/excel/createaddin.aspx

use above link
Divaker Pandey


On Thu, Jun 26, 2014 at 2:23 PM, Satendra kumar 
wrote:

> Hi All,
>
> i have same query...
>
>
> thanks
> satendra
>
>
> On Thu, Jun 26, 2014 at 1:51 PM,  wrote:
>
>> Sir,
>> how create add in and show in menu list in office 2007
>> ex: calc (add in)
>>
>>
>> home, calc, insert, page layout etc
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Thanks & Regards
> Satendra Kumar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Export data from excel to tally.

[Divaker Pandey]

hi experts,

Is there any way to export data from excel to Tally 9.0

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Help

[Divaker Pandey]

you can use pivot table option


On Fri, Jun 13, 2014 at 1:23 AM, Imran Khan  wrote:

> Dear All,
>
> I need your help to summarize the sheet. I have attach the file as an
> example. I am looking formula to summarize matching with T1A, T1R & T2 from
> Data sheet.
>
> Please help me.
>
> I applogise for file size 460KB as i am trying to reduce, but i am unable.
>
> Thanks & Regards,
>
> *Imran Khan*
>
> *Lead Planner - OR/CSU*
>
> Ras Al-Khair Industrial City
>
> P.O. Box 11342, Jubail Industrial City – 31961,
>
> Saudi Arabia
>
> Mobile Phone: +966-555160349
>
> Email : kha...@mac.maaden.com.sa
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ help required urgently

[Divaker Pandey]

1. change date format in d/mm/
2. change text to column
3.now use date function to combined date again

Divaker


On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan
wrote:

>  Dear experts,
>
>
>
> We have givne below date format how to convert right format of date like
> 13-Jan-2014
>
>
>
> TT Modified Date & Time
>
> 13/01/2014
>
> 15/01/2014 19:51
>
> 2-Nov-14
>
> 1-Jun-14
>
> 2-Nov-14
>
> 15/01/2014 19:57
>
> 1-Jun-14
>
> 13/01/2014 17:10
>
> 15/01/2014 19:47
>
> 18/01/2014 15:44
>
>
>
>
>
>
>
> [image: Description: Description: image001]
>
> *Neeraj Chauhan*
>
> *+91-9756706350*
>
>
>
>
> --
>
>
> This email is free from viruses and malware because avast! 
> Antivirusprotection is active.
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
<>

Re: $$Excel-Macros$$ Need Book for Web scrpting by vba excel

[Divaker Pandey]

please explain what is your purpose.

Divaker


On Wed, Mar 26, 2014 at 10:45 AM, pramodb35  wrote:

> Hi Excel Expert,
>
> I am Pramod. Any have idea that any kind of book available in market for
> Web scrpting by excel vba
> I am newly developer of excel vba. and also suggest me that can i use
> macro recorder  code in my real code. And give me suggest that how can i
> expert in vba programming.
>
> I will look forward for ur appreciate help.
>
> Thanks
> Pramod
> VBA Developer
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

[Divaker Pandey]

best way to calculate date difference.

using text function.

See in attached sheet.

Divaker


On Thu, Mar 27, 2014 at 2:25 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:

> Thanks All ! .. It worked
>
>
> On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar 
> wrote:
>
>> Hi Priyanka,
>>
>> PFA
>>
>>
>> Thanks
>> Ashish
>>
>>
>> On 23 March 2014 17:35, Priyanka Sachdeva > > wrote:
>>
>>> Thanks Abhishek,
>>>
>>> Yes, I did see the formula. Never knew it would be that straight forward
>>>
>>> Will give it a try and keep you posted. Really appreciate the help !
>>>
>>>
>>>
>>> Regards,
>>> Priyanka S
>>>
>>>
>>> On Sun, Mar 23, 2014 at 12:44 AM, Abhishek Jain 
>>> wrote:
>>>
 Yes, it will. As long as the dates and times are in correct format so
 as Excel reads them as values to allow subtraction, it will work. I just
 used simple subtraction and set the format show only minutes. See 'Format
 Cell' tab on the result for more clarity.

 Regards,
 Abhishek


 On Sat, Mar 22, 2014 at 9:02 PM, Priyanka Sachdeva <
 priyanka.sachdeva...@gmail.com> wrote:

> Thanks a lot for the prompt response .. will give this a try
>
> 1 questions. Would this formula still work if the cell values are as
> below
>
> Inception Date = 02-12-2014  10:26:12 AM  (mm-dd-yyy  hr:mm:ss)
>Closure Date = 02-12-2014  10:29:00 PM
>
> i.e it has a AM and PM instead of a 24 hour clock (eg 10:29:00 PM
> instead of 22:29:00)
>
>
> Regards,
> Priyanka S
>
>
> On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain  > wrote:
>
>> Please see attached.
>>
>> HTH
>>
>>
>> On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva <
>> priyanka.sachdeva...@gmail.com> wrote:
>>
>>> Hello All,
>>>
>>> Am looking to calculate the difference in minutes between 2 dates. (
>>> Inception Date and Closure Date)
>>>
>>> Eg : Inception Date = 02-12-2014  10:26:12  (mm-dd-yyy  hr:mm:ss)
>>>Closure Date = 02-12-2014  22:29:00
>>>
>>>
>>> I need a formula to calculate the difference in minutes i between
>>> these 2 dates. have to do it for a bulk of records.
>>>
>>> Did go through a few earlier posts but could not find anything that
>>> would work. Hope some1 could help me with it
>>>
>>> Thanks in Advance !
>>>
>>> Regards,
>>> Priyanka S
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>

Re: $$Excel-Macros$$ extracting zip codes from addresses

[Divaker Pandey]

can you provide please sample file.

Divaker


On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote:

> hi everyone
>
> i have looked around most postings here but none was similar to my
> situation.
>
> i need help please, or kindly pls suggest me where i can get help.
>
> everyday i received about 100 customers' addresses. it is in 1 row for
> each address, but all the address details are lumped into 1 cell.
>
> the house number, building name, street name, city, state and zipcode are
> all lumped into 1 cell, so it makes zip code sorting impossible. the
> placing of the zip code itself  in the addresses are not even fixed.
>
> the zip codes are made of only 5 digit long numbers eg 01234 or 23456 etc
> etc (malaysia zip codes).
>
> so the macros should find the zip code in the cell and copy it to the next
> cell on the right. then go to the next row below and do the same.
> this way i can do the zip code sorting.
>
> please help. tia
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Challenge for experts

[Divaker Pandey]

 Excel (2007) intermittently adds the full pathname of the add-in to the
function name when it's used in a cell formula. Then if the spreadsheet is
opened on another computer, even if the other computer has the add-in
installed, the function is not recognized. Any idea how to solve this?

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel Add in

[Divaker Pandey]

 Excel (2007) intermittently adds the full pathname of the add-in to the
function name when it's used in a cell formula. Then if the spreadsheet is
opened on another computer, even if the other computer has the add-in
installed, the function is not recognized. Any idea how to solve this?

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Formula

[Divaker Pandey]

i think you want

=VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0))



On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:

> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4  Audi A4 A6 A8 A10  BMW Series
> 3 Series 5 Series 7 X6  Mercedes A Class C Class E Class S Class
> Brand Model Answer   BMW Model - 2 Series 5
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

[Divaker Pandey]

what is this dear?

Divaker


On Thu, Mar 20, 2014 at 9:18 PM, mrExcel4u  wrote:

> Try thishope it will help you...
>
> Sub test()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> Dim rng As Range
> Dim cell As Range
>
> Set rng = Application.InputBox("Select a range", Type:=8)
> j = 1
> For Each cell In rng
>
> If cell.DisplayFormat.Interior.Color <> 16777215 Then
> rcount = Sheets(2).Cells(Rows.Count, 1).End(xlUp).Row
> cell.Cut Destination:=Sheets(2).Range("A" & j)
> j = j + 1
> End If
>
> Next
> rng.SpecialCells(xlCellTypeBlanks).Select
> Selection.Delete Shift:=xlUp
> Range("A1").Select
>
> Application.DisplayAlerts = True
> Application.ScreenUpdating = True
>
> End Sub
>
>
>
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
>
> On Thu, Mar 20, 2014 at 6:12 PM, Vabs  wrote:
>
>> Hi
>>
>> What exactly you are looking for in VBA.
>>
>> Thx
>>
>>
>> On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote:
>>
>>> Hi Expert,
>>>
>>> can any one please share code to retrieve already applied conditional
>>> formatting on a cell or range of excel workbook through vba.
>>>
>>>
>>> Thank & Regards,
>>>
>>> Divaker
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, C

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

[Divaker Pandey]

use below code

Sub sortCellsValue()
 Dim tempStr As String, resultSet As String
 Dim tempstrArr() As String
 Dim i As Integer
 For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
  tempstrArr = Split(cl.Value, ",")
   tempstrArr = removeDuplicate(tempstrArr)
   For i = 0 To UBound(tempstrArr)
For j = i + 1 To UBound(tempstrArr)
 If (Trim(tempstrArr(i)) > Trim(tempstrArr(j))) Then
 tempStr = tempstrArr(i)
 tempstrArr(i) = tempstrArr(j)
 tempstrArr(j) = tempStr
  End If
Next
Next

tempStr = Join(tempstrArr, ",")
  cl.Offset(0, 1).Value = tempStr
 Next
 End Sub


Function removeDuplicate(tempstrArr() As String) As String()
Dim i As Integer, j As Integer, count As Integer
Dim newArr() As String

For i = 0 To UBound(tempstrArr)
For j = 0 To count
 If (Trim(tempstrArr(i)) = Trim(tempstrArr(j))) Then
  Exit For
  End If
  Next
  If j = count Then
   ReDim Preserve newArr(count)
newArr(count) = tempstrArr(i)
count = count + 1
   End If

Next

removeDuplicate = newArr
End Function



On Thu, Mar 20, 2014 at 3:44 PM, Deepak Rawat wrote:

> Hi Dipanke,
>
> One more query i have, please do me favor
> I have lots of cells which contains duplicate comma desperated values like
> given below
>
> Audi, BMW, Audi
> BMW, BMW, Toyota
> Honda, Toyota, BMW, Honda
>
> After cleaning it should be look like below:
>
> Audi, BMW
> BMW, Toyota
> BMW, Honda, Toyota
>
>
>
> could duplicate value be deleted by macro, kindly help
>
> Regards,
> Deepak Rawat
>
>
>
> On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote:
>
>> use this macro
>>
>>
>> Sub sortCellsValue()
>>  Dim tempStr As String, resultSet As String
>>  Dim tempStrArr() As String
>>  Dim i As Integer
>>  For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
>>   tempStrArr = Split(cl.Value, ",")
>>
>>For i = 0 To UBound(tempStrArr)
>> For j = i + 1 To UBound(tempStrArr)
>>  If (Trim(tempStrArr(i)) > Trim(tempStrArr(j))) Then
>>   tempStr = tempStrArr(i)
>>   tempStrArr(i) = tempStrArr(j)
>>   tempStrArr(j) = tempStr
>>  End If
>> Next
>> Next
>>
>> tempStr = Join(tempStrArr, ",")
>>   cl.Offset(0, 1).Value = tempStr
>>  Next
>>  End Sub
>>
>>
>> On Thu, Mar 20, 2014 at 2:30 PM, Deepak Rawat wrote:
>>
>>> yes but its very time consuming to do mannually sort...
>>>
>>>
>>>
>>> On Thu, Mar 20, 2014 at 2:26 PM, VJ IR  wrote:
>>>
>>>> Have u tried using text to columns??
>>>>
>>>> Its a simple way to do so.
>>>>
>>>> Regards,
>>>> Vijay Iyer
>>>> On 20 Mar 2014 14:23, "Deepak Rawat"  wrote:
>>>>
>>>>> Dear All,
>>>>>
>>>>> I have attached a sheet with rawa data  & final data.
>>>>>
>>>>> I need a macro to sort coma separated data in each cell, like example
>>>>> is given below:
>>>>>
>>>>> NDTV, BBC, Aaj Tak, Facebook we need to change it as below
>>>>>
>>>>> *Aaj Tak, BBC, Facebook, NDTV*
>>>>>
>>>>> i have lots of data to sort, but not getting any solution to do quickly
>>>>>
>>>>> Thanks & Regards,
>>>>> Deepak
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members ar

Re: $$Excel-Macros$$ Split Workbook into many sheets

[Divaker Pandey]

use below code

Sub createSheet()
Dim cpyRng As String, EmpCode As String, EmpDtl As String
Dim i As Integer
Dim totRow As Integer, RecStartRow As Integer, RecEndRow As Integer
Dim cpyFlag As Boolean
totRow = 190

For i = 8 To totRow
If InStr(ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value, "** Code & Name
:-") > 0 Then
 EmpDtl = ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value
 RecStartRow = i
 EmpCode = Mid(EmpDtl, InStr(EmpDtl, "-") + 4, InStr(InStr(EmpDtl, "-") +
4, EmpDtl, " ") - InStr(EmpDtl, "-") - 4)
End If

If InStr(ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value, "Present") > 0
Then
 RecEndRow = i
 cpyFlag = True
End If

If cpyFlag = True Then
 cpyRng = "A" & RecStartRow & ":" & "N" & RecEndRow
 Call MakeNewSheet(cpyRng, EmpCode)
 cpyFlag = False
End If
Next


End Sub


Sub MakeNewSheet(cpyRng As String, shtName As String)

ThisWorkbook.Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name =
shtName


ThisWorkbook.Worksheets("Sheet1").Range("B6:K6").Copy
ThisWorkbook.Worksheets(shtName).Range("B6:K6").PasteSpecial

ThisWorkbook.Worksheets("Sheet1").Range(cpyRng).Copy
ThisWorkbook.Worksheets(shtName).Range("A8").PasteSpecial

Application.Goto ThisWorkbook.Worksheets(shtName).Range("A1"), True
Application.CutCopyMode = False



End Sub



On Thu, Mar 20, 2014 at 2:27 PM, Abhishek Jain wrote:

> Dear Experts,
>
> Attached along is a sample workbook wherein attendance records of
> employees are mentioned. The file is generated through a time-keeping
> software and is always in the same format as is attached.
>
> I need to make separate sheets (not files, just sheets or tabs in the
> existing file only) for each of the employees. The records can be
> distinguished on the basis of code number and the sheets too can be named
> as code number for all employees.
>
> Let me know if further details are required.
>
> Any and all help is hugely appreciated.
>
> Thanks & regards,
>
> Abhishek
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

[Divaker Pandey]

use this macro


Sub sortCellsValue()
 Dim tempStr As String, resultSet As String
 Dim tempStrArr() As String
 Dim i As Integer
 For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
  tempStrArr = Split(cl.Value, ",")

   For i = 0 To UBound(tempStrArr)
For j = i + 1 To UBound(tempStrArr)
 If (Trim(tempStrArr(i)) > Trim(tempStrArr(j))) Then
  tempStr = tempStrArr(i)
  tempStrArr(i) = tempStrArr(j)
  tempStrArr(j) = tempStr
 End If
Next
Next

tempStr = Join(tempStrArr, ",")
  cl.Offset(0, 1).Value = tempStr
 Next
 End Sub


On Thu, Mar 20, 2014 at 2:30 PM, Deepak Rawat wrote:

> yes but its very time consuming to do mannually sort...
>
>
>
> On Thu, Mar 20, 2014 at 2:26 PM, VJ IR  wrote:
>
>> Have u tried using text to columns??
>>
>> Its a simple way to do so.
>>
>> Regards,
>> Vijay Iyer
>> On 20 Mar 2014 14:23, "Deepak Rawat"  wrote:
>>
>>> Dear All,
>>>
>>> I have attached a sheet with rawa data  & final data.
>>>
>>> I need a macro to sort coma separated data in each cell, like example is
>>> given below:
>>>
>>> NDTV, BBC, Aaj Tak, Facebook we need to change it as below
>>>
>>> *Aaj Tak, BBC, Facebook, NDTV*
>>>
>>> i have lots of data to sort, but not getting any solution to do quickly
>>>
>>> Thanks & Regards,
>>> Deepak
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubsc

Re: $$Excel-Macros$$ Need Help

[Divaker Pandey]

you can get max date by the pivot table.


Regards,
Divaker


On Mon, Mar 17, 2014 at 5:47 PM, Imran khan  wrote:

> Hi Friends,
>
> I am stuck in working file where i need your help. I have attached file
> for formula.
>
> Thanks & Regards,
>
> *Imran Khan*
>
> *Lead Planner - OR/CSU*
>
> Ras Al-Khair Industrial City
>
> P.O. Box 11342, Jubail Industrial City - 31961,
>
> Saudi Arabia
>
> Mobile Phone: +966-555160349
>
> Email : kha...@mac.maaden.com.sa
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

[Divaker Pandey]

Hi Expert,

can any one please share code to retrieve already applied conditional
formatting on a cell or range of excel workbook through vba.


Thank & Regards,

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

[Divaker Pandey]

Thanks for reply.

But i need code to retrieve already applied conditional formatting.

Regards,
Divaker


On Tue, Mar 18, 2014 at 2:34 PM,  wrote:

> Try this
>
>
>
>
>
> Sub DataBarBook()
>
> Dim DB As Databar
>
> With Range("A2:A11")
>
> Set DB = Range("A2:A11").FormatConditions.AddDatabar()
>
>
>
> With DB.BarColor
>
> .Color = RGB(255, 0, 0)
>
> End With
>
> End With
>
> End Sub
>
>
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* Tuesday, March 18, 2014 2:06 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ how to get conditional formatting code
> already applied on a cell through vba
>
>
>
> Hi Expert,
>
> can any one please share code to get applied conditional formatting on a
> cell or range of excel workbook through vba.
>
> Thank & Regards,
>
>
> Divaker
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

[Divaker Pandey]

Hi Expert,

can any one please share code to get applied conditional formatting on a
cell or range of excel workbook through vba.


Thank & Regards,

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Mouse Hover custom tool tip on chart data label.

[Divaker Pandey]

Hi Experts,

is there any way to make a Mouse Hover custom tool tip on chart in excel.

please provide your views, whether it possible or not. if possible how we
can do it,

Thanks
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ urgent Requirement

[Divaker Pandey]

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I
would like to inform you that my company has vacancy for a Software Engineer

having skill on Excel, VBA and Basic SQL.

Please forward me your resume as soon as possible if you are interested.
by providing Rating in below brackets


Basic Excel [Conditional Formatting, Text Formula, Reference Formula]

Advanced Excel[Charts, Pivot Table, Working with DataBase]

Basic VBA Excel [Excel Object, Forms]

Advanced VBA Excel [chart manipulations, Class,collections, File handling,
Error handling]


My email id is : divake...@gmail.com

In case of any query, please call me on 09582060233

company location

Nine Dimension Infotech Pvt ltd
H-72, Sector -63
Noida


Please do not be late. You can also refer your friends who match with  the
above criteria.

@Freshers - Please ignore this mail. It is only for experienced persons.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Urgent Requirement

[Divaker Pandey]

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I
would like to inform you that my company has vacancy for a Software Engineer

having skill on Excel, VBA and Basic SQL.

Please forward me your resume as soon as possible if you are interested.
by providing Rating in below brackets


Basic Excel [Conditional Formatting, Text Formula, Reference Formula]

Advanced Excel[Charts, Pivot Table, Working with DataBase]

Basic VBA Excel [Excel Object, Forms]

Advanced VBA Excel [chart manipulations, Class,collections, File handling,
Error handling]


My email id is : divake...@gmail.com

In case of any query, please call me on 09582060233

Please do not be late. You can also refer your friends who match with  the
above criteria.

@Freshers - Please ignore this mail. It is only for experienced persons.

For more details, please find the attached file.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

[Divaker Pandey]

Sorry  I can't send original file, but i am sending you a sample.


On Wed, Aug 28, 2013 at 10:40 PM, xlstime  wrote:

> I
> think it's not possible, can u  please share addin if possible?
>
> you can protect you code
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Aug 28, 2013 at 9:53 PM, Divaker Pandey wrote:
>
>> thanks for reply,
>>
>> if  user machine had installed and used same add in. then why this
>> problem remains.?
>>
>> I can't send code with excel file. is there another way to solve out this
>> problem?
>>
>> Thanks
>> Divaker
>>
>>
>> On Wed, Aug 28, 2013 at 9:21 PM, xlstime  wrote:
>>
>>> because the addin is installed in your system.. thats why another user
>>> get convert formula to addin path
>>>
>>> suggestion/solution :- you can paste your addin code in your workbook so
>>> thats no need for addin
>>>
>>> .
>>>
>>> Enjoy
>>> Team XLS
>>>
>>>
>>>
>>> On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey wrote:
>>>
>>>> I have created some functions and created an excel addin(This addin is
>>>> extracting data from other applications).
>>>>
>>>>
>>>> This create a problem as , if one user send the file to other users
>>>> ,the formula that I have written gets converted and include the path where
>>>> I had saved the addin. they have to redefine the formula again as the old
>>>> formula does not work as it includes the path from Sender PC.
>>>>
>>>>
>>>> for example :
>>>>
>>>> Formula when addin is loaded : =MyFun($C13,"SALES",,"TFQ",,"LOCAL")
>>>>
>>>> This works fine
>>>>
>>>> but when user send to another user it gets converted into
>>>>
>>>> ='C:\Users\Divaker.pandey\AppData\Roaming\Microsoft\AddIns\MyLib
>>>> 1.0.xlam'!MyFun($C13,"SALES",,"TFQ",,"LOCAL")
>>>>
>>>>
>>>> Please provide me some clue to solve it,
>>>>
>>>> Thanks,
>>>>
>>>>
>>>>  --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you rec

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

[Divaker Pandey]

thanks for reply,

if  user machine had installed and used same add in. then why this problem
remains.?

I can't send code with excel file. is there another way to solve out this
problem?

Thanks
Divaker


On Wed, Aug 28, 2013 at 9:21 PM, xlstime  wrote:

> because the addin is installed in your system.. thats why another user get
> convert formula to addin path
>
> suggestion/solution :- you can paste your addin code in your workbook so
> thats no need for addin
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey wrote:
>
>> I have created some functions and created an excel addin(This addin is
>> extracting data from other applications).
>>
>>
>> This create a problem as , if one user send the file to other users ,the
>> formula that I have written gets converted and include the path where I had
>> saved the addin. they have to redefine the formula again as the old formula
>> does not work as it includes the path from Sender PC.
>>
>>
>> for example :
>>
>> Formula when addin is loaded : =MyFun($C13,"SALES",,"TFQ",,"LOCAL")
>>
>> This works fine
>>
>> but when user send to another user it gets converted into
>>
>> ='C:\Users\Divaker.pandey\AppData\Roaming\Microsoft\AddIns\MyLib
>> 1.0.xlam'!MyFun($C13,"SALES",,"TFQ",,"LOCAL")
>>
>>
>> Please provide me some clue to solve it,
>>
>> Thanks,
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the

$$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

[Divaker Pandey]

I have created some functions and created an excel addin(This addin is
extracting data from other applications).


This create a problem as , if one user send the file to other users ,the
formula that I have written gets converted and include the path where I had
saved the addin. they have to redefine the formula again as the old formula
does not work as it includes the path from Sender PC.


for example :

Formula when addin is loaded : =MyFun($C13,"SALES",,"TFQ",,"LOCAL")

This works fine

but when user send to another user it gets converted into

='C:\Users\Divaker.pandey\AppData\Roaming\Microsoft\AddIns\MyLib
1.0.xlam'!MyFun($C13,"SALES",,"TFQ",,"LOCAL")


Please provide me some clue to solve it,

Thanks,

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ how i can heading text in a list box

[Divaker Pandey]

Thanks Van for your reply, but i need to add header text by vba code, where
item will be add on user need at run time.


On Wed, Aug 14, 2013 at 9:57 PM, Bé Trần Văn wrote:

> Select the data and put it to one name, such as *DataList*, Copy *DataList
> * name in the Properties window and paste it into the RowSource.
>
> 2013/8/14 Divaker Pandey 
>
>>
>>
>> hi expert,
>>
>> please help me to add heading text in a list box.
>>
>> Thanks & Regards,
>>
>> Divaker
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ how i can heading text in a list box

[Divaker Pandey]

hi expert,

please help me to add heading text in a list box.

Thanks & Regards,

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ step to make and install excel 2007 add in on user machine

[Divaker Pandey]

Hi Expert,

can any one explain me how to make an add in in excel 2007, contain a user
define function. what things to keep in mind to make scalable and robust
add in.

Please also point out the steps through which a normal excel user can
install on his machine easily.

thanks

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ how to solve international decimal and comma separator issue,

[Divaker Pandey]

Hi Expert,

how to solve international  decimal and comma separator issue, it data
download from web in US Format


Thanks & Regards,
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ get data range used by chart in excel using vba

[Divaker Pandey]

thanks for your quick response.

but i couldn't get, please vabz tell me exact way, how can i get data range
used by chart.

Thanks


On Tue, Jun 25, 2013 at 6:08 PM, VBA VABZ  wrote:

> HI
>
> Pl refer:
> http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx
> Using the ChartArea Object
>
> Use the *ChartArea* property to return the *ChartArea* object. The
> following example sets the pattern for the chart area in embedded chart one
> on the worksheet named "Sheet1."
>
> Worksheets("sheet1").ChartObjects(1).Chart. _
> ChartArea.Interior.Pattern = xlLightDown
>       
> Thanks
>
>
>
> On Tue, Jun 25, 2013 at 6:00 PM, Divaker Pandey wrote:
>
>> hi expert how i can get  data range used by chart in excel using vba.
>>
>>
>> Divaker
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ get data range used by chart in excel using vba

[Divaker Pandey]

hi expert how i can get  data range used by chart in excel using vba.


Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ want to do MCA through distance education

[Divaker Pandey]

if you have caliber, willing to get knowledge then go with IGNOU. otherwise
you can join any one that approved by acte.


On Tue, Jun 11, 2013 at 8:34 PM, arvind ks  wrote:

> Hi Everybody,
>
> I want to do MCA through DISTANCE learning.
>
> Can you suggest me some good universities where i can enroll and after
> completing this i must get into a good organisation.
>
> I have got 5 years of experience.
>
> Regards
>
> Arvind K
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: VBA basic information

[Divaker Pandey]

Hi Vab,

a lot of thanks to share  the topics to cover for a vba developer.

this group is famous, bcz it have member like you.

please continue keep excelling.

It will be better if you share some information for error handling
technique in VBA.

Divaker



On Sun, Jun 9, 2013 at 12:19 PM, Vabz  wrote:

>
> Hi
>
> Refer attachment
>
> HTH//Vabs
> On Sunday, June 9, 2013 12:13:07 PM UTC+5:30, dada...@gmail.com wrote:
>>
>>
>> Can anyone provide me the below queries information to my email-
>> dada...@gmail.com
>>
>> Thank you.
>>
>> In order to put together the VBA contents rapidly, I request you to
>> please gather some details on the below topics.
>>
>> 1. VBA Data type
>>
>>   * Brief explanation of all the VBA data types
>>
>>   * Variables, Naming rules, Declaration
>>
>> * Different Scopes of variables (Procedure or Local Level,
>> Module Level, Public)
>>
>>   * Static variables and scope
>>
>> * VBA operators (Arithmetic, Logical and Relational)
>>
>>   * Converting one data type to another of variables (Just
>> introduction is sufficient)
>>
>>
>>
>> 2. Application.InputBox
>>
>>   * Brief introduction
>>
>>   * Examples
>>
>>
>>
>> 3. Error handling Techniques
>>
>>   * Using On Error Resume Next
>>
>>   * Using On Error GoTo 0
>>
>>   * Using On Error GoTo label
>>
>>   * Brief summary and Examples
>>
>>
>>
>> I guess this much is sufficient for you as of now. For your information,
>> I am currently working on the below concepts
>>
>> 1. Decision making statements
>>
>>
>>
>>   IF/ IF ELSE/ IF ELSEIF ELSE
>>
>>   SELECT CASE
>>
>>   Brief summary and examples
>>
>>
>>
>> 2. Looping Statements
>>
>>   * FOR i NEXT
>>
>>   * FOR Each NEXT
>>
>>   * DO WHILE
>>
>>   * WHILE WEND
>>
>>   * Brief summary and Examples
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Require code Double Click To Copy Data To Another Worksheet

[Divaker Pandey]

means you want to create new one worksheet or copy data on existing sheet.

how ever according your question

please use following code in thisworkbook module


Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
Target As Range, Cancel As Boolean)
ActiveWorkbook.Sheets(Sh.Name).Copy
After:=ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count)

End Sub




On Sun, Jun 9, 2013 at 9:24 PM, SAJID MEMON  wrote:

> Dear Experts, I require in excel 2003 platform
> Double Click To Copy Data To Another Worksheet sample temple require in
> excel 2003.
>
> please give me above thing.
>
> awaiting your reply,
> Regards
> Sajid Memon
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Problem in file..?

[Divaker Pandey]

are using formula in sheet?, i hope there are refrences of some other files
that may be closed. it may reason you file taking more time to calculate.




On Thu, May 23, 2013 at 8:05 PM, Divaker Pandey  wrote:

> are using formula in sheet?, i hope there are refrences of some other
> files.
>
>
> On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR wrote:
>
>> Respected Prabhu,
>>
>> You are saying that the sheet is companies sheet.Is is password protected
>> or are any user rights restricted to used and to modify or make any changes
>> to the file.Check also for version based compatibility issues because
>> earlier version had lower data input and processing capabilities compared
>> to the latest versions.Increasing you systems processor speed may also
>> solve the problem.If you do not have much data in the file crate a fresh
>> file with the same data because many time by some error the file gets
>>  corrupted and the new file works perfectly alright without any problems.To
>> know how much processing memory and time is  consumed by excel during the
>> stuck time start the Task manager and go to processes tab and search for
>> excel in the process. I think the processing time and memory used will be
>> more during that period.the problem can only be dealt with specifically if
>> only we know what exactly is causing the problem.
>>
>> Regards,
>> VIJAYKUMAR
>>
>>
>> On Thu, May 23, 2013 at 5:23 PM, Prabhu Pinky wrote:
>>
>>> No david..that sheet contains no macros, even very less formula. Only
>>> the thing is some cells have formatted...
>>>
>>> Prabhu R
>>> On May 23, 2013 5:20 PM, "David Grugeon"  wrote:
>>>
>>>> Also do you have macros which are run when changes are made to the
>>>> sheets.  It may be possible to reorganise them so they run faster or are
>>>> not triggered so readily.
>>>>
>>>> Regards
>>>> David Grugeon
>>>>
>>>>
>>>>
>>>> On 23 May 2013 21:47, David Grugeon  wrote:
>>>>
>>>>> Try setting the calculation to Manual.  Then see if Cut and Paste
>>>>> still takes a lot of time.  It could be that there are a lot of formulas
>>>>> having to be recalculated when there is a change to the worksheet.  If 
>>>>> this
>>>>> is identified as the cause you may be able to get a gain by redesigning hr
>>>>> worksheets, or by keeping calculation turned off and pressing F9 when you
>>>>> want it to calculate.
>>>>>
>>>>> Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 23 May 2013 21:26, Prabhu Pinky  wrote:
>>>>>
>>>>>> thanks vijay, lemme try this too.
>>>>>>
>>>>>> but my doubt is if already "Use all the processors on this computer"
>>>>>> option is selected. then..?
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>> Prabhu R
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 23 May 2013 16:48, P.VIJAYKUMAR  wrote:
>>>>>>
>>>>>>> Respected Prabhu,
>>>>>>>
>>>>>>> Please  go to excel options button and from there go to the advanced
>>>>>>> tab and under that go to the formulas section.The third point will 
>>>>>>> contain
>>>>>>> how many processors are used for excel calculations.check the radio 
>>>>>>> button
>>>>>>> to use all the processors for calculations.This may boost up ur speed a
>>>>>>> little bit.There may be various other reasons for slowness of the 
>>>>>>> processes
>>>>>>> like compatibility issues,macros errors or virus etc.I frequently face 
>>>>>>> this
>>>>>>> problem when the workbook contains plenty of calculations and number of
>>>>>>> sheets and every small step even a copy and format takes many minutes to
>>>>>>> accomplish.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Vijaykumar
>>>>>>>
>>>>>>>
>>>>>>> On Thu, May 23, 2013 at 4:15 PM, Prabhu Pinky <
>>>>>>> prabhupin...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi Abhish

Re: $$Excel-Macros$$ Problem in file..?

[Divaker Pandey]

are using formula in sheet?, i hope there are refrences of some other files.


On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR  wrote:

> Respected Prabhu,
>
> You are saying that the sheet is companies sheet.Is is password protected
> or are any user rights restricted to used and to modify or make any changes
> to the file.Check also for version based compatibility issues because
> earlier version had lower data input and processing capabilities compared
> to the latest versions.Increasing you systems processor speed may also
> solve the problem.If you do not have much data in the file crate a fresh
> file with the same data because many time by some error the file gets
>  corrupted and the new file works perfectly alright without any problems.To
> know how much processing memory and time is  consumed by excel during the
> stuck time start the Task manager and go to processes tab and search for
> excel in the process. I think the processing time and memory used will be
> more during that period.the problem can only be dealt with specifically if
> only we know what exactly is causing the problem.
>
> Regards,
> VIJAYKUMAR
>
>
> On Thu, May 23, 2013 at 5:23 PM, Prabhu Pinky wrote:
>
>> No david..that sheet contains no macros, even very less formula. Only the
>> thing is some cells have formatted...
>>
>> Prabhu R
>> On May 23, 2013 5:20 PM, "David Grugeon"  wrote:
>>
>>> Also do you have macros which are run when changes are made to the
>>> sheets.  It may be possible to reorganise them so they run faster or are
>>> not triggered so readily.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 23 May 2013 21:47, David Grugeon  wrote:
>>>
 Try setting the calculation to Manual.  Then see if Cut and Paste still
 takes a lot of time.  It could be that there are a lot of formulas having
 to be recalculated when there is a change to the worksheet.  If this is
 identified as the cause you may be able to get a gain by redesigning hr
 worksheets, or by keeping calculation turned off and pressing F9 when you
 want it to calculate.

 Regards
 David Grugeon



 On 23 May 2013 21:26, Prabhu Pinky  wrote:

> thanks vijay, lemme try this too.
>
> but my doubt is if already "Use all the processors on this computer"
> option is selected. then..?
>
>
> Regards,
> Prabhu R
>
>
>
> On 23 May 2013 16:48, P.VIJAYKUMAR  wrote:
>
>> Respected Prabhu,
>>
>> Please  go to excel options button and from there go to the advanced
>> tab and under that go to the formulas section.The third point will 
>> contain
>> how many processors are used for excel calculations.check the radio 
>> button
>> to use all the processors for calculations.This may boost up ur speed a
>> little bit.There may be various other reasons for slowness of the 
>> processes
>> like compatibility issues,macros errors or virus etc.I frequently face 
>> this
>> problem when the workbook contains plenty of calculations and number of
>> sheets and every small step even a copy and format takes many minutes to
>> accomplish.
>>
>> Regards,
>> Vijaykumar
>>
>>
>> On Thu, May 23, 2013 at 4:15 PM, Prabhu Pinky > > wrote:
>>
>>> Hi Abhishek : thanks for the idea. i will try this one.
>>>
>>>
>>> David : i am unable attach the file, because it is violation in our
>>> office.
>>>
>>>
>>>
>>>
>>>
>>> On 23 May 2013 13:39, David Grugeon  wrote:
>>>
 Can't guess without seeing the file.  Can you attach it?

 Regards
 David Grugeon



 On 23 May 2013 16:49, Prabhu Pinky  wrote:

> Hi experts,
> I have one excel file. Size is below 1mb. Even though it is very
> slow working in that file. If I do copy paste any single cell, it 
> takes too
> much time.
>
> What could be the reasons...?
>
> Prabhu R
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
> forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any
> security measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confide

$$Excel-Macros$$ UDF to pull data from Remote Server

[Divaker Pandey]

Hi Expert,


I made a UDF function that pull data form server on the basis given
parameter.


When user put the multiple formula on sheet and when he press for
calculate, it take s more time to download data.

Is there any way to make it fast.

like i send all formula parameter in one shot (using xml and download again
in form of xml). but it will replace the formula in sheet.

i want also keep formula, and show their values in same cell.

if there is any another way, please suggest me.



Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Before_Close event to reset Calc to xlCalculationAutomatic recalcuate workbook again, can it stopped

[Divaker Pandey]

I'm running into one problem with this.

My workbook is pretty massive, so I've turned Application.Calculation to
Manual when opening, and only calculate specified areas when necessary
while file is open. (I also have CalculateBeforeSave set to False.) This
works great, except users get annoyed when Calc is still manual once
they've finished using my workbook.

Of course I used a Before_Close event to reset Calc to
xlCalculationAutomatic -- but now it takes forever to close, as it tries to
recalculate the entire workbook before shutting it down. Users just see an
unexplained hourglass that seems to sit there doing nothing. They can
escape by clicking the Close "X" button again, but unless I throw in a
clumsy message box explaining this, most won't know that.

Isn't there a more elegant solution? It seems like a catch-22 -- I want
calculation back on before closing, but I don't want it to actually *
calculate* before closing.

Can I force it to stop calculating within the macro? Is there some other
simple solution I'm not seeing?

It's roundabout, but I also considered opening a new workbook, copying a
Workbook_Close macro into it to turn on calculation, closing my workbook
first, then closing the new Book1 without saving, just to fire the
Workbook_Close event in a workbook that would close quickly. Simple in
concept, but a quick survey of the documentation hasn't shown me a simple
way to copy a macro or module to a new workbook -- if this is the only
solution to my dilemma, could someone point me in the right direction as
far as that goes?

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Treeview in 2010 64Bit

[Divaker Pandey]

Hi Expert

I have made an application that have tree view. it works on 2010 32Bit
excel.

but get problem in 2010 64Bit.

is there any solution to rectify this issue?

Regards.
Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ hyperlink issue

[Divaker Pandey]

solved .

On Thu, Feb 28, 2013 at 3:41 PM, amar takale  wrote:

> Dear All,
>
> I have facing some hyperlink issue in sheet,I attached sheet in detailed
> information,Pls tell me It is possible?
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Copy of Hyperlink Issue.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

[Divaker Pandey]

Oh Great, Deepak, it is the really very worth-full  post by you. my hats
off for explain this concept among excel user.

I hope it will increase again more interest of user to see and review again
each post of user group.

Again Tussi great ho tohfa kabool karo


On Mon, Feb 18, 2013 at 4:05 PM, Deepak Rawat wrote:

> Dear Rajan,
>
> Thanx for ur kind reply, it is really different.
>
>
> Regards,
> Deepak
>
>
> On Mon, Feb 18, 2013 at 1:15 PM, Rajan_Verma wrote:
>
>> *Hi Deepak*
>>
>> *See the attached Example,*
>>
>> * *
>>
>> *There are 4 set of data , I give name them  like data 1 , data2 ,data3
>> and data4 , then I insert a camera tool and reference them by a name range
>> “rngRange” as you can understand in the attachment*
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat
>> *Sent:* 18 February 2013 12:43
>> *To:* excel-macros
>> *Subject:* Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)
>>
>> ** **
>>
>> Hi Rajan,
>>
>> ** **
>>
>> great trick
>>
>> ** **
>>
>> could u explain how did u put the image.
>>
>> ** **
>>
>> Regards,
>>
>> Deepak 
>>
>> ** **
>>
>> On Fri, Feb 8, 2013 at 8:42 PM, rajan verma 
>> wrote:
>>
>> see if it helps
>>
>> ** **
>>
>> On Fri, Feb 8, 2013 at 5:19 AM, amar takale  wrote:
>> 
>>
>> Dear All,
>> Pls suggest any Solution for this work. I think it is hard & confusing
>> work but it is possible?
>> Guide me,Appreciate the help
>> Regards
>> Amar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>  
>>
>>
>>
>> 
>>
>> ** **
>>
>> --
>> Regards
>> Rajan verma
>> +91 9158998701 
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>  
>>
>> ** **
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or 

$$Excel-Macros$$ user could select either ">" or "<" and the formula would change

[Divaker Pandey]

Hi expert,


is it possible without macro.

I'm trying to make a dynamic formula so the user could select either ">" or
"<" and the formula would change.

See Attachment.

Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Book6.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

[Divaker Pandey]

PFA


On Tue, Jan 8, 2013 at 1:40 PM, Amol J  wrote:

> Hi Experts,
>
> I need help
>
> I have multiple shapes in sheet so i want color only one shapes in that
> perticular sheet. So I created a function which Change the color of
> provided set of shapes.
>
> I want know how to pass array of shapes to function.
>
> Please help me to solve this problem
>
> Thanks
> Amol
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




shapeColor.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ char code for SM (Service Mark)

[Divaker Pandey]

Thanks for rply

i need use SM in vba form caption, is there any way to add.


Divaker
On Tue, Dec 18, 2012 at 6:24 PM, David Grugeon  wrote:

> Sorry - that is the hex unicode for the character.  I don't think CHAR()
> does unicode.
>
> Regards
> David Grugeon
>
>
>
> On 18 December 2012 22:48, David Grugeon  wrote:
>
>> Seems to be 2120
>>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ char code for SM (Service Mark)

[Divaker Pandey]

hi expert,

can any one tell the char code for SM (Service Mark)


Divaker

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

[Divaker Pandey]

use this one

=NETWORKDAYS(DATEVALUE("12/24/2012"), DATEVALUE("12/28/2012"),A:A )

Let Range A:A contains list of holidays

On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:

>
>
> Hi experts,
>
>
>
> I want to calculate no of workdays and excludes holiday
>
>
>
> For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
>
>
>
> I tried using =Networkdays but I was able to no of working days
>
> Please help me to Exclude holiday.
>
>
>
> Thanks
>
> Manjunath
>
> --
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services
> Authority in respect of insurance mediation activities only.
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Slow down time in Processing Information *

[Divaker Pandey]

use both code
and keep your current code between them

On Thu, Dec 13, 2012 at 9:44 PM, Hilary Lomotey  wrote:

> thanks chief , but which of the codes shd i use, you provided two
>
> On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote:
>
>>  [image: Boxbe] <https://www.boxbe.com/overview> This message is
>> eligible for Automatic Cleanup! (divake...@gmail.com) Add cleanup 
>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DiyiAZ%252FY2ajD5b7e%252ByRjz8bHQW1h4l0BywXEN%252Fu82zD6NbBnBlmNHZN4%252BEZ%252FY20u0S5OYUd0%252BHB8ama8QGt0p1Co710LrxNgV58s1wPYeSdYziQ%252F%252FO4tnmeYrQ09EL7rpNR9St4vxH3o%253D%26key%3DEEBmSTWw%252BeDUeH4JpKgppp9w914WXnTsIs6ipyG0GGA%253D&tc=13113224668_1231496112>|
>>  More
>> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13113224668_1231496112>
>>
>>
>>
>> hi
>>
>> you can write some code on command button click
>>
>> with application
>>  .screenupdating=false
>>  .calculation= xlcaluationmanual
>> end with
>>
>> -Prsent code--
>>
>> with application
>> .screenupdating=true
>> .calculation= xlcaluationautomatic
>> end with
>>
>>
>>
>>
>>
>> On Thu, Dec 13, 2012 at 9:16 PM, Hilary Lomotey wrote:
>>
>>> Hello
>>>
>>> When i click on a command button on my userform, it takes close to 50
>>> secs before the information is processed to the worksheet. what could be
>>> accounting for this. is there a way to minimize the time?. thanks
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the resp

Re: $$Excel-Macros$$ Slow down time in Processing Information

[Divaker Pandey]

hi

you can write some code on command button click

with application
 .screenupdating=false
 .calculation= xlcaluationmanual
end with

-Prsent code--

with application
.screenupdating=true
.calculation= xlcaluationautomatic
end with





On Thu, Dec 13, 2012 at 9:16 PM, Hilary Lomotey  wrote:

> Hello
>
> When i click on a command button on my userform, it takes close to 50 secs
> before the information is processed to the worksheet. what could be
> accounting for this. is there a way to minimize the time?. thanks
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ excel Application with a userdefined ribbon built in using xml Error

[Divaker Pandey]

Hello Exprets,

I am struggling with the following strange problem in MS Excel 2007 (rarely
occurs).

I have an excel Application with a userdefined ribbon built in using xml.

Suddenly, during loading application i get an error message.

=> The message box that appears has no words, number or any other
information on it. It is a totally blank VBA message box with the
'vbCritical' icon on it (red circle with the white X in it) with 'OK' and
'Help' buttons.

I click on the 'OK' button and the loading continues, everything is loading
correctly.



it was working prior fine , but when i added a call on  the
onLoad="RibbonOnLoad" in the customUI.XML, then this problem arised.

while the same application is file in excel 2010 version.



Please Suggest what should i do. i need to call RibbononLoad , it could not
be ingored.


Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ reset dropdown text using macro in Menu Bar

[Divaker Pandey]

Okey finally i have able to solved it.

i have another uncertain issue now in Excel 2007, some time a blank error
dialog box display.  with title 'Mirosoft Visual Basic' during robbon load.

Exprets, what problem may be?


Divaker



On Mon, Nov 12, 2012 at 3:54 PM, Divaker Pandey  wrote:

> Hi All,
> I have made a custom menu in my application name 'evaDimensions' using
> xml, it have several other options ribbon tab, (See snapshot)
> I have used a dropdown PRVit Score:
>  I need to reset dropdown text using macro, plz guide me to how i can
> access this control using macro.
>  Thanks in adavance.
> Divaker
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ reset dropdown text using macro in Menu Bar

[Divaker Pandey]

Hi All,
I have made a custom menu in my application name 'evaDimensions' using xml,
it have several other options ribbon tab, (See snapshot)
I have used a dropdown PRVit Score:
I need to reset dropdown text using macro, plz guide me to how i can access
this control using macro.
 Thanks in adavance.
Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

[Divaker Pandey]

Congrats Rajan.

On Mon, Nov 12, 2012 at 2:20 PM, Rajan_Verma wrote:

> Thanks All,
>
>
> On Monday, 12 November 2012 10:24:55 UTC+5:30, ca_k...@yahoo.co.in wrote:
>
>> Congratulations Rajan
>>
>>
>> On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh  wrote:
>>
>>> Congrats dude!!
>>>
>>>
>>>
>>> Karan Singh
>>>
>>>
>>>
>>>
>>> On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan wrote:
>>>
 congratulation Rajan sir.



 On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori  wrote:

> Congrats Rajan
>
> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>
>>
>> Dear members,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month
>> of Oct'12. He has posted 66 posts in last month and helped forum members
>> through his excel expertise.
>> I truly appreciate his knowledge, consistency and commitment to the
>> group.
>> *
>> Rajan, please find enclosed the award certificate in honor of your
>> contribution. Congratulations and thanks for your contribution.
>> *
>>
>> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other
>> folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> P.S. If you have any feedback, please share your thoughts by filling
>> the survey 
>> form.
>>
>>
>>
>>  --
>> 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.
>>
>> Visit this group at http://groups.google.com/**
>> group/excel-macros?hl=en
>> .
>>
>>
>>
>
>  --
> Join official facebook page of this forum @ https://www.facebook.com/*
> *discussexcel 
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to excel-macros...@**
> googlegroups.com.
>
> Visit this group at http://groups.google.com/**
> group/excel-macros?hl=en
> .
>
>
>

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

 FORUM RULES (1120+ members already BANNED for violation)

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

$$Excel-Macros$$ sheet name as variable

[Divaker Pandey]

Is there any way to make reference like it
DataTabTemp!$1:$1

i want to keep sheet name variable

  MATCH("EVAMOMARGIMP10",DataTabTemp!$1:$1,0)

actully i have data in two sheet "DataTabTemp" and "DataTabUS"

 and now i need to change formula on whole application
so i don't used anoter formula, but just change sheet reference on flag
change
any idea?


if flag 0 then
MATCH("EVAMOMARGIMP10",DataTabTemp!$1:$1,0)
else
MATCH("EVAMOMARGIMP10",DataTabUS!$1:$1,0)
end if

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Preserving number leading 0 querytable excel

[Divaker Pandey]

thanks kuldeep, but not solved my problem

Divaker

On Tue, Oct 30, 2012 at 10:08 PM, Kuldeep Singh wrote:

>
> Hi Sir,
>
> Please see this link. I hope it will help you.
>
>
> http://blog.sqlauthority.com/2012/09/30/sql-server-preserve-leading-zero-while-coping-to-excel-from-ssms/
>
> Regards,
> Kuldeep Singh
>
>
> On Tue, Oct 30, 2012 at 10:04 PM, Kuldeep Singh 
> wrote:
>
>>
>> Hi Sir,
>>
>> Try this one.
>>
>>
>> Regards,
>> Kuldeep Singh
>>
>> On Tue, Oct 30, 2012 at 9:48 PM, Divaker Pandey wrote:
>>
>>> Hi Expert,
>>>
>>> Kindly provide any solution for following problem Preserving number
>>> leading 0 querytable excel
>>> .
>>> divaker
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Preserving number leading 0 querytable excel

[Divaker Pandey]

Hi Expert,

Kindly provide any solution for following problem Preserving number leading
0 querytable excel
.
divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Macro for Find

[Divaker Pandey]

Use it, hope it will fulfill your requirement

Sub CopyDesireCriteria()
  Dim strCriteria As String, n As Integer, CellV
  On Error Resume Next
   Application.CutCopyMode = True
   For Each CellV In ThisWorkbook.Sheets("Criteria").Range("A2:A4")
   If CellV.Value = "" Then Exit For
   If Len(strCriteria) > 0 Then strCriteria = strCriteria & " ,"
   strCriteria = strCriteria & CellV

  Next

 Application.ScreenUpdating = False
 Application.Calculation = xlCalculationManual
   ThisWorkbook.Sheets("RAW Data").Range("$A$1:$D$25").AutoFilter Field:=1,
Criteria1:=Split(strCriteria, ","), Operator:=xlFilterValues

Selection.Copy
Sheets("final Output").Select
Range("A2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
ThisWorkbook.Sheets("RAW Data").Range("$A$1:$D$25").AutoFilter
End Sub



On Mon, Oct 29, 2012 at 8:11 PM, Don Guillett  wrote:

> A macro is possible but it probably should be based on an advanced filter.
> You need to give much more info on what you want.
>
>
> On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote:
>>
>> Dear all
>>
>>
>> I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH  Example
>> .-: user want to find details of " H".then macro should ask the name and
>> only that details will be paste in sheet 2  Other search may be user
>> want details of all the people whose age is in between 23 to 27
>>
>>
>>
>> --
>> 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.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Trouble in 2007

[Divaker Pandey]

What about macro setting on your Excel 2007 application

Divaker

On Sun, Oct 21, 2012 at 5:30 PM, SAJID MEMON  wrote:

>  Dear experts,
>
> I have done a small project in excel 2003 with some command buttons. when
> i open my project in excel 2007 then command buttons are not press or
> working.
> Why this problem come in 2007? please give me settings or any suggesstion.
> I have checked micro to enabled and desabled but same promblems is constant.
>
> Awaiting your positive responce
> Regards
> Sajid Memon
>
> --
> 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$$ Reg Mail using excel Macro

[Divaker Pandey]

you need to used vbscript and its object

Divaker Pandey

On Fri, Sep 21, 2012 at 2:37 PM, Vignesh S R wrote:

> Hi,
> Can any body guide me,how to attach the variables that are used in the
> Form  and need to consolidate and send to the another user in Mail (without
> using outlook).
>
> Thanks,
> Vignesh.S.R
>
> --
> 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$$ Office 2010, activating sheet fails in Workbook_Open after going out of protected view

[Divaker Pandey]

Hi Experts,

there is a problem with my code, when i open my application first time and
got error during sheet activate in workbook_open method.

can you help me to solve out.

Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ last date in the series does not appear on the chart

[Divaker Pandey]

Hi Experts,

I have a time series line chart with dates on the x-axis. The dates run in
ascending order , left to right. The last date in the series does not
appear on the chart.

After numerous attempts with different scenarios using the various
functions under the "Scale" tab in the "Formatting Axis" dialoge box, I
have been unable to
display the last value in this series on the chart.

Is there a method for doing this? Thank you in advance for taking time to
respond.

Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

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

[Divaker Pandey]

Hi Expert,

can any one help me to show last available date in chart -xaxis range.


Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ combo box in Ribbon bar

[Divaker Pandey]

Hi Experts

I have added one dropdown in custom menu using xml. can i add their item
value using macros, on workbook_activate method?


Divaker

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ File opens read only on same excel instance

[Divaker Pandey]

Hi Expert,

I am facing one issue with excel.

I open a excel workbook xyz.xlsm, it opens without any problem.
But when I closed only xyz.xlsm, and try to reopen it, i am getting message
that file is in read only mode.

I tried all option. but still no clue
What problem may be. can you experts give any clue.

Divaker

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ long opening file on the external server

[Divaker Pandey]

if you can do then.

1. Clear all formatting you have done, and reformat all same(as was
initial) cell in just one step.
2. try to avoid array formula
3. Before open file set calculation mode manual

Divaker




On Fri, Jul 13, 2012 at 2:26 PM, pawel lupinski  wrote:

> I'd like to do this but my knowladge is still not there, sad but true.
> Maybe some other solution, please.
>
> Regards,
>
> Pawel
>
>*From:* Divaker Pandey 
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, July 13, 2012 9:40 AM
> *Subject:* Re: $$Excel-Macros$$ long opening file on the external server
>
> try to calculate required calculation with the help of macros.
>
> Divaker
>
> On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:
>
> Hi All,
>
> I need your help on this issue. I have quite big file (21MB) that is doing
> a lot of calculation between tabs, in order to run this file more efficient
> I've switch off calculation, and I'm switch it on when needed. When I've
> done this file on my computer its opening slowly but not so bad 10 sec. The
> problem is: when I've put this file on company server for other users its a
> nightmare. Yesterday I've been waiting to open about 6-10 min!!! I've
> checked this on different workstation and the same opening time
> unbelievable.
> Do you have any thoughts? How Can I change this? What can improve it?
>
> Need your help
>
> Pawel
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> mailto:excel-macros%2bunsubscr...@googlegroups.com
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>--
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

Re: $$Excel-Macros$$ long opening file on the external server

[Divaker Pandey]

try to calculate required calculation with the help of macros.

Divaker

On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:

> Hi All,
>
> I need your help on this issue. I have quite big file (21MB) that is doing
> a lot of calculation between tabs, in order to run this file more efficient
> I've switch off calculation, and I'm switch it on when needed. When I've
> done this file on my computer its opening slowly but not so bad 10 sec. The
> problem is: when I've put this file on company server for other users its a
> nightmare. Yesterday I've been waiting to open about 6-10 min!!! I've
> checked this on different workstation and the same opening time
> unbelievable.
> Do you have any thoughts? How Can I change this? What can improve it?
>
> Need your help
>
> Pawel
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ currency and currency Symbol

[Divaker Pandey]

Hi Expert,

Can any one provide me currency name with symbol.

Divaker

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ keep selected custom menu tab

[Divaker Pandey]

thanks a lot Sam

Divaker

On Thu, Jul 5, 2012 at 7:57 PM, Sam Mathai Chacko wrote:

> Try this, might help.
>
> http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/
>
> If it doesn't, can you post your XML code?
>
> Regards,
> Sam Mathai Chacko
>
>
> On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey wrote:
>
>> Hi Group,
>>
>> I made a custom menu and ribbon icon using xml in my workbook. I want to
>> keep selected the created custom menu everytime whenever workbook activated.
>>
>>
>> Divaker
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ sum base on 8 digits code

[Divaker Pandey]

I think Noorain's solution is the excellent among all replies.

gr8 Noorain.

Divaker

On Thu, Jul 5, 2012 at 6:22 PM, Rajan_Verma wrote:

> ** **
>
> ** **
>
> =SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *pawel lupinski
> *Sent:* 05 July 2012 1:56
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ sum base on 8 digits code
>
> ** **
>
> Hi All,
> I need your help on this particular task. Does anyone know how to add up
> this value?
> I have bigger table that I need to add all codes started with first the
> same 8 digits rest of the digits are not important as this is only
> combination of the main first 8.
> I hope that I didn't over complicated this example. Main thing is that the
> function need to find code started with (codes) in column "B" and add them
> up.
>
> I'll be grateful if you can help me.
> Pawel
>
> 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ keep selected custom menu tab

[Divaker Pandey]

Hi Group,

I made a custom menu and ribbon icon using xml in my workbook. I want to
keep selected the created custom menu everytime whenever workbook activated.


Divaker

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ COLOR CHANGE MACRO

[Divaker Pandey]

use this one

Sub ChangeRowColor()

Dim sheet As Worksheet
Dim row_min As Integer
Dim row_max As Integer
Dim rowC As Long

' Select the used range.
Set sheet = ActiveSheet
'sheet.UsedRange.Select

' Display the range's rows and columns.
row_min = sheet.UsedRange.Row
row_max = row_min + sheet.UsedRange.Rows.Count - 1


For rowC = row_min To row_max
 With sheet.Range("c" & rowC).EntireRow.Font
.Color = sheet.Range("C" & rowC).Font.Color
 .TintAndShade = 0
End With
 Next


End Sub


or

if you want to change color only used cells

Sub ChangeRowColorOnlyUsedCells()

Dim sheet As Worksheet
Dim row_min As Integer
Dim row_max As Integer
Dim col_min As Integer
Dim col_max As Integer
Dim rowC As Long
Dim colC As Long

' Select the used range.
Set sheet = ActiveSheet
'sheet.UsedRange.Select

' Display the range's rows and columns.
row_min = sheet.UsedRange.Row
row_max = row_min + sheet.UsedRange.Rows.Count - 1
col_min = sheet.UsedRange.Column
col_max = col_min + sheet.UsedRange.Columns.Count - 1

For rowC = row_min To row_max
For colC = col_min To col_max
With sheet.Cells(rowC, colC).Font
.Color = sheet.Range("C" & rowC).Font.Color
 .TintAndShade = 0
End With
Next
  Next

End Sub


or

if you want change on particular cell color change event then used this one
(Few modification in noorain code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = "3" And Target.Value <> "" Then
Target.EntireRow.Font.Color = Target.Cells.Font.Color
End If
End Sub



On Thu, Jul 5, 2012 at 4:13 PM, NOORAIN ANSARI wrote:

> Dear Amit,
>
> Please try it..
>
> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = "3" And Target.Value <> "" Then
> Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
> End If
> End Sub
> *
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, Jul 5, 2012 at 3:51 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I need a macro which changes the FONT COLOR of ENTIRE ROW as per font
>> color of a particular cell in that row. Sample file attached.
>>
>> Pls help me here.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and mem

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

[Divaker Pandey]

*Congrats..Ashish & Dilip, for your gr8 Achievement.*

But it will be awesome.if you explore with group member, your journey to
plan, execution and finally getting award.

Hope another group member can get this award.

Divaker

On Wed, Jul 4, 2012 at 2:02 PM, NRao Mynampati wrote:

> Congaratulation Ashish and Dilip
>
>
> On Tue, Jul 3, 2012 at 12:17 PM, Excel Vba wrote:
>
>> Congrats both of them. God bless..
>>
>>
>>
>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain  wrote:
>>
>>> Dear members,
>>>
>>> I am extremely happy to inform you that two members of the group are
>>> awarded Microsoft Most Valuable Professional Award.
>>> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
>>> thanks for their big support to this forum.
>>>
>>> Keep posting !
>>>
>>> Best regards,
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ urgent required vba code:: 2 list boxes in userform scroll same time.

[Divaker Pandey]

suppose you scrorll listbox1 then

write on listbox1_change event

listbox2.listindex = listbox1.listindex


Divaker

On Wed, Jul 4, 2012 at 7:03 PM, Rajan_Verma wrote:

> Can u share useform?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Dhartikumar Sahu
> *Sent:* 04 July 2012 10:22
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ urgent required vba code:: 2 list boxes in
> userform scroll same time.
>
> ** **
> Hi Group
> I have 2 list boxes side by side in userform. I need to use a single
> scroll bar to scroll all 2 listboxes at the same time, so that all the
> information in the boxes stay aligned. 
>
> ** **
>
> ** **
>
> need urgent reply
>
> ** **
>
> -- 
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450***
> *
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

[Divaker Pandey]

:)
As your question as my answer.

Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10
kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to
banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga
wo pathar ka weight hoga. aur same lakdi ke liye karo. last tumhe pathar,
lakdi aur pani ka weight pata chal jayega.

hope you will got your answer.

just take it as fun.

Divaker


On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD wrote:

>
> Dear Expert,
> Is there any way to find out how much memory is being used by a excel
> sheet in particular excel file .
> Like I have a file named XYZ (5mb memory used ) and in this file have
> three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets ,
> sheet1-???
> sheet2-???
> sheet3-???
> Total-5MB
>  **
> Regards
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Macro to copy a macro from one workbook to another

[Divaker Pandey]

I think it can not possible due to security region.

but what is your purpose?

Divaker

On Mon, Jun 25, 2012 at 10:31 PM, Richard  wrote:

> Thank you very much
> On Sunday, June 24, 2012 4:46:35 PM UTC-7, Richard wrote:
>>
>> I would like to create a macro to copy a macro from one workbooks module
>> area to another workbooks "ThisWorkbook" area.
>>
>> The first workbook is the master and any other workbook would be subsets
>> of the master.  The idea is to have a macro that will further lock cells
>> from input (sub workbook_open) on the child workbooks.
>>
>> Any help would be appreciated
>>
>> Rich
>>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need a VBA code to display name in "Last Name, First Name" format

[Divaker Pandey]

Hi Sharath,

PFA,

Hope it will help you.

Divaker


Private Sub Worksheet_Change(ByVal Target As Range)
 On Error GoTo Exit_Sub
Dim nameIS() As String, newName As String
If Target.Column = 6 And Target.Row > 6 Then
 If IsEmpty(Target.Value) Then Exit Sub
If InStr(Target.Value, ",") = 0 Then
 nameIS = Split(Trim(Target.Value), " ")
 newName = nameIS(UBound(nameIS))
If UBound(nameIS) > 0 Then
 If Len(newName) > 0 Then newName = newName & ","
  For i = 0 To UBound(nameIS) - 1
newName = newName & " " & nameIS(i)
 Next
End If
 Target.Value = newName
End If

 End If
Exit_Sub:
End Sub



On Fri, Jun 29, 2012 at 5:11 PM, sharath chandra <
sharath.c.sambr...@gmail.com> wrote:

> Hello Experts,
>
> I have attached a spreadsheet. In Column F we have a name. By default it
> is validated in the format "First Name (and Middle Name if exists) Last
> Name".
>
> So when someone types in a name in any of the cell in Column F, it should
> convert the format to "Last Name, (comma) First (and Middle) Name".
>
> I hope I am able to explain it clearly.
>
> Thank you in advance,
>
> Sharath
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of NeedVBA-Code.xlsm
Description: Binary data

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

[Divaker Pandey]

=VLOOKUP(I3,$E$2:$F$10,2,TRUE)



On Mon, Jul 2, 2012 at 12:31 PM, Shaik Waheed  wrote:

> =vlookup(I7,$E$7:$F$14,2,1)
>
>
> On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Manoj,
>>
>> Please more explain..what is your exact requirement.
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Mon, Jul 2, 2012 at 11:22 AM, Manoj Kukreja <
>> manoj.kukr...@planetsoft.com> wrote:
>>
>>>  Hi,
>>>
>>> ** **
>>>
>>> I need Vlookup for Last Available Date if the 
>>>
>>> 
>>> This message contains information that may be privileged or confidential
>>> and is the property of PlanetSoft Holdings Inc. It is intended only for the
>>> person to whom it is addressed. If you are not the intended recipient, you
>>> are not authorized to read, print, retain, copy, disseminate, distribute,
>>> or use this message or any part thereof. If you receive this message in
>>> error, please notify the sender immediately and delete all copies of this
>>> message.
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubs

Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)

[Divaker Pandey]

Hi Noorain,

I think job related to excel vba mail should not be banned.

1. it will help to user to know what is in current demand in excel related
job.
2. it will encourage to learn and solve more excels quiz.
3. in last each enhanced skill is used to get better job options.

Regards.

Divaker

On Thu, Jun 28, 2012 at 7:29 PM, NOORAIN ANSARI wrote:

> Dear Jitu,
>
> As per Forum rule, Job related mail has been banned.
> Brother take care in future.
>
>
>
> On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh wrote:
>
>>
>>
>> -- Forwarded message --
>> From: RJT Compuquest 
>> Date: Thu, Jun 28, 2012 at 1:26 PM
>> Subject: MIS executive opening with Aricent Technologies (Contact to Hire)
>> To: jeete2...@gmail.com
>>
>>
>>  The sender of this email is registered with Naukri.com as RJT Compuquest
>> *Experience required for the Job:* 2 - 3 years
>> *Job Location:* Gurgaon
>>
>> Apply 
>> Now(Send
>> your Naukri profile to express interest to the recruiter)
>>
>>
>> *Dear Candidate,*
>>
>> Hello,
>>
>> Greetings of the Day!!!
>>
>> We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon
>> (Working on a payroll of RJT)
>>
>>
>> About Aricent(CLient):
>>
>> Our Client is a global innovation, technology and services company
>> focused exclusively on communications. Its unique engagement model blends
>> strategy, design, technology and engineering services, delivering
>> exceptional value across each phase of the product and service lifecycle.
>> Together with its global innovation arm frog design, offers 40 years"
>> experience in delivering innovation and technology breakthroughs that have
>> transformed entire industries. With more than 800 clients, 9500 employees
>> in 19 countries,more than 100 industry awards. It is uniquely positioned to
>> help organizations conceive and commercialize innovative solutions.
>>
>> Please fill this below details:
>>
>> Currrent CTC:
>> Expected CTC:
>> Notice Period:
>> DOB:
>>
>>
>> Roles & Responsbilities:
>>
>> Expertise in MS-Excel, MS-Power Point, MS-Word & MS- Access Good
>> analytical & management skills Ability to relate various data sources for
>> comparing/contrasting Ability to interpret requirements & be self driven
>> Preparing & presenting appropriate reports as & when required Maintain
>> data pertaining to all departments - O&M, Finance & Accounts, HR & Admin,
>> Sales & Service, Education Handling different projects assignment as & when
>> required
>>
>> Qualification: Any Graduate
>>
>> Location: Gurgaon
>>
>> Please forward your updated resume and also refer your friend or
>> colleague who are interested to change.
>>
>> Awaiting your prompt reply.
>>
>> Thanks & Regards
>> Sonia Gupta
>>
>> Is this job relevant to you? 
>> Yes
>> No
>>   Your
>> feedback would help us in sending you the most relevant job opportunities
>> Disclaimer:
>>  The sender of this email is registered with naukri.com as *RJT
>> Compuquest* (gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR,
>> GURGAON, Haryana - 122001) using Naukri.com services. The responsibility of
>> checking the authenticity of offers/correspondence lies with you.
>>
>> If you consider the content of this email inappropriate or spam, you may:
>>
>>1. Report abuse by forwarding this email to: complia...@naukri.com
>>2. You can also Block this 
>> Companyfrom searching your 
>> resume in the database.
>>
>>
>> Advisory: Please do not pay any money to anyone who promises to find you
>> a job. This could be in the form of a registration fee, or document
>> processing fee or visa charges or any other pretext. The money could be
>> asked for upfront or it could be asked after trust has been built after
>> some correspondence has been exchanged. Also please note that in case you
>> get a job offer or a letter of intent without having been through an
>> interview process it is probably a scam and you should contact
>> complia...@naukri.com for advise.
>>*To be on the top of Employer's Resume Search
>> Update Your Resume 
>> Now
>> *   *Your Resume has only 30 seconds to impress a Recruiter. Get your
>> resume written by 
>> Experts.
>> Call 1800-102-5557 now! (Toll-Free)*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't 

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Hi Experts

still waiting for solution

Divaker

On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey  wrote:

> but it will lock modification in list through vba.
>
> Divker
>
>
> On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI 
> wrote:
>
>> Hi Divaker,
>>
>> I have created a name range "List_Matters",
>>
>> We called it through below coding..
>>
>> Sheet1.lstLookup.ListFillRange = "List_Matters"
>>
>> and in Property Boxt i have marked columnHeads as true.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey 
>> wrote:
>> > Thanks Noorain, i want to list out all company details which match on
>> > entered value in textbox.
>> >
>> > By the way how you added header in listbox.
>> >
>> > Please tell me steps.
>> >
>> > Thanks.
>> >
>> > Divaker
>> >
>> >
>> > On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη <
>> mohan.pande...@gmail.com>
>> > wrote:
>> >>
>> >> Hi Divaker,
>> >>
>> >> You query is not cleary mentioned can u please share a file with the
>> >> full description so that we can help u as soon as possible
>> >>
>> >> Regards,
>> >> Lalit Mohan
>> >>
>> >>
>> >> On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey 
>> >> wrote:
>> >> > Hi Experts,
>> >> >
>> >> > Still waiting for your response.
>> >> >
>> >> > Divaker
>> >> >
>> >> >
>> >> > On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey > >
>> >> > wrote:
>> >> >>
>> >> >> Hi Noorain & Experts,
>> >> >>
>> >> >> Thanks for respond. please find attached file.
>> >> >> on tab sheet1 there is two activeX control
>> >> >>
>> >> >> 1. Textbox -txtLookup
>> >> >> 2. ListBox - lstLookup
>> >> >>
>> >> >> if user change value of textbox it search the input string in each
>> >> >> column.
>> >> >> and add in listbox all rows which string matched.
>> >> >>
>> >> >> I want to add headers.
>> >> >>
>> >> >> Please suggest asap.
>> >> >>
>> >> >>
>> >> >> Divaker
>> >> >>
>> >> >>
>> >> >> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI
>> >> >> 
>> >> >> wrote:
>> >> >>>
>> >> >>> Dear Divaker,
>> >> >>>
>> >> >>> Please share your Activelistbox with group.
>> >> >>>
>> >> >>> --
>> >> >>> Thanks & regards,
>> >> >>> Noorain Ansari
>> >> >>> www.noorainansari.com
>> >> >>> www.excelmacroworld.blogspot.com
>> >> >>>
>> >> >>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey <
>> divake...@gmail.com>
>> >> >>> wrote:
>> >> >>> > Hi Ayush,
>> >> >>> >
>> >> >>> > I want to add header column text in Activelistbox through vba.
>> >> >>> >
>> >> >>> > Can you help me how i can add.
>> >> >>> >
>> >> >>> >
>> >> >>> > Thanks.
>> >> >>> >
>> >> >>> > Divaker
>> >> >>> >
>> >> >>> > --
>> >> >>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> >> >>> > concise,
>> >> >>> > accurate thread titles. Poor thread titles, like Please Help,
>> >> >>> > Urgent,
>> >> >>> > Need
>> >> >>> > Help, Formula Problem, Code Problem, and Need Advice will not get
>> >> >>> > quick
>> >> >>> > attention or may not be answered. 2) Don't post a question in the
>>

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

but it will lock modification in list through vba.

Divker

On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI wrote:

> Hi Divaker,
>
> I have created a name range "List_Matters",
>
> We called it through below coding..
>
> Sheet1.lstLookup.ListFillRange = "List_Matters"
>
> and in Property Boxt i have marked columnHeads as true.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey 
> wrote:
> > Thanks Noorain, i want to list out all company details which match on
> > entered value in textbox.
> >
> > By the way how you added header in listbox.
> >
> > Please tell me steps.
> >
> > Thanks.
> >
> > Divaker
> >
> >
> > On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη <
> mohan.pande...@gmail.com>
> > wrote:
> >>
> >> Hi Divaker,
> >>
> >> You query is not cleary mentioned can u please share a file with the
> >> full description so that we can help u as soon as possible
> >>
> >> Regards,
> >> Lalit Mohan
> >>
> >>
> >> On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey 
> >> wrote:
> >> > Hi Experts,
> >> >
> >> > Still waiting for your response.
> >> >
> >> > Divaker
> >> >
> >> >
> >> > On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey 
> >> > wrote:
> >> >>
> >> >> Hi Noorain & Experts,
> >> >>
> >> >> Thanks for respond. please find attached file.
> >> >> on tab sheet1 there is two activeX control
> >> >>
> >> >> 1. Textbox -txtLookup
> >> >> 2. ListBox - lstLookup
> >> >>
> >> >> if user change value of textbox it search the input string in each
> >> >> column.
> >> >> and add in listbox all rows which string matched.
> >> >>
> >> >> I want to add headers.
> >> >>
> >> >> Please suggest asap.
> >> >>
> >> >>
> >> >> Divaker
> >> >>
> >> >>
> >> >> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI
> >> >> 
> >> >> wrote:
> >> >>>
> >> >>> Dear Divaker,
> >> >>>
> >> >>> Please share your Activelistbox with group.
> >> >>>
> >> >>> --
> >> >>> Thanks & regards,
> >> >>> Noorain Ansari
> >> >>> www.noorainansari.com
> >> >>> www.excelmacroworld.blogspot.com
> >> >>>
> >> >>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey <
> divake...@gmail.com>
> >> >>> wrote:
> >> >>> > Hi Ayush,
> >> >>> >
> >> >>> > I want to add header column text in Activelistbox through vba.
> >> >>> >
> >> >>> > Can you help me how i can add.
> >> >>> >
> >> >>> >
> >> >>> > Thanks.
> >> >>> >
> >> >>> > Divaker
> >> >>> >
> >> >>> > --
> >> >>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
> >> >>> > concise,
> >> >>> > accurate thread titles. Poor thread titles, like Please Help,
> >> >>> > Urgent,
> >> >>> > Need
> >> >>> > Help, Formula Problem, Code Problem, and Need Advice will not get
> >> >>> > quick
> >> >>> > attention or may not be answered. 2) Don't post a question in the
> >> >>> > thread of
> >> >>> > another member. 3) Don't post questions regarding breaking or
> >> >>> > bypassing
> >> >>> > any
> >> >>> > security measure. 4) Acknowledge the responses you receive, good
> or
> >> >>> > bad. 5)
> >> >>> > Cross-promotion of, or links to, forums competitive to this forum
> in
> >> >>> > signatures are prohibited. NOTE : Don't ever post personal or
> >> >>> > confidential
> >> >>> > data in a workbook. Forum owners and members are not responsible
> for
> >> >>> &

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Noorain,

It will be helpful if you give me VBA code to add header column.

I think listbox used header on the base of assigned range on
ListFillRange  properties.

But it is not make sense to solve my query, because i have 72000 rows, and
take selected rows form them. i could not want write it again on another
place to make dynamic name range. that can be used in ListFillRange
Properties. it will make application slow.


Have you any another clue??


Divaker

On Tue, Jun 26, 2012 at 8:09 PM, Divaker Pandey  wrote:

> Hi Lalit,
>
> I want to list out all company which string match in any column(available
> data)
>
> Divaker
>
>
>
>
> On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey wrote:
>
>> Thanks Noorain, i want to list out all company details which match on
>> entered value in textbox.
>>
>> By the way how you added header in listbox.
>>
>> Please tell me steps.
>>
>> Thanks.
>>
>> Divaker
>>
>>
>> On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη > > wrote:
>>
>>> Hi Divaker,
>>>
>>> You query is not cleary mentioned can u please share a file with the
>>> full description so that we can help u as soon as possible
>>>
>>> Regards,
>>> Lalit Mohan
>>>
>>>
>>> On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey 
>>> wrote:
>>> > Hi Experts,
>>> >
>>> > Still waiting for your response.
>>> >
>>> > Divaker
>>> >
>>> >
>>> > On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey 
>>> wrote:
>>> >>
>>> >> Hi Noorain & Experts,
>>> >>
>>> >> Thanks for respond. please find attached file.
>>> >> on tab sheet1 there is two activeX control
>>> >>
>>> >> 1. Textbox -txtLookup
>>> >> 2. ListBox - lstLookup
>>> >>
>>> >> if user change value of textbox it search the input string in each
>>> column.
>>> >> and add in listbox all rows which string matched.
>>> >>
>>> >> I want to add headers.
>>> >>
>>> >> Please suggest asap.
>>> >>
>>> >>
>>> >> Divaker
>>> >>
>>> >>
>>> >> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com>
>>> >> wrote:
>>> >>>
>>> >>> Dear Divaker,
>>> >>>
>>> >>> Please share your Activelistbox with group.
>>> >>>
>>> >>> --
>>> >>> Thanks & regards,
>>> >>> Noorain Ansari
>>> >>> www.noorainansari.com
>>> >>> www.excelmacroworld.blogspot.com
>>> >>>
>>> >>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey >> >
>>> >>> wrote:
>>> >>> > Hi Ayush,
>>> >>> >
>>> >>> > I want to add header column text in Activelistbox through vba.
>>> >>> >
>>> >>> > Can you help me how i can add.
>>> >>> >
>>> >>> >
>>> >>> > Thanks.
>>> >>> >
>>> >>> > Divaker
>>> >>> >
>>> >>> > --
>>> >>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>>> >>> > concise,
>>> >>> > accurate thread titles. Poor thread titles, like Please Help,
>>> Urgent,
>>> >>> > Need
>>> >>> > Help, Formula Problem, Code Problem, and Need Advice will not get
>>> quick
>>> >>> > attention or may not be answered. 2) Don't post a question in the
>>> >>> > thread of
>>> >>> > another member. 3) Don't post questions regarding breaking or
>>> bypassing
>>> >>> > any
>>> >>> > security measure. 4) Acknowledge the responses you receive, good or
>>> >>> > bad. 5)
>>> >>> > Cross-promotion of, or links to, forums competitive to this forum
>>> in
>>> >>> > signatures are prohibited. NOTE : Don't ever post personal or
>>> >>> > confidential
>>> >>> > data in a workbook. Forum owners and members are not responsible
>>> for
>>> >>> > any
>>> >>> > 

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Hi Lalit,

I want to list out all company which string match in any column(available
data)

Divaker



On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey  wrote:

> Thanks Noorain, i want to list out all company details which match on
> entered value in textbox.
>
> By the way how you added header in listbox.
>
> Please tell me steps.
>
> Thanks.
>
> Divaker
>
>
> On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη 
> wrote:
>
>> Hi Divaker,
>>
>> You query is not cleary mentioned can u please share a file with the
>> full description so that we can help u as soon as possible
>>
>> Regards,
>> Lalit Mohan
>>
>>
>> On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey 
>> wrote:
>> > Hi Experts,
>> >
>> > Still waiting for your response.
>> >
>> > Divaker
>> >
>> >
>> > On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey 
>> wrote:
>> >>
>> >> Hi Noorain & Experts,
>> >>
>> >> Thanks for respond. please find attached file.
>> >> on tab sheet1 there is two activeX control
>> >>
>> >> 1. Textbox -txtLookup
>> >> 2. ListBox - lstLookup
>> >>
>> >> if user change value of textbox it search the input string in each
>> column.
>> >> and add in listbox all rows which string matched.
>> >>
>> >> I want to add headers.
>> >>
>> >> Please suggest asap.
>> >>
>> >>
>> >> Divaker
>> >>
>> >>
>> >> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com>
>> >> wrote:
>> >>>
>> >>> Dear Divaker,
>> >>>
>> >>> Please share your Activelistbox with group.
>> >>>
>> >>> --
>> >>> Thanks & regards,
>> >>> Noorain Ansari
>> >>> www.noorainansari.com
>> >>> www.excelmacroworld.blogspot.com
>> >>>
>> >>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey 
>> >>> wrote:
>> >>> > Hi Ayush,
>> >>> >
>> >>> > I want to add header column text in Activelistbox through vba.
>> >>> >
>> >>> > Can you help me how i can add.
>> >>> >
>> >>> >
>> >>> > Thanks.
>> >>> >
>> >>> > Divaker
>> >>> >
>> >>> > --
>> >>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> >>> > concise,
>> >>> > accurate thread titles. Poor thread titles, like Please Help,
>> Urgent,
>> >>> > Need
>> >>> > Help, Formula Problem, Code Problem, and Need Advice will not get
>> quick
>> >>> > attention or may not be answered. 2) Don't post a question in the
>> >>> > thread of
>> >>> > another member. 3) Don't post questions regarding breaking or
>> bypassing
>> >>> > any
>> >>> > security measure. 4) Acknowledge the responses you receive, good or
>> >>> > bad. 5)
>> >>> > Cross-promotion of, or links to, forums competitive to this forum in
>> >>> > signatures are prohibited. NOTE : Don't ever post personal or
>> >>> > confidential
>> >>> > data in a workbook. Forum owners and members are not responsible for
>> >>> > any
>> >>> > loss.
>> >>> >
>> >>> >
>> --
>> >>> > To post to this group, send email to excel-macros@googlegroups.comTo
>> >>> > unsubscribe, send a blank email to
>> >>> > excel-macros+unsubscr...@googlegroups.com
>> >>>
>> >>> --
>> >>> --
>> >>> FORUM RULES (986+ members already BANNED for violation)
>> >>>
>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please
>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will
>> >>> not get quick attention or may not be answered.
>> >>>
>> >>> 2) Don't post a question in the thread of another member.
>> >>>
>> >>> 3) Don'

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Thanks Noorain, i want to list out all company details which match on
entered value in textbox.

By the way how you added header in listbox.

Please tell me steps.

Thanks.

Divaker

On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη wrote:

> Hi Divaker,
>
> You query is not cleary mentioned can u please share a file with the
> full description so that we can help u as soon as possible
>
> Regards,
> Lalit Mohan
>
>
> On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey 
> wrote:
> > Hi Experts,
> >
> > Still waiting for your response.
> >
> > Divaker
> >
> >
> > On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey 
> wrote:
> >>
> >> Hi Noorain & Experts,
> >>
> >> Thanks for respond. please find attached file.
> >> on tab sheet1 there is two activeX control
> >>
> >> 1. Textbox -txtLookup
> >> 2. ListBox - lstLookup
> >>
> >> if user change value of textbox it search the input string in each
> column.
> >> and add in listbox all rows which string matched.
> >>
> >> I want to add headers.
> >>
> >> Please suggest asap.
> >>
> >>
> >> Divaker
> >>
> >>
> >> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com>
> >> wrote:
> >>>
> >>> Dear Divaker,
> >>>
> >>> Please share your Activelistbox with group.
> >>>
> >>> --
> >>> Thanks & regards,
> >>> Noorain Ansari
> >>> www.noorainansari.com
> >>> www.excelmacroworld.blogspot.com
> >>>
> >>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey 
> >>> wrote:
> >>> > Hi Ayush,
> >>> >
> >>> > I want to add header column text in Activelistbox through vba.
> >>> >
> >>> > Can you help me how i can add.
> >>> >
> >>> >
> >>> > Thanks.
> >>> >
> >>> > Divaker
> >>> >
> >>> > --
> >>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
> >>> > concise,
> >>> > accurate thread titles. Poor thread titles, like Please Help, Urgent,
> >>> > Need
> >>> > Help, Formula Problem, Code Problem, and Need Advice will not get
> quick
> >>> > attention or may not be answered. 2) Don't post a question in the
> >>> > thread of
> >>> > another member. 3) Don't post questions regarding breaking or
> bypassing
> >>> > any
> >>> > security measure. 4) Acknowledge the responses you receive, good or
> >>> > bad. 5)
> >>> > Cross-promotion of, or links to, forums competitive to this forum in
> >>> > signatures are prohibited. NOTE : Don't ever post personal or
> >>> > confidential
> >>> > data in a workbook. Forum owners and members are not responsible for
> >>> > any
> >>> > loss.
> >>> >
> >>> >
> --
> >>> > To post to this group, send email to excel-macros@googlegroups.comTo
> >>> > unsubscribe, send a blank email to
> >>> > excel-macros+unsubscr...@googlegroups.com
> >>>
> >>> --
> >>> --
> >>> FORUM RULES (986+ members already BANNED for violation)
> >>>
> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will
> >>> not get quick attention or may not be answered.
> >>>
> >>> 2) Don't post a question in the thread of another member.
> >>>
> >>> 3) Don't post questions regarding breaking or bypassing any security
> >>> measure.
> >>>
> >>> 4) Acknowledge the responses you receive, good or bad.
> >>>
> >>> 5)  Cross-promotion of, or links to, forums competitive to this forum
> in
> >>> signatures are prohibited.
> >>>
> >>> NOTE  : Don't ever post personal or confidential data in a workbook.
> >>> Forum owners and members are not responsible for any loss.
> >>>
> >>>
> >>>
> --
> 

Re: $$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - July'11

[Divaker Pandey]

well done rajan, keep it up

lit and spread.

Divaker

On Tue, Jun 26, 2012 at 6:32 PM, Manish  wrote:

> Congr8ss Rajan...
>
> On Wednesday, August 3, 2011 10:52:02 PM UTC+5:30, Ayush Jain wrote:
>>
>>   Hello Everyone,

 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 July'11
 He has posted 170 posts in July 2011 and helped many people through his
 expertise. He has been consistent contributor to this excel forum and but
 achived this recognition for the first time.

>>>He has also created a record of highest number of posts by any
>> individual in a month.
>>
>>>

>>>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
>>> folks for helping excel enthusiasts !! keep it up !!
>>>
>>
>>   We as a group made a record of 1350+ posts in a month. Thanks
>> everyone...Thats really awesome. :)
>>
>>>
>>>Keep posting.
>>>
>>>
  Regards
 Ayush Jain
 Group Manager

>>>
>>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Hi Experts,

Still waiting for your response.

Divaker

On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey  wrote:

> Hi Noorain & Experts,
>
> Thanks for respond. please find attached file.
> on tab sheet1 there is two activeX control
>
> 1. Textbox -txtLookup
> 2. ListBox - lstLookup
>
> if user change value of textbox it search the input string in each column.
> and add in listbox all rows which string matched.
>
> I want to add headers.
>
> Please suggest asap.
>
>
> Divaker
>
>
> On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Divaker,
>>
>> Please share your Activelistbox with group.
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey 
>> wrote:
>> > Hi Ayush,
>> >
>> > I want to add header column text in Activelistbox through vba.
>> >
>> > Can you help me how i can add.
>> >
>> >
>> > Thanks.
>> >
>> > Divaker
>> >
>> > --
>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> concise,
>> > accurate thread titles. Poor thread titles, like Please Help, Urgent,
>> Need
>> > Help, Formula Problem, Code Problem, and Need Advice will not get quick
>> > attention or may not be answered. 2) Don't post a question in the
>> thread of
>> > another member. 3) Don't post questions regarding breaking or bypassing
>> any
>> > security measure. 4) Acknowledge the responses you receive, good or
>> bad. 5)
>> > Cross-promotion of, or links to, forums competitive to this forum in
>> > signatures are prohibited. NOTE : Don't ever post personal or
>> confidential
>> > data in a workbook. Forum owners and members are not responsible for any
>> > loss.
>> >
>> --
>> > To post to this group, send email to excel-macros@googlegroups.com To
>> > unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Problem with excel

[Divaker Pandey]

Hi Ayush,

I want to add header column text in Activelistbox through vba.

Can you help me how i can add.


Thanks.

Divaker

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

[Divaker Pandey]

yes, this is the problem, we want to different content each time, what is
on that specific rows

On Fri, Jun 22, 2012 at 5:52 PM, Rajan_Verma wrote:

> No option in excel to repeat row in bottom,
>
> You can use image of in centre footer.
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* 22 June 2012 3:43
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ All Ideas matter : Need your support here.
> 
>
> ** **
>
> 1. In PageSetup we have rows repeat at top, there should repeat at bottom
> as well.
>
>
> Divaker
> 9582060233
>
> On Thu, Jun 21, 2012 at 8:58 PM, Maries  wrote:
>
> *My Suggestion*
>
>
> http://www.google.com/moderator/#15/e=455db&t=455db.40&f=455db.66a716&q=455db.66a716
> 
>
>
>
>
> 
>
> On Tue, Jun 19, 2012 at 9:33 PM, Ayush Jain  wrote:
> 
>
> Dear members,
>
>  
>
> Last year,I started an initiative to collect ideas for improvements in
> excel. The initiative received the great response of 165 ideas and 1018
> votes.
>
>  
>
> If you have ideas and new features that you would like to see in upcoming
> version of MS Excel, you can submit the same 
> here<http://www.google.com/moderator/#16/e=455db>
> The only intent here is to make excel awesome for the users and give
> feedback to Microsoft on their product.
>
> Submit your idea here <http://www.google.com/moderator/#16/e=455db>
>
>
> If you dont have idea, you can 
> vote<http://www.google.com/moderator/#16/e=455db>the ideas of others and 
> support them. The ideas will be reviewed by
> Microsoft product team and they may incorporate if they like it.
>
>  
>
> Thanks all for supporting this initiative. 
>
>
> Best regards,
> Ayush Jain
>
> Group Manager
>
> Microsoft MVP
>
>  
>
> Have a feedback about group ? Submit 
> here<http://www.surveymonkey.com/s/3WM3FYH>
> 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> 
>
> -- 
>
> ** **
>
> *  MARIES*
>
> Excel Inspiration <http://xcel-inspiration.blogspot.com/>
>
> ** **
>
> -- 
>
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com 
>
> ** **
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
&

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

[Divaker Pandey]

1. In PageSetup we have rows repeat at top, there should repeat at bottom
as well.


Divaker
9582060233

On Thu, Jun 21, 2012 at 8:58 PM, Maries  wrote:

> *My Suggestion*
>
>
> http://www.google.com/moderator/#15/e=455db&t=455db.40&f=455db.66a716&q=455db.66a716
>
>
>
>
> On Tue, Jun 19, 2012 at 9:33 PM, Ayush Jain  wrote:
>
>> Dear members,
>>
>> Last year,I started an initiative to collect ideas for improvements in
>> excel. The initiative received the great response of 165 ideas and 1018
>> votes.
>>
>> If you have ideas and new features that you would like to see in upcoming
>> version of MS Excel, you can submit the same 
>> here
>> The only intent here is to make excel awesome for the users and give
>> feedback to Microsoft on their product.
>>  Submit your idea here 
>>
>> If you dont have idea, you can 
>> votethe ideas of others and 
>> support them. The ideas will be reviewed by
>> Microsoft product team and they may incorporate if they like it.
>>
>> Thanks all for supporting this initiative.
>>
>> Best regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> Have a feedback about group ? Submit 
>> here
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *
> *
> *  MARIES*
> Excel Inspiration 
>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sheet Requirements

[Divaker Pandey]

good reply don

On Tue, Jun 12, 2012 at 6:34 PM, dguillett1  wrote:

>   Forgive me but as I recall you have been a part of this group for
> awhile. If so, you should have learned enough to do this yourself.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Deba Ranjan 
> *Sent:* Tuesday, June 12, 2012 6:45 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sheet Requirements
>
> Dear Experts,
>
> i have attached a file which contains many sheets. in every sheets
> there contains data. i want a button which on clicking the whole sheet data
> consolidated. Please find the attached.
>
> thanks...
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Divaker Pandey]

I have created custom menu tab, but if i have open two workbook and switch
one to another, then i want to activate customtab menu, when i switch on
applicationworkbook. this time it always goto Home tab


Divaker

On Tue, Jun 12, 2012 at 6:25 PM, NOORAIN ANSARI wrote:

> Dear Divakar,
>
> Please see Ashish Koul created My Menu Add-In.
> I think your need to create this type of custom Menu.
>
> Please check and revert.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Tue, Jun 12, 2012 at 5:55 PM, Divaker Pandey wrote:
>
>> Thanks for reply ranjan, but i want that whenever i activate workbook
>> that contains customtab, it must selected by detault.
>>
>>
>> On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma wrote:
>>
>>> You can read about CustomUI Editor , it basically used to manipulate and
>>> create new ribbon in Excel 2007 and later
>>>
>>> ** **
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838100659 [IM-Gtalk]*
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
>>> *Sent:* 12 June 2012 3:03
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ want to add our own custom button and
>>> Tab in Excel 2007 name in place of add-in
>>>
>>> ** **
>>>
>>> Hi Expert,
>>>
>>> One more question if, i want to select my Custom Menu tab on each time
>>> workbook window activation, how i can i do it.
>>>
>>> Divaker
>>>
>>> On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey 
>>> wrote:
>>>
>>> Dear Ashish,
>>>
>>> Thanks from my bottom of hearts.
>>>
>>> I salute you.
>>>
>>> Divaker
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko 
>>> wrote:
>>>
>>> Try this
>>>
>>> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
>>>
>>> Regards,
>>> Sam Mathai Chacko
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul 
>>> wrote:
>>>
>>> check  this http://www.rondebruin.nl/ribbon.htm#Examples 
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey 
>>> wrote:
>>>
>>> Please help,
>>>
>>> ** **
>>>
>>> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey 
>>> wrote:
>>>
>>> thanks for reply noorain
>>>
>>> But I want as in attached snapshot. Custom Menu
>>>
>>> hope you will help soon.
>>>
>>> Divaker
>>>
>>>
>>>
>>>
>>>
>>>
>>> 
>>>
>>> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan <
>>> darwin.chankaw...@gmail.com> wrote:
>>>
>>> Hi Noorain,
>>>
>>> ** **
>>>
>>> Regarding the code provided from above, do the custom control button and
>>> tab include all operations too?
>>>
>>> ** **
>>>
>>> For example, the sorting button, the operations include in the following
>>> code? I would like to learn more from this.
>>>
>>> ** **
>>>
>>> .Caption = "Sort Names Descending"
>>> .OnAction = "SortList"
>>> .Parameter = "Dsc" 
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> 2012/3/29 NOORAIN ANSARI 
>>>
>>> See attached add-in's coding for reference
>>>
>>> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey 
>>> wrote:
>>>
>>>
>>> Hi Expert,
>>>
>>> I want to add our own custom button and Tab in Excel 2007 name in place
>>> add-in.
>>>
>>> Divaker
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need H

Re: $$Excel-Macros$$ Error handling matter

[Divaker Pandey]

thanks noorain bhai, but i want some more. please provide me

Divaker

On Tue, Jun 12, 2012 at 5:57 PM, NOORAIN ANSARI wrote:

> Dear Divaker,
>
> Please read CPearson site..Here is good example Error Handlers.
>
> http://www.cpearson.com/excel/errorhandling.htm
>
>
> On Tue, Jun 12, 2012 at 3:05 PM, Divaker Pandey wrote:
>
>> Hi Experts,
>>
>> can you please provide me some matter on error handling in vba
>> application.
>>
>> Divaker
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Divaker Pandey]

Thanks for reply ranjan, but i want that whenever i activate workbook that
contains customtab, it must selected by detault.

On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma wrote:

> You can read about CustomUI Editor , it basically used to manipulate and
> create new ribbon in Excel 2007 and later
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* 12 June 2012 3:03
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ want to add our own custom button and Tab
> in Excel 2007 name in place of add-in
>
> ** **
>
> Hi Expert,
>
> One more question if, i want to select my Custom Menu tab on each time
> workbook window activation, how i can i do it.
>
> Divaker
>
> On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey 
> wrote:
>
> Dear Ashish,
>
> Thanks from my bottom of hearts.
>
> I salute you.
>
> Divaker
>
> ** **
>
> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko 
> wrote:
>
> Try this
>
> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
>
> Regards,
> Sam Mathai Chacko
>
> ** **
>
> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul 
> wrote:
>
> check  this http://www.rondebruin.nl/ribbon.htm#Examples 
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey 
> wrote:
>
> Please help,
>
> ** **
>
> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey 
> wrote:
>
> thanks for reply noorain
>
> But I want as in attached snapshot. Custom Menu
>
> hope you will help soon.
>
> Divaker
>
>
>
>
>
>
> 
>
> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan 
> wrote:
>
> Hi Noorain,
>
> ** **
>
> Regarding the code provided from above, do the custom control button and
> tab include all operations too?
>
> ** **
>
> For example, the sorting button, the operations include in the following
> code? I would like to learn more from this.
>
> ** **
>
> .Caption = "Sort Names Descending"
> .OnAction = "SortList"
> .Parameter = "Dsc" 
>
> ** **
>
> ** **
>
> ** **
>
> 2012/3/29 NOORAIN ANSARI 
>
> See attached add-in's coding for reference
>
> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey 
> wrote:
>
>
> Hi Expert,
>
> I want to add our own custom button and Tab in Excel 2007 name in place
> add-in.
>
> Divaker
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
> 
>
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorainansari.com/*
>
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> 
>
>  
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
&

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

try this one

Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Run "'" + "idbiuploader.xlam" + "'!uploadingmodel"

End Sub


On Tue, Jun 12, 2012 at 4:22 PM, Dhartikumar Sahu wrote:

> hi divakar
>
> i have a addin
>
> whenever i close any workbook , it should be run from addins
>
> addinfile name: idbiuploader.xlam
> macro  name : uploadingmodel
>
> please help..
>
> Dhartikumar
>
>
> On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote:
>
>>
>> Hi Dharti,
>>
>> If i could understand your problem, then please use following code
>>
>>
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>>
>>  Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
>> argument2, argumentN
>>
>> End Sub
>>
>>
>>
>>
>> On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey wrote:
>>
>>> can you provide more details
>>>
>>>
>>>
>>> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>>>
>>>> **
>>>> Any update.
>>>> Sent from BlackBerry® on Airtel
>>>> --
>>>> *From: * dhartiku...@gmail.com
>>>> *Date: *Tue, 12 Jun 2012 07:15:16 +
>>>> *To: *
>>>> *ReplyTo: * dhartiku...@gmail.com
>>>> *Subject: *Re: $$Excel-Macros$$ call addin fuction before
>>>> activeworkbook close .. Urgent
>>>>
>>>> Urgently required code please.
>>>> Sent from BlackBerry® on Airtel
>>>> --
>>>> *From: * Dhartikumar Sahu 
>>>> *Sender: * excel-macros@googlegroups.com
>>>> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
>>>> *To: *
>>>> *ReplyTo: * excel-macros@googlegroups.com
>>>> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
>>>> close .. Urgent
>>>>
>>>> hi group
>>>>
>>>> i want a vba code for call addin fuction before any workbook close.
>>>>
>>>> please provide me code please..
>>>>
>>>> --
>>>>
>>>> *Regards,*
>>>>
>>>> *Dhartikumar Sahu*
>>>>
>>>> Sr.Database Manager - Institutional Equities
>>>>
>>>> * **IDBI Capital Markets Services Ltd*
>>>>
>>>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>>>>
>>>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>>>>
>>>>  --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

Hi Dharti,

If i could understand your problem, then please use following code


Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
argument2, argumentN

End Sub



On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey  wrote:

> can you provide more details
>
>
>
> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>
>> **
>> Any update.
>> Sent from BlackBerry® on Airtel
>> --
>> *From: * dhartiku...@gmail.com
>> *Date: *Tue, 12 Jun 2012 07:15:16 +
>> *To: *
>> *ReplyTo: * dhartiku...@gmail.com
>> *Subject: *Re: $$Excel-Macros$$ call addin fuction before activeworkbook
>> close .. Urgent
>>
>> Urgently required code please.
>> Sent from BlackBerry® on Airtel
>> --
>> *From: * Dhartikumar Sahu 
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
>> close .. Urgent
>>
>> hi group
>>
>> i want a vba code for call addin fuction before any workbook close.
>>
>> please provide me code please..
>>
>> --
>>
>> *Regards,*
>>
>> *Dhartikumar Sahu*
>>
>> Sr.Database Manager - Institutional Equities
>>
>> * **IDBI Capital Markets Services Ltd*
>>
>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>>
>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

can you provide more details


On Tue, Jun 12, 2012 at 3:31 PM,  wrote:

> **
> Any update.
> Sent from BlackBerry® on Airtel
> --
> *From: * dhartiku...@gmail.com
> *Date: *Tue, 12 Jun 2012 07:15:16 +
> *To: *
> *ReplyTo: * dhartiku...@gmail.com
> *Subject: *Re: $$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> Urgently required code please.
> Sent from BlackBerry® on Airtel
> --
> *From: * Dhartikumar Sahu 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> hi group
>
> i want a vba code for call addin fuction before any workbook close.
>
> please provide me code please..
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com