$$Excel-Macros$$ Introduce Yourself !!

[Michael Vinoth]

Hi Friends..

I am Michael Vinoth.. I have 5 years experience in developing the excel vba 
macros.. I love what I am doing.. Excel is my passion.. I hope I will learn 
many things from you all and I will share what I know.. 

Thanks
MV
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Help for error :Excel help viewer has encountered a problem & cannot continue.

[Michael Vinoth]

Hi Rohit,

Check this :- 
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae

Regards,
MV

On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote:

> Hi 
> I'm not able to access any help from Excel 2007. I have attached the error 
> snap shot here. I tried reinstalling Excel but after sometime it comes 
> back. I also downloaded latest updates from MS site but it did not make any 
> difference. Has any one faced & solved this problem successfully.  Also its 
> weird that this problem exists only in excel & all other MS Office 
> application help runs without any error. Please help.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Michael Vinoth]

Welcome... :)

On Friday, May 15, 2015 at 9:39:49 PM UTC+5:30, Pankaj Sharma wrote:
>
>  THANK YOU Once again !!!
>
>  
>
> After few changes I’m able to run this Macro. 
>
>  
>
> For learners info:
>
> First, Make sure that “Adobe Reader File Preview Type Library” selected in 
> References option in Tools menu. 
>
> Second, in Adobe Reader => View => Page Display => select “Enable 
> Scrolling”, so that this macro can copy all pages data.
>
>  
>
>  
>
>  
>
> Regards
>
>  
>
> Pankaj Sharma
>
>  
>
>  
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Michael Vinoth
> *Sent:* Friday, May 15, 2015 6:45 PM
> *To:* excel-...@googlegroups.com 
> *Cc:* polkar...@gmail.com 
> *Subject:* Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require
>  
>  
>  
> Hi Pankaj Sharma ,
>  
>  
>  
> Thank you for your Appreciation... :)
>  
>  
>  
> The macro is working fine for me.
>  
>  
>  
> I attached the Macro and Output Files.
>  
>  
>  
> I am using MS Excel 2007, Adobe Reader XI and windows 7 (64 bit) 
> combination. Please mention your Excel, Adobe and Windows version to help 
> you further.
>  
>  
>  
> Let me know if you have any queries.
>  
>  
>  
> Regards,
>  
> MV
>
> On Friday, May 15, 2015 at 1:00:27 AM UTC+5:30, Pankaj Sharma wrote:
>  
>  Hi MV,
>
>  
>
> Firstly, I want to say thanks for sharing this valuable Macro. People 
> already had given up hope but you have done a great work here.
>
>  
>
> In this macro, getting runtime error in below line:- Invalid procedure 
> call or argument.
>
>  
>
> AppActivate "Adobe Reader
>
>  
>
>  
>
> And also, if any PDF file have 2/3 pages, only 1st page is copying, need 
> to copy  all 3 pages data.
>
>  
>
>  
>
> Thanks again!!!
>
>  
>
>  
>
> Regards
>
>  
>
> PJ
>
>  
>
>  
>  
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On 
> Behalf Of *Michael Vinoth
> *Sent:* Thursday, May 14, 2015 12:31 AM
> *To:* excel-...@googlegroups.com
> *Cc:* polkar...@gmail.com
> *Subject:* Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require
>  
>  
>  
> Hi Pankaj Sharma ,
>  
>  
>  
> Please find the attached macro file.
>  
>  
>  
> kindly let me know if you have any queries.
>  
>  
>  
> Regards,
>  
> MV
>
> On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:
>  
>  i recd 20-30 Mobile Bills in PDF format every month, which i need to 
> copy in Excel with different sheets.
>  
> That's what i want to make automate.
>
>   
>  
> On Sat, May 9, 2015 at 11:21 AM, Pol Ktk  wrote:
>  
> Are you working with cdr ?
>  
> if s
>  
> what exactly u need ?
>
>  
>  
> On 8 May 2015 at 18:44, Pankaj Sharma  wrote:
>  
> Please find attached file.
>   
>  
>  
> On Fri, May 8, 2015 at 5:27 PM, Vabz  wrote:
>  
> can you share PDF file, if it is text only then same can be imported..
>
> On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:
>  
> Hi everyone,
>  
>  
>  
> Need your help for this easy. I have a folder with multi PDF files. I need 
> a macro to copy all pdf data in a workbook.
>  
>  
>  
> Note: One pdf data should be copy in one sheet.
>  
>  
>
> -- 
> 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...@googlegroups.com.
> To post to this group, send 

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Michael Vinoth]

Hi Pankaj Sharma ,

Thank you for your Appreciation... :)

The macro is working fine for me.

I attached the Macro and Output Files.

I am using MS Excel 2007, Adobe Reader XI and windows 7 (64 bit) 
combination. Please mention your Excel, Adobe and Windows version to help 
you further.

Let me know if you have any queries.

Regards,
MV

On Friday, May 15, 2015 at 1:00:27 AM UTC+5:30, Pankaj Sharma wrote:

>  Hi MV,
>
>  
>
> Firstly, I want to say thanks for sharing this valuable Macro. People 
> already had given up hope but you have done a great work here.
>
>  
>
> In this macro, getting runtime error in below line:- Invalid procedure 
> call or argument.
>
>  
>
> AppActivate "Adobe Reader
>
>  
>
>  
>
> And also, if any PDF file have 2/3 pages, only 1st page is copying, need 
> to copy  all 3 pages data.
>
>  
>
>  
>
> Thanks again!!!
>
>  
>
>  
>
> Regards
>
>  
>
> PJ
>
>  
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Michael Vinoth
> *Sent:* Thursday, May 14, 2015 12:31 AM
> *To:* excel-...@googlegroups.com 
> *Cc:* polkar...@gmail.com 
> *Subject:* Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require
>  
>  
>  
> Hi Pankaj Sharma ,
>  
>  
>  
> Please find the attached macro file.
>  
>  
>  
> kindly let me know if you have any queries.
>  
>  
>  
> Regards,
>  
> MV
>
> On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:
>  
>  i recd 20-30 Mobile Bills in PDF format every month, which i need to 
> copy in Excel with different sheets.
>  
> That's what i want to make automate.
>
>
>   
>  
> On Sat, May 9, 2015 at 11:21 AM, Pol Ktk  wrote:
>  
> Are you working with cdr ?
>  
> if s
>  
> what exactly u need ?
>
>  
>  
> On 8 May 2015 at 18:44, Pankaj Sharma  wrote:
>  
> Please find attached file.
>
> 
>  
> On Fri, May 8, 2015 at 5:27 PM, Vabz  wrote:
>  
> can you share PDF file, if it is text only then same can be imported..
>
> On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:
>  
> Hi everyone,
>  
>  
>  
> Need your help for this easy. I have a folder with multi PDF files. I need 
> a macro to copy all pdf data in a workbook.
>  
>  
>  
> Note: One pdf data should be copy in one sheet.
>  
>  
>
> -- 
> 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...@googlegroups.com.
> To post to this group, send email to excel-...@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 bec

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Michael Vinoth]

Hi Pankaj Sharma ,

Please find the attached macro file.

kindly let me know if you have any queries.

Regards,
MV

On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:

> i recd 20-30 Mobile Bills in PDF format every month, which i need to copy 
> in Excel with different sheets.
>
> That's what i want to make automate.
>
>
>
>
> On Sat, May 9, 2015 at 11:21 AM, Pol Ktk  > wrote:
>
>> Are you working with cdr ?
>> if s
>> what exactly u need ?
>>
>> On 8 May 2015 at 18:44, Pankaj Sharma > 
>> wrote:
>>
>>> Please find attached file.
>>>
>>>
>>>
>>> On Fri, May 8, 2015 at 5:27 PM, Vabz > wrote:
>>>
 can you share PDF file, if it is text only then same can be imported..

 On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:
>
> Hi everyone,
>
> Need your help for this easy. I have a folder with multi PDF files. I 
> need a macro to copy all pdf data in a workbook.
>
> Note: One pdf data should be copy in one sheet.
>
>  -- 
 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...@googlegroups.com .
 To post to this group, send email to excel-...@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...@googlegroups.com .
>>> To post to this group, send email to excel-...@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.


PDF to Excel Macro.x

Re: $$Excel-Macros$$ Re: Send Email to Persons in a column Range

[Michael Vinoth]

Welcome... ;-)

On Friday, April 24, 2015 at 11:41:22 PM UTC+5:30, hilary lomotey wrote:
>
> Solid Boss,
>
> thanks exactly what i needed
>
> On Thu, Apr 23, 2015 at 9:08 PM, Michael Vinoth  > wrote:
>
>>  [image: Boxbe] <https://www.boxbe.com/overview> This message is 
>> eligible for Automatic Cleanup! (michael...@gmail.com ) Add 
>> cleanup rule 
>> <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DivNWfiEWa5b8v5D5Qogd8VxnBMMI2DWVEeJEyyVYkA%252Frc%252FjYjG5XHuhU%252FjkajBLIpAl29vru9Ii84sVEY6A2NCKvKloCS8GgfRLEXCv3gdVjqhocu9Ewq%252FgbP0rpVMZoT7%252FYen2t%252F8sx9yRVftCPfQ%253D%253D%26key%3D0%252Bf8YxtGlbr8tJQl47Rc9dV8UAdz9%252BMPMv5eAuUWrUQ%253D&tc_serial=21117548540&tc_rand=2102742567&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>
>>  
>> | More info 
>> <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=21117548540&tc_rand=2102742567&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>
>>  
>>  
>> Hi Hilary Lomotey,
>>
>> Please find the attached macro file.
>>
>> Kindly let me know if you any queries.
>>
>> Regards,
>> MV
>>
>> On Tuesday, April 21, 2015 at 9:26:43 PM UTC+5:30, hilary lomotey wrote:
>>
>>> Hello Experts,
>>>
>>> i have attached an excel sheet which copies a portion of an excel 
>>> worksheet and attaches it to an outlook mail which is perfect however, i 
>>> want an additional code o modify this existing code to send email to a 
>>> people in a range, eg in the attached sheet send email to address in column 
>>> H and salute the people by their name. kindly assist with code. 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...@googlegroups.com .
>> To post to this group, send email to excel-...@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$$ Re: Send Email to Persons in a column Range

[Michael Vinoth]

Hi Hilary Lomotey,

Please find the attached macro file.

Kindly let me know if you any queries.

Regards,
MV

On Tuesday, April 21, 2015 at 9:26:43 PM UTC+5:30, hilary lomotey wrote:

> Hello Experts,
>
> i have attached an excel sheet which copies a portion of an excel 
> worksheet and attaches it to an outlook mail which is perfect however, i 
> want an additional code o modify this existing code to send email to a 
> people in a range, eg in the attached sheet send email to address in column 
> H and salute the people by their name. kindly assist with code. 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.


Send Email to Number of People as attachment.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

[Michael Vinoth]

Hi Nasir Saikh,

Try this:- 
https://support.office.com/en-ca/article/Use-a-shared--workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61?ui=en-US&rs=en-CA&ad=CA

Regards,
MV

> On 18-Mar-2015, at 3:51 pm, Nasir Saikh  wrote:
> 
> Anybody Can help me out on this
> 
>> On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote:
>> Hi,
>> 
>> I need help to make a excel workbook which should use by more than 5 members 
>> at a single time and all can save the workbook at a time.
>> 
>> Please help me i am stuck on it
>> 
>> Regards
>> Nasir Shaikh
>> 876702
> 
> -- 
> 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$$ Excel Formula. Seems simples but i can't figure out how to do it

[michael vinoth]

Hi André D'Avila,

Please try this formula "=INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0))"
in cell J2 and also find the attached file.

Regards,
MV

On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila 
wrote:

> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In the first hand seems simples, but i couldn't sove without creating a
> excel macro.
>
> Is it possible to create a fórmula to the challenge bellow?
> I attached the file too.
>
> Thx.
>
> André Luiz D´Avila
>
> [image: Imagem inline 1]
>
> --
> 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.


procura vertical.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Sum value of closing balance of date

[Michael Vinoth]

Hi Ashish,

Please find the attached macro file.

Regards,
MV

On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote:

> Dear experts,
>
> I need function to sum only closing value of particular date, pls see 
> attached file for example. 
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary. 
> Spread environmental üawareness.♣♣♣*
>
> 

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


Quer of Sum.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Please help me Urgent

[Michael Vinoth]

Very Nice... Mr.Vabz

On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:

> Suppose you have value in cell A1 then type follo. formula in A2 & dont 
> press enter & press F9, you will get result in curly bracket, after = sign 
> enter CONCATENATE( & press enter to get result
>
>
> =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),LOWER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
>
> Cheers!!
>
> On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani  > wrote:
>
>> Hi Guys,
>>
>>
>> I have a query . In this sentence.. "This iS a tEst" .
>>
>> All Upper case alphabets should be lower case and All Lowercase alphabets 
>> should be in Upper case. Please help me . I want that to be done in excel 
>> formulas.(If thats possible).
>>
>>
>>  
>> Thanks & Regards
>> Gaurav Devrani
>>
>>  -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@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$$ Shape Colors (VBA)

[michael vinoth]

Hi Smith,

Can you send the model of excel file for more clarity.

Regards,
MV

On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith  wrote:

> Hi. If anyone can assist.
>
> I have a map of the world in individual shapes per country, each named.
> I have a sales spreadsheet which, through Pivot Tables, converts the sales
> into percentages.
> Using this, conditional formatting colors the cells according to
> percentage.
> This will change on a regular basis, so needs some automation.
> I need to first get the RGB color information from each of the cells and
> change the color of the country to match.
>
> I have been playing around with Module:
> With ActiveSheet
> .Shapes("USA").Fill.ForeColor.RGB = RGB(43, 136, 154)
> .Shapes("UK").Fill.ForeColor.RGB = RGB(167, 227, 28)
> 'and so on
> End With
>
> Can anyone assist? Knowledge of VBA is nil, but willing to learn
>
> --
> 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$$ Re: Excel VBA Example

[michael vinoth]

Nice.. Nikanth Raval...

On Tuesday, March 3, 2015 at 8:03:45 AM UTC+5:30, Nilkanth Raval wrote:

> Hi Friends,
>
> Find attached some examples of VBA Macro
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 000 1620*
> *Think Before You Print.Consider ENVIRONMENT.*
> *“SAVE TREES, SAVE EARTH” *
>  
> *“All appears to change when we change!”*
>
> 

-- 
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$$ Re: PLS SOLVE

[michael vinoth]

Hi David,

Please find the attached macro file.

Regards,
MV

On Monday, March 9, 2015 at 10:05:03 AM UTC+5:30, sush@gmail.com wrote:
>
>
>

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


Pls Solve query.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Help Needed

[michael vinoth]

Dear Friend Dhaval,

Thanks for your comments. As per the given requirement i thought this would
be the suitable coding. May be I am not understand you exact requirement
properly. If possible could you please let me know you requirement clearly
once again so that I can try to help you to solve the macro.

Have a nice day.

Regards,
MV

On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth 
wrote:

> Hi Dhaval Shah,
>
> Please find the attached macro file.
>
> Regards,
> MV
>
> On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
>>
>> Dear Friends
>>
>> Pls find attached file of my work
>>
>> In sheet two sheets one is main sheet & another is daily data
>>
>> in main sheet yellow mark is the difference of two dates i want to do
>> this automatic becuase @ present i do it mannual and its taking too much
>> time pls give me suggestion
>>
>>
>> Warm Regards,
>>
>> Dhaval Shah
>> M) 98240 35253
>> *E-mail : todhav...@gmail.com*
>>
>>
>>   --
> 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$$ Re: Help Needed

[michael vinoth]

Hi Dhaval Shah,

Please find the attached macro file.

Regards,
MV

On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
>
> Dear Friends 
>
> Pls find attached file of my work 
>
> In sheet two sheets one is main sheet & another is daily data 
>
> in main sheet yellow mark is the difference of two dates i want to do this 
> automatic becuase @ present i do it mannual and its taking too much time 
> pls give me suggestion 
>
>
> Warm Regards,
>
> Dhaval Shah 
> M) 98240 35253
> *E-mail : todhav...@gmail.com *
>
>
>  

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


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

$$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

[michael vinoth]

Hi Ashish,

Please find the attached macro file.

Regards,
MV

On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara wrote:
>
> Dear expert,
>
> I need help in attached file in which if cheque amount is greater than 
> zero and date & cheque number field Blank then msgbox should display, and 
> when cheque amount is blank, no any msgbox should display.
>
> In my case and as per my formula the msgbox display even cheque amt. field 
> is zero.
>
> Kindly see attached file to solve my query, I tried different way in 
> codding but did't get result.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary. 
> Spread environmental üawareness.♣♣♣*
>
> 

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


Query VBA If formula.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

[michael vinoth]

Welcome... :)

On Thursday, February 26, 2015 at 2:25:08 PM UTC+5:30, Sal Sal wrote:
>
> no words!
> this is exactly wath i need.
> Tks for all. 
>
> 2015-02-26 6:28 GMT+01:00 Vaibhav Joshi >:
>
>> This is superb MV
>>
>> Cheers!!
>>
>> On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth > > wrote:
>>
>>> Hi Sal Sal ,
>>>
>>> Please find the attached updated macro file.
>>>
>>> Regards,
>>> MV
>>>
>>> On Wednesday, February 25, 2015 at 1:41:10 AM UTC+5:30, Sal Sal wrote:
>>>
>>>> hummm
>>>> but i dont see any and paticular effect, simple a list of value of 
>>>> combo, nomouse over on each item.
>>>> Tks for code in other case
>>>>
>>>> 2015-02-23 22:36 GMT+01:00 michael vinoth :
>>>>
>>>>> *Hi Sal Sal,*
>>>>>
>>>>> Please find the attached macro file.
>>>>>
>>>>> Regards,
>>>>> MV
>>>>>
>>>>>
>>>>> On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
>>>>>
>>>>>> Possible to show a toltiptext on mouse over on each items of combobox?
>>>>>>  
>>>>>> Note:
>>>>>> combobox is on a vba  useform
>>>>>>
>>>>>  -- 
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>>>> https://www.facebook.com/discussexcel
>>>>>  
>>>>> FORUM RULES
>>>>>  
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security 
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>  
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>>>>> and members are not responsible for any loss.
>>>>> --- 
>>>>> You received this message because you are subscribed to a topic in the 
>>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/
>>>>> topic/excel-macros/6daPkaYsncg/unsubscribe.
>>>>> To unsubscribe from this group and all its topics, send an email to 
>>>>> excel-macros...@googlegroups.com.
>>>>> To post to this group, send email to excel-...@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...@googlegroups.com .
>>> To post to this group, send email to excel-...@googlegroups.com 
>>> .
>>> Visit 

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

[michael vinoth]

Thankl You Vabz... :)

On Thursday, February 26, 2015 at 10:59:17 AM UTC+5:30, Vabz wrote:
>
> This is superb MV
>
> Cheers!!
>
> On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth  > wrote:
>
>> Hi Sal Sal ,
>>
>> Please find the attached updated macro file.
>>
>> Regards,
>> MV
>>
>> On Wednesday, February 25, 2015 at 1:41:10 AM UTC+5:30, Sal Sal wrote:
>>
>>> hummm
>>> but i dont see any and paticular effect, simple a list of value of 
>>> combo, nomouse over on each item.
>>> Tks for code in other case
>>>
>>> 2015-02-23 22:36 GMT+01:00 michael vinoth :
>>>
>>>> *Hi Sal Sal,*
>>>>
>>>> Please find the attached macro file.
>>>>
>>>> Regards,
>>>> MV
>>>>
>>>>
>>>> On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
>>>>
>>>>> Possible to show a toltiptext on mouse over on each items of combobox?
>>>>>  
>>>>> Note:
>>>>> combobox is on a vba  useform
>>>>>
>>>>  -- 
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>>> https://www.facebook.com/discussexcel
>>>>  
>>>> FORUM RULES
>>>>  
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security 
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>  
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>>>> and members are not responsible for any loss.
>>>> --- 
>>>> You received this message because you are subscribed to a topic in the 
>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this topic, visit https://groups.google.com/d/
>>>> topic/excel-macros/6daPkaYsncg/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to 
>>>> excel-macros...@googlegroups.com.
>>>> To post to this group, send email to excel-...@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...@googlegroups.com .
>> To post to this group, send email to excel-...@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$$ Re: Removing duplicates within cell

[michael vinoth]

Welcome Chandru.. :)

On Wednesday, February 25, 2015 at 11:53:57 AM UTC+5:30, Chandru wrote:
>
> Hello Michael,
>  
> Thanks for the solution.
>  
> Regards,
>  
> Chandru
>
> On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth  > wrote:
>
>> Hi Chandru,
>>
>> Please find the attached macro files for Removing Duplicates within the 
>> cell.
>>
>> Kindly let me know, if you have any queries.
>>
>> Regards,
>> MV
>>
>> On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote:
>>
>>> Hello,
>>>  
>>> How to remove duplicates within a cell using VBA?
>>>  
>>> Please find attached sample file for the same.
>>>  
>>> Regards,
>>>  
>>> Chandru
>>>
>>  -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@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$$ Re: mouseover on list of item in combobox

[michael vinoth]

Hi Sal Sal ,

Please find the attached updated macro file.

Regards,
MV

On Wednesday, February 25, 2015 at 1:41:10 AM UTC+5:30, Sal Sal wrote:

> hummm
> but i dont see any and paticular effect, simple a list of value of combo, 
> nomouse over on each item.
> Tks for code in other case
>
> 2015-02-23 22:36 GMT+01:00 michael vinoth  >:
>
>> *Hi Sal Sal,*
>>
>> Please find the attached macro file.
>>
>> Regards,
>> MV
>>
>>
>> On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
>>
>>> Possible to show a toltiptext on mouse over on each items of combobox?
>>>  
>>> Note:
>>> combobox is on a vba  useform
>>>
>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/excel-macros/6daPkaYsncg/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@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.


Tooltip Text Macro.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Export Data on new Sheet with same Id of that column

[michael vinoth]

Hi Harpreet Singh,

Please find the attached macro file.

Regards,
MV

On Saturday, February 21, 2015 at 1:35:35 PM UTC+5:30, Harpreet Singh wrote:

> First of all let me tell you all that i am totally new to Excel. I never 
> used it before.. I am in a little trouble, so i need help of your guyz... 
> Hope you guyz will help me.
>  
> My Problem is :
>
>
> 
>  
> I have two columns "Sr.No" and "Previous Posting" as showing in the image 
> 1 (Current Situation). Sr.No columns contains numbers in series and 
> "Previous posting" contains all the posting details in the same column but 
> in different rows..
>  
> Now i want to save all these posting details in a new sheet but not in a 
> single column. Every posting detail should be in a new row with same Serial 
> Number which belongs to that column, rather than all the posting record in 
> a single column.
>  
> Results should be like as showing in image 2:
>  
> I hope you will understand my question and suggest me how to do this as i 
> am totally new.
>

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


Export Data on new Sheet.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Removing duplicates within cell

[michael vinoth]

Hi Chandru,

Please find the attached macro files for Removing Duplicates within the 
cell.

Kindly let me know, if you have any queries.

Regards,
MV

On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote:

> Hello,
>  
> How to remove duplicates within a cell using VBA?
>  
> Please find attached sample file for the same.
>  
> Regards,
>  
> Chandru
>

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


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

$$Excel-Macros$$ Re: mouseover on list of item in combobox

[michael vinoth]

*Hi Sal Sal,*

Please find the attached macro file.

Regards,
MV


On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:

> Possible to show a toltiptext on mouse over on each items of combobox?
>  
> Note:
> combobox is on a vba  useform
>

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


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

$$Excel-Macros$$ Re: how can I color with the help of list I simple want intersection to be color if cell of intersection

[michael vinoth]

Thank you... :)

On Wednesday, February 18, 2015 at 10:06:47 AM UTC+5:30, Mandeep baluja 
wrote:
>
> awesome looping thanks :) i will apply it on a huge data by changing the 
> parametres. 
>
> On Tuesday, 17 February 2015 16:10:37 UTC+5:30, Mandeep Baluja wrote:
>>
>> help required !! 
>>
>

-- 
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$$ Re: Want to disable copy, cut & paste

[michael vinoth]

Welcome Abdulgani...

On Saturday, February 14, 2015 at 9:54:44 AM UTC+5:30, ITP Abdulgani wrote:
>
> Thanks Michael, I will go through it and will update.
>
> On Sat, Feb 14, 2015 at 1:38 AM, michael vinoth  > wrote:
>
>> Hi Abdulgani,
>>
>> Please check this..
>>
>> http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=85
>>
>> On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wrote:
>>
>>> I want to disable copy, cut & paste in the attached file.
>>>
>>> And I also request 
>>>
>>> If Copy, cut paste is disable in this file, it should not disable it in 
>>> other files on my PC.
>>>
>>> Regards
>>>
>>>
>>> -- 
>>> Shaikh AbdulGani A R
>>> ITP, STP, TRP, STRP
>>>  
>>  -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
>  

-- 
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$$ Re: how can I color with the help of list I simple want intersection to be color if cell of intersection

[michael vinoth]

Hi Mandeep,

Please find the attached macro file.

kindly check and let me know, if you have any questions or queries.

Regards,
MV

On Tuesday, February 17, 2015 at 4:10:37 PM UTC+5:30, Mandeep Baluja wrote:

> help required !! 
>

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


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

$$Excel-Macros$$ Re: Want to disable copy, cut & paste

[michael vinoth]

Hi Abdulgani,

Please check this..

http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=85

On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wrote:

> I want to disable copy, cut & paste in the attached file.
>
> And I also request 
>
> If Copy, cut paste is disable in this file, it should not disable it in 
> other files on my PC.
>
> Regards
>
>
> -- 
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
>  

-- 
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$$ Re: Run time error...

[michael vinoth]

Welcome Christos... 

On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos 
wrote:

>
> Hi Michael,
>  
> That works perfect thank you!!!
>  
> Cheers,
> Christos
>

-- 
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$$ Re: Run time error...

[michael vinoth]

Hi Christos,

Try this code...

Sub Button1_Click()

Dim WS As Worksheet
Dim Search As String
Dim Replacement As String
Dim Prompt As String
Dim Title As String
Dim ID As String
Dim mu As String
Dim temp As Long
Dim R As Long
Dim C As Long
Dim MatchCase As Boolean
Prompt = "What is the risk ID?"
Title = "Search Value Input"
ID = InputBox(Prompt, Title)
Prompt = "What is the original value you want to replace?"
Title = "Search Value Input"
Search = InputBox(Prompt, Title)
Prompt = "What is the replacement value?"
Title = "Search Value Input"
Replacement = InputBox(Prompt, Title)

If Search = Empty Or Replacement = Empty Then
End
End If

For Each WS In Worksheets
WS.Select
WS.Activate
R = WS.UsedRange.SpecialCells(xlCellTypeLastCell).Row
C = WS.UsedRange.SpecialCells(xlCellTypeLastCell).Column
WS.Range(Cells(1, 1), Cells(R, C)).Select
On Error Resume Next
Selection.replace What:=Search, Replacement:=Replacement, 
LookAt:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False, 
SearchFormat:=False, ReplaceFormat:=False
On Error GoTo 0
Next WS

End Sub


On Monday, February 9, 2015 at 3:48:24 PM UTC+5:30, Christos Alekopoulos 
wrote:

> Hi All,
>  
> I have created this code that finds a value, then changes any pre-set 
> value into a new value determined by the user as well. The problem is that 
> I get an "error 424" and a message item required every time I run it. I 
> have highlighted the line where it seems to have the error. The code is the 
> following. Every idea and any help is really appreciated.
>  
> Thank you 
> Christos
>  
> Sub replace()
> Dim WS As Worksheet
> Dim Search As String
> Dim Replacement As String
> Dim Prompt As String
> Dim Title As String
> Dim ID As String
> Dim mu As String
> Dim temp As Long
> Dim MatchCase As Boolean
> Prompt = "What is the risk ID?"
> Title = "Search Value Input"
> ID = InputBox(Prompt, Title)
> Prompt = "What is the original value you want to replace?"
> Title = "Search Value Input"
> Search = InputBox(Prompt, Title)
> Prompt = "What is the replacement value?"
> Title = "Search Value Input"
> Replacement = InputBox(Prompt, Title)
> For Each WS In Worksheets
>  Set r = WS.Cells.Find(myTask, , , 1)
> If Not r Is Nothing Then
> ff = r.Address
> 'temp = r.EntireRow.Value
> ' r.EntireRow.Value
> temp = r.EntireRow.Value.Cells.replace(What:=Search, 
> Replacement:=Replacement)
> End If
>  'mu = temp.Cells.replace(What:=Search, Replacement:=Replacement)
>  'temp = r.EntireRow.Value.Cells.replace(What:=Search, 
> Replacement:=Replacement)
>  
> Next
> 'temp.Cells.replace What:=Search, Replacement:=Replacement, _
> 'LookAt:=xlPart, MatchCase:=False
> 'mu = temp.Cells.replace(What:=Search, Replacement:=Replacement)
> 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$$ MOS Certificate Query

[michael vinoth]

Thank You Ashish..

On Thursday, February 5, 2015 at 8:34:27 PM UTC+5:30, Ashish Kumar wrote:
>
> HI MV,
>
> Check this :
>
>
> http://education-portal.com/microsoft_office_specialist_certification_online.html
>
>
>
>
> Regards
> Ashish
>

-- 
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$$ MOS Certificate Query

[michael vinoth]

Hi All,

I would like to go for a MOS Certificate in excel 2007. I need some support 
for the following queries.

how to approach on this exam?
What would be the syllabus?
Is there any fees details available?

Please share your thoughts and comments.

Wish you all a Great day.

Thank you
MV 

-- 
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$$ Re: How to convert PDF file to Excel file using excel vba?

[michael vinoth]

Thank u... Paul... & Vabz...

On Thursday, February 5, 2015 at 1:25:18 AM UTC+5:30, michael vinoth wrote:
>
> Dear All,
>
> I have a doubt.
>
> How to convert PDF file to Excel file using excel vba?
>
> It is very useful to me.
>
> Thanks in advance...
>

-- 
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 with looping a find - cut - paste macro Excel 2013

[michael vinoth]

Hi,

Sub CommandButton_Click()

Dim i As Long

For i = 1 To Range("K65000").End(xlUp).Row
If Trim(Range("K" & i).Text) = Empty Then
Range("L" & i).Cut
Range("P" & i).Select
ActiveSheet.Paste
End If
Next I

End Sub

On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30, Vabz wrote:

> Hi
>
> Try below code..
>
> Sub blah()
> Dim fRow As Range, lRow As Range, rRange As Range
> Dim c As Range
> Set fRow = Range("K2")
> Set lRow = Range("K" & Rows.Count).End(3)
> Debug.Print lRow.Row
> Set rRange = Range(fRow.Address & ":" & lRow.Address)
> Debug.Print rRange.Address
> For Each c In rRange
> If IsEmpty(c) Then
> c.Offset(0, 5).Value = c.Offset(0, 1).Value
> c.Offset(0, 1).Value = ""
> End If
> Next
> End Sub
>
> Cheers!!
>
> On Thu, Jan 8, 2015 at 11:15 PM, JenIT  > wrote:
>
>> I have a macro I am working on.  I have found a way do the find, cut and 
>> paste, but it does not loop,  It stops after it does the find, cut and 
>> paste one time. 
>>
>> When there are blanks in K there will be data data sitting in L that 
>> needs to be moved to P.  I 
>>
>>
>>
>> KLM NOP123  main streetSEDALIAMO65301999-111-19.985.23
>>
>> Below is the code I used to find a blank K to then cut L to paste in P, 
>> but it only works for the first line.  I need it to loop through a variable 
>> length sheet.  A column that will be full until the end of the sheet if 
>> needed to reference an end is column C.  
>>
>> Range("K:K").Select
>>  Selection.SpecialCells(xlCellTypeBlanks).Select
>> ActiveCell.Offset(0, 1).Select
>> Selection.Cut
>> ActiveCell.Offset(0, 4).Select
>> ActiveSheet.Paste
>>
>>
>>
>>
>>  -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@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 convert PDF file to Excel file using excel vba?

[michael vinoth]

Dear All,

I have a doubt.

How to convert PDF file to Excel file using excel vba?

It is very useful to me.

Thanks in advance...

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