$$Excel-Macros$$ Looking For Job : Power BI and VBA - Must read

[Ravi Kumar]

Hello everyone,

Humble request, please spend 2 minutes to read my mail below.

Just wanted to know, we everyone had started as a fresher. If no one going
to hire fresher then how new people will join the industry and how we will
get talented people come and join us.

Guys, please have a look one time. This guy is extremely talented in Power
BI and VBA with good communication skill but companies want someone who
have some experience. Question is how this some experience start for
freshers.

You will not regret to hire him after knowing his skills and even don't
feel that he is fresher. Very hardworking and dedicated towards learning.

Your Friends,
Ravi Kumar

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/CAKNmkWrn_cOr9Gbjk3xiXv3dS0cYHV_peJ3wCwvXMcKGZg9%2B7Q%40mail.gmail.com.


Ashish Resume.docx
Description: MS-Word 2007 document

$$Excel-Macros$$ Reference external data in drop-down lists

[Ravi Kumar]

I know how to create a data validation drop-down list that references data 
in another workbook..
is it possible to do it with data from a non-spreadsheet file or Excel 
 File e.g word or access & if so how do I do so?

-- 
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: Happy new year

[Ravi Kumar]

Happy New Year 
http://www.excelrush.com/


On Friday, January 1, 2016 at 9:44:20 AM UTC+5:30, shrini wrote:
>
> Happy new year to all members.
> Last year I really got excellent support from all members.
> I hope same will be continue .
> Special thanks to Noorani sir .
> -- 
> Shrini
>

-- 
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: Maximum number of shortcut keys

[Ravi Kumar]

I think you can go and check other shortcuts for excel on 
http://www.excelrush.com/shortcuts-to-navigate-within-data/  



On Sunday, December 27, 2015 at 11:11:51 PM UTC+5:30, B D wrote:
>
> First I am very much a amateur and
> I am attempting to create a multiple choice test in excel 2010. I have the 
> formula and macros down. My problem is there are 218 questions with 3 
> choices per question and it seems that I can only use 52 shortcut key 
> combinations. Is this correct or is their another way to assign shortcut 
> keys. There may also be a better way of doing this and I would be open to 
> any suggestions. 

-- 
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: Introduce Yourself !!

[Ravi Kumar]

HI I am Ravi,

I just started learning Excel thru http://www.excelrush.com/.

Thank you

On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Need help to click on Ok button when message from web page

[Ravi Kumar]

Hi,

 

Add below line in your code. Might be it works

 

webbrowser.Silent = True

 

‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use 
ie instead of ‘webbrowse’

 

 

Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Sunil Patil
Sent: Friday, November 28, 2014 10:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help to click on Ok button when message from web 
page

 

Hi there,

 

recently i am doing IE automaton. However this is dealing with one ASP site,, 
and i am accessing internal objects almost i am reaching to close this project,

 

But at there end there is close claim button once i click through vba code 
there is one alert saying message from web page,, and my messge is to clik on 
OK button of that alert.

can anyone send me the code for removing this alert, help would be more 
appriciated.

 

Regards,

Sunil

 

-- 
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$$ Copy paste data from one sheet to another based on click

[Ravi Kumar]

Hi,

 

 

Click on the button and result would be populate below.

 

 

Regards,
Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Kumar
Sent: Friday, November 28, 2014 9:57 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy paste data from one sheet to another based 
on click

 

Hi Joseph,

 

PFA

 

 

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.

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


Copy of COPY_Paste.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

[Ravi Kumar]

Hi,


use below or pfa

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value   Then
If Target.Comment Is Nothing Then
Target.AddComment
Target.Comment.Text Target.Value
Else
Target.Comment.Delete
Target.AddComment
Target.Comment.Text Target.Value
End If

End If
End Sub



On Mon, Aug 18, 2014 at 10:42 AM, Vaibhav Joshi v...@vabs.in wrote:

 hi

 I suggest alternate way..

 put this code in ThisWorkbook module..

 You need to double click the cell whose text you want to read  msgbox
 will popup with text in cell.

 Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
 Target As Range, Cancel As Boolean)
 MsgBox Target.Text
 End Sub

 Cheers!!


 On Mon, Aug 18, 2014 at 10:24 AM, Pankaj Kumar pankaj...@gmail.com
 wrote:

 I need VBA code to copy the cell value and paste in comment box for the
 same cell.

 Example: If I select any cell or merged cells which has some text in it
 then code should copy the text and create a comment and paste the same
 text. I need this because when user can't see the entire text because it's
 too long and he can't expand the cell due to certain restriction. Hence,
 the code should ask to select the cell which has some text and it'll simply
 copy the text and paste in comment. Comment box should be expanded enough
 to have entire text visibility.

 Appreciate anyone response quickly.

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

 FORUM RULES

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

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


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

 FORUM RULES

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

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


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

FORUM RULES

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

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

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

[Ravi Kumar]

Hi,


use below or pfa

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value   Then
If Target.Comment Is Nothing Then
Target.AddComment
Target.Comment.Text Target.Value
Else
Target.Comment.Delete
Target.AddComment
Target.Comment.Text Target.Value
End If

End If
End Sub



On Mon, Aug 18, 2014 at 10:42 AM, Vaibhav Joshi v...@vabs.in wrote:

 hi

 I suggest alternate way..

 put this code in ThisWorkbook module..

 You need to double click the cell whose text you want to read  msgbox
 will popup with text in cell.

 Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
 Target As Range, Cancel As Boolean)
 MsgBox Target.Text
 End Sub

 Cheers!!


 On Mon, Aug 18, 2014 at 10:24 AM, Pankaj Kumar pankaj...@gmail.com
 wrote:

 I need VBA code to copy the cell value and paste in comment box for the
 same cell.

 Example: If I select any cell or merged cells which has some text in it
 then code should copy the text and create a comment and paste the same
 text. I need this because when user can't see the entire text because it's
 too long and he can't expand the cell due to certain restriction. Hence,
 the code should ask to select the cell which has some text and it'll simply
 copy the text and paste in comment. Comment box should be expanded enough
 to have entire text visibility.

 Appreciate anyone response quickly.

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

 FORUM RULES

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

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


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

 FORUM RULES

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

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


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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Combining six IF formula into one formula

[Ravi Kumar]

another way

=CHOOSE(MATCH(A1,{red,sta,ida,pco,pid,pde},0),us2,ru2,cu2,us3,ru3,cu3)


On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote:

 Dear all , how to merge following six formula into single formula.
 small formula is required . Thanks

 IF(A1=red,us2,)

 IF(A1=sta,ru2,)

 IF(A1=ida,cu2,)

 IF(A1=pco,us3,)

 IF(A1=pid,ru3,)

 IF(A1=pde,cu3,)

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

 FORUM RULES

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

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


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

FORUM RULES

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

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

RE: $$Excel-Macros$$ How to share Code/Macro ?

[Ravi Kumar]

Check the same link now…

 

http://excelvbasupport.com/forum/showthread.php?tid=8

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Suyog Kulkarni
Sent: Monday, April 28, 2014 2:35 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: Re: $$Excel-Macros$$ How to share Code/Macro ?

 

Ravinder,

Thanks for help, I did all your suggested steps  I've created the Add in. 
I've copied that file to following path. I hope I'm correct.

C:\Program Files\Microsoft Office\Office12\XLSTART 

But still I can't see the same in add-in. Attached is copy of My Menu  My new 
Add in file. Kindly try both. If I just double click My menu that gets 
automatically added into the above folder. Same way I would like to do for new 
add in.

Pl help. 

With Regards,
Suyog 


On Saturday, 26 April 2014 15:06:00 UTC+5:30, ravinder negi wrote:

Pls visit below link for solution

 

http://excelvbasupport.com/forum/showthread.php?tid=8

 

 

From: excel-...@googlegroups.com javascript:  
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of Suyog Kulkarni
Sent: Saturday, April 26, 2014 2:40 PM
To: excel-...@googlegroups.com javascript: 
Subject: $$Excel-Macros$$ How to share Code/Macro ?

 

Hello All,

Kindly refer attached file, I've created macro but I want to share this macro 
to other users. Following are my difficulties.

1. How can I secure the code ? Kindly add password 12345 for this file. 
2. To run the code I need to keep this file open but which I don't want normal 
user to do ? This macro should run automatically on any pc.
3. Can I add Any additional button which would be appear along with the 
exiting toolbar of excel ? so that normal use will only click that button 
without headache ?

Kindly advice me. 

With Regards,
Suyog

-- 
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 javascript: .
To post to this group, send email to excel-...@googlegroups.com javascript: .
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 
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com 
mailto: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

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[Ravi Kumar]

Visit on the below link and check if you are asking for the same


http://excelvbasupport.com/forum/showthread.php?tid=22


Warm Regards,
Ravi Kumar.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of amar takale
Sent: Monday, April 28, 2014 3:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear all excel champs friends
Can any one proper guide on this topic means it uis possible or not?
Regards
Amar

On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote:
 Dear Ashish sir

 Pls help me on this solution.

 I would appreciate very much Sir

 Regards
 Amar Takale

 On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote:
 Dear Expert team

 can anyone give me solution on this topic?

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote:
 Dear Ravinder

 Perfect,You are done it.

 I am really thankful for its wonderful coding.

 I have some other query regarding this issue topic (If you have 
 sufficient time regarding my query)

 Single Excel sheet  more than 2 tables
 1) I will create button  click then automatic table copy paste in 
 word.(First data range fixed of table).there are more than two table 
 with different range.I want all table copy paste in one word file 
 one by one below after one click button.

 Single Excel sheet  one table
 1)  I will create button  click then automatic table copy paste in 
 word.(First data range fixed of table).code not asking for select 
 range.

 As always Thank you all for your help. I greatly appreciated it.

 Regards
 Amar


 On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com 
 wrote:
 Try this file

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 12:22 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Actually it show like Missing: Microsoft Word 14.0 Object Library

 Attached screen shot here

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
 ravinderexcelgr...@gmail.com
 wrote:
 Press alt + F11 then go in tools then reference select  Microsoft 
 Word 14.0 Object Library library number can b 12.0 or else. 
 Please see attached excel file.


 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 10:50 AM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Thanks for reply but how to do it.Pls give me guidance or give 
 modified code.

 Regards
 Amar

 On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi 
 ravindervbacli...@gmail.com
 wrote:
 have u added the library word object library in vba


 On Mon, Mar 31, 2014 at 10:02 PM, amar takale 
 amartak...@gmail.com
 wrote:

 Dear Ravinder

 VBA Code not working.Attached Error Screen shot here.Pls see  
 guide me.I have no knowledge of VBA. In excel there are no show 
 Microsoft Word library  in Tools-reference option but show it 
 as Microsoft Word 11.0 Object library 
 Pls look in this issue.

 Regards
 Amar


 On Mon, Mar 31, 2014 at 5:39 PM, Ravinder 
 ravindervbacli...@gmail.com
 wrote:
  Note:- add word library Microsoft Word library 
 
  This is simply copy and paste value from excel to word and you 
  need to select range (will be asked by program) which you want 
  to transfer in word
 
  Sub Button1_Click()
  Dim wrd As New Word.Application Dim doc As Word.Document Dim 
  RNG As Range Set RNG = Application.InputBox(Please Select 
  Range to Transfer in Word:,
  Type:=8)
 
  Set doc = wrd.documents.Add
  wrd.Visible = True 'if you dont want to show wrd application 
  then just use false instead of true RNG.Copy 
  wrd.Selection.Paste Set tbl = doc.Tables(1)
  doc.SaveAs2 ThisWorkbook.Path  \  ActiveSheet.Name  .doc
  'change save as path as per ur requirement
 
  End Sub
 
  -Original Message-
  From: excel-macros@googlegroups.com 
  [mailto:excel-macros@googlegroups.com]
  On Behalf Of amar takale
  Sent: Monday, March 31, 2014 3:35 PM
  To: excel-macros@googlegroups.com
  Subject: $$Excel-Macros$$ VBA Code to Import Excel table in 
  Word file
 
  Dear Ashish Sir,
 
  I learned many VBA work from your Code which is a lot of time 
  saving  easy to do. Before one week on our excel forum one 
  topic discussed as (Macro to Import Word Tables to Excel from a 
  folder).
  I got code from word to excel but  I required excel to word.I 
  use excel 2003.
 
  Can you share code excel to word table as proper in one sheet 
  with respective sheet name.
 
  I would appreciate very much if you can help me on this.
 
  Regards
 
  --
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[Ravi Kumar]

No need to do anything just comment the two lines

'Dim wrdapps As Word.Application
'Dim wrddoc As Word.Document

It would work


Warm Regards,
Ravi Kumar.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of amar takale
Sent: Monday, April 28, 2014 3:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear Ravi

I found example file in above link forum but there are error show cant find 
project or library.PFA both file.Pls see it

Regards
Amar


On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 Visit on the below link and check if you are asking for the same


 http://excelvbasupport.com/forum/showthread.php?tid=22


 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 3:00 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear all excel champs friends
 Can any one proper guide on this topic means it uis possible or not?
 Regards
 Amar

 On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote:
 Dear Ashish sir

 Pls help me on this solution.

 I would appreciate very much Sir

 Regards
 Amar Takale

 On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote:
 Dear Expert team

 can anyone give me solution on this topic?

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote:
 Dear Ravinder

 Perfect,You are done it.

 I am really thankful for its wonderful coding.

 I have some other query regarding this issue topic (If you have 
 sufficient time regarding my query)

 Single Excel sheet  more than 2 tables
 1) I will create button  click then automatic table copy paste in 
 word.(First data range fixed of table).there are more than two 
 table with different range.I want all table copy paste in one word 
 file one by one below after one click button.

 Single Excel sheet  one table
 1)  I will create button  click then automatic table copy paste in 
 word.(First data range fixed of table).code not asking for select 
 range.

 As always Thank you all for your help. I greatly appreciated it.

 Regards
 Amar


 On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com 
 wrote:
 Try this file

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 12:22 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Actually it show like Missing: Microsoft Word 14.0 Object Library

 Attached screen shot here

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
 ravinderexcelgr...@gmail.com
 wrote:
 Press alt + F11 then go in tools then reference select  
 Microsoft Word 14.0 Object Library library number can b 12.0 or else.
 Please see attached excel file.


 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 10:50 AM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Thanks for reply but how to do it.Pls give me guidance or give 
 modified code.

 Regards
 Amar

 On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi 
 ravindervbacli...@gmail.com
 wrote:
 have u added the library word object library in vba


 On Mon, Mar 31, 2014 at 10:02 PM, amar takale 
 amartak...@gmail.com
 wrote:

 Dear Ravinder

 VBA Code not working.Attached Error Screen shot here.Pls see  
 guide me.I have no knowledge of VBA. In excel there are no show 
 Microsoft Word library  in Tools-reference option but show it 
 as Microsoft Word 11.0 Object library 
 Pls look in this issue.

 Regards
 Amar


 On Mon, Mar 31, 2014 at 5:39 PM, Ravinder 
 ravindervbacli...@gmail.com
 wrote:
  Note:- add word library Microsoft Word library 
 
  This is simply copy and paste value from excel to word and 
  you need to select range (will be asked by program) which you 
  want to transfer in word
 
  Sub Button1_Click()
  Dim wrd As New Word.Application Dim doc As Word.Document Dim 
  RNG As Range Set RNG = Application.InputBox(Please Select 
  Range to Transfer in Word:,
  Type:=8)
 
  Set doc = wrd.documents.Add
  wrd.Visible = True 'if you dont want to show wrd application 
  then just use false instead of true RNG.Copy 
  wrd.Selection.Paste Set tbl = doc.Tables(1)
  doc.SaveAs2 ThisWorkbook.Path  \  ActiveSheet.Name  .doc
  'change save as path as per ur requirement
 
  End Sub
 
  -Original Message-
  From: excel-macros@googlegroups.com 
  [mailto:excel-macros@googlegroups.com]
  On Behalf Of amar takale
  Sent: Monday, March 31

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[Ravi Kumar]

Ok check the below link

http://excelvbasupport.com/forum/showthread.php?tid=23



Warm Regards,
Ravi Kumar.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of amar takale
Sent: Monday, April 28, 2014 4:02 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear Ravi

Sheet not work with modified code Pls send me excel sheet with this modified 
code. (In references show  Missing: Microsoft Word 14.0 Object Library)

Regards
amar

On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 No need to do anything just comment the two lines

 'Dim wrdapps As Word.Application
 'Dim wrddoc As Word.Document

 It would work


 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 3:34 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear Ravi

 I found example file in above link forum but there are error show 
 cant find project or library.PFA both file.Pls see it

 Regards
 Amar


 On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 Visit on the below link and check if you are asking for the same


 http://excelvbasupport.com/forum/showthread.php?tid=22


 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 3:00 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear all excel champs friends
 Can any one proper guide on this topic means it uis possible or not?
 Regards
 Amar

 On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote:
 Dear Ashish sir

 Pls help me on this solution.

 I would appreciate very much Sir

 Regards
 Amar Takale

 On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote:
 Dear Expert team

 can anyone give me solution on this topic?

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote:
 Dear Ravinder

 Perfect,You are done it.

 I am really thankful for its wonderful coding.

 I have some other query regarding this issue topic (If you have 
 sufficient time regarding my query)

 Single Excel sheet  more than 2 tables
 1) I will create button  click then automatic table copy paste in 
 word.(First data range fixed of table).there are more than two 
 table with different range.I want all table copy paste in one word 
 file one by one below after one click button.

 Single Excel sheet  one table
 1)  I will create button  click then automatic table copy paste 
 in word.(First data range fixed of table).code not asking for 
 select range.

 As always Thank you all for your help. I greatly appreciated it.

 Regards
 Amar


 On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com 
 wrote:
 Try this file

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 12:22 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Actually it show like Missing: Microsoft Word 14.0 Object Library

 Attached screen shot here

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
 ravinderexcelgr...@gmail.com
 wrote:
 Press alt + F11 then go in tools then reference select 
 Microsoft Word 14.0 Object Library library number can b 12.0 or else.
 Please see attached excel file.


 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 10:50 AM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Thanks for reply but how to do it.Pls give me guidance or give 
 modified code.

 Regards
 Amar

 On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi 
 ravindervbacli...@gmail.com
 wrote:
 have u added the library word object library in vba


 On Mon, Mar 31, 2014 at 10:02 PM, amar takale 
 amartak...@gmail.com
 wrote:

 Dear Ravinder

 VBA Code not working.Attached Error Screen shot here.Pls see  
 guide me.I have no knowledge of VBA. In excel there are no 
 show Microsoft Word library  in Tools-reference option but 
 show it as Microsoft Word 11.0 Object library 
 Pls look in this issue.

 Regards
 Amar


 On Mon, Mar 31, 2014 at 5:39 PM, Ravinder 
 ravindervbacli...@gmail.com
 wrote:
  Note:- add word library Microsoft Word library 
 
  This is simply copy and paste value from excel to word and 
  you need to select range (will be asked by program) which 
  you want to transfer in word
 
  Sub

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[Ravi Kumar]

Try this


Sub Button1_Click()
Dim wb As Workbook
Dim ws As Worksheet
Dim tbl As ListObject
Dim wrd As Object
Dim doc As Object
Dim sel As Object
Set wb = ThisWorkbook
Set ws = wb.Sheets(1)
Set wrd = CreateObject(word.application)
wrd.Visible = True

Set doc = wrd.Documents.Add

For Each tbl In ws.ListObjects

tbl.Range.Copy
wrd.Selection.Paste
wrd.Selection.TypeParagraph

Next
Application.CutCopyMode = xlCopy
MsgBox Done

End Sub



Warm Regards,
Ravi Kumar.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of amar takale
Sent: Monday, April 28, 2014 4:15 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Same error show cant find project or library

On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 Ok check the below link

 http://excelvbasupport.com/forum/showthread.php?tid=23



 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 4:02 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear Ravi

 Sheet not work with modified code Pls send me excel sheet with this 
 modified code. (In references show  Missing: Microsoft Word 14.0 
 Object Library)

 Regards
 amar

 On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 No need to do anything just comment the two lines

 'Dim wrdapps As Word.Application
 'Dim wrddoc As Word.Document

 It would work


 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 3:34 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear Ravi

 I found example file in above link forum but there are error show 
 cant find project or library.PFA both file.Pls see it

 Regards
 Amar


 On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote:
 Visit on the below link and check if you are asking for the same


 http://excelvbasupport.com/forum/showthread.php?tid=22


 Warm Regards,
 Ravi Kumar.

 -Original Message-
 From: excel-macros@googlegroups.com
 [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale
 Sent: Monday, April 28, 2014 3:00 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
 file

 Dear all excel champs friends
 Can any one proper guide on this topic means it uis possible or not?
 Regards
 Amar

 On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote:
 Dear Ashish sir

 Pls help me on this solution.

 I would appreciate very much Sir

 Regards
 Amar Takale

 On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote:
 Dear Expert team

 can anyone give me solution on this topic?

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote:
 Dear Ravinder

 Perfect,You are done it.

 I am really thankful for its wonderful coding.

 I have some other query regarding this issue topic (If you have 
 sufficient time regarding my query)

 Single Excel sheet  more than 2 tables
 1) I will create button  click then automatic table copy paste 
 in word.(First data range fixed of table).there are more than two 
 table with different range.I want all table copy paste in one 
 word file one by one below after one click button.

 Single Excel sheet  one table
 1)  I will create button  click then automatic table copy paste 
 in word.(First data range fixed of table).code not asking for 
 select range.

 As always Thank you all for your help. I greatly appreciated it.

 Regards
 Amar


 On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com 
 wrote:
 Try this file

 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 12:22 PM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Actually it show like Missing: Microsoft Word 14.0 Object Library

 Attached screen shot here

 Regards
 Amar

 On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
 ravinderexcelgr...@gmail.com
 wrote:
 Press alt + F11 then go in tools then reference select 
 Microsoft Word 14.0 Object Library library number can b 12.0 or else.
 Please see attached excel file.


 -Original Message-
 From: excel-macros@googlegroups.com 
 [mailto:excel-macros@googlegroups.com]
 On Behalf Of amar takale
 Sent: Wednesday, April 02, 2014 10:50 AM
 To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in 
 Word file

 Dear Ravinder

 Thanks for reply but how

Re: FW: $$Excel-Macros$$ Count help

[Ravi Kumar]

There is some update as last output is not correct



On Thu, Mar 20, 2014 at 8:38 AM, AK exce...@gmail.com wrote:

 Thanks alot Raviinder!


 On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei 
 ravindervbacli...@gmail.com wrote:

  pfa



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *AK
 *Sent:* Wednesday, March 19, 2014 8:15 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Count help



 Hi All,



 I need to count the non-blank cell from the latest month (Cell M1 -- Feb
 2014) to last blank cell and ignoring rest of the previous values.

 countblank or CountA formula is not working as they are counting all the
 cells in the range.



 For example 1: If I need to update cell N2 the value should be 2, as
 there are 2 non-blank cells from the Feb 2014 (Feb 14 and Jan 14) and
 ignoring rest of the prior values in the range (B2 : M2)



 For example 2. If I need to update cell N3 the value should be 5, as
 there are 5 non-blank cells from the Feb 2014 (Feb 14 to Oct 13) and
 ignoring rest of the prior values in the range (b3 : M3)



 Please let me know the solution.


 --
 Regards,

 AK

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




 --
 Regards,

 AK

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

RE: $$Excel-Macros$$ Save as PDF for 2003

[Ravi Kumar]

Hi,

 

 

Try this.

Sub saveasPDFE()

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF,
Filename:=ActiveWorkbook.Path  \Filename.PDF

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pavan Valluru
Sent: Wednesday, November 13, 2013 12:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Save as PDF for 2003

 

Can anyone has code to Save as PDF for excel 2003? If yes, please shares.

 

-Pavan

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Save as PDF for 2003

[Ravi Kumar]

K download primopdf or nitropdf software or any pdf machine software

 

Then u can convert excel into pdf

 

By using  activesheet.printout or by pressing : ctrl+P

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pavan Valluru
Sent: Wednesday, November 13, 2013 12:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Save as PDF for 2003

 

Dear Ravi,

 

The below code doesnt work in 2003.

 

-Pavan

On Wednesday, 13 November 2013 12:09:39 UTC+5:30, Ravi Kumar wrote:

Hi,

 

 

Try this.

Sub saveasPDFE()

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF,
Filename:=ActiveWorkbook.Path  \Filename.PDF

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com javascript:
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of Pavan
Valluru
Sent: Wednesday, November 13, 2013 12:05 PM
To: excel-...@googlegroups.com javascript: 
Subject: $$Excel-Macros$$ Save as PDF for 2003

 

Can anyone has code to Save as PDF for excel 2003? If yes, please shares.

 

-Pavan

-- 
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 javascript: .
To post to this group, send email to excel-...@googlegroups.com
javascript: .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Formula Error

[Ravi Kumar]

 

 

Is this what u r looking for?

 

PFA solution.

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 4:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula Error

 

Thanks Ravi sir, Actually still my requirement is not yet fulfill. Please
find the attachment, i did manually in the attached excel. 

Thanks for the help. 




 

 

With warm regards,

Rajan Sharma

 

 

On Mon, Nov 11, 2013 at 3:59 PM, Ravinder ravinderexcelgr...@gmail.com
mailto:ravinderexcelgr...@gmail.com  wrote:

pfa

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
] On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Formula Error

 

Dear experts,

  I have wrote formula in the attached file, but throwing error.  Please
modify the formula and where i am wrong. 

Thanks in advance.  


 

 

With warm regards,

Rajan Sharma

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

 

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

$$Excel-Macros$$ RE: [XL-VBA Clinic] Happy Diwali.

[Ravi Kumar]

 

HAPPY DHANTERAS 

 

HAPPY DIWALI TO ALL IN ADVANCE

 

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of Ravinder
Sent: Friday, November 01, 2013 12:25 PM
To: excelvbacli...@googlegroups.com
Cc: excel-macros@googlegroups.com; Soum
Subject: RE: [XL-VBA Clinic] Happy Diwali.

 

HAPPY DIWALI TO ALL FRIENDS..

 

From: excelvbacli...@googlegroups.com
mailto:excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of Dharmendra Upadhyay
Sent: Friday, November 01, 2013 11:06 AM
To: excelvbacli...@googlegroups.com mailto:excelvbacli...@googlegroups.com

Subject: Re: [XL-VBA Clinic] Happy Diwali.

 

Same to u  your family

On Nov 1, 2013 10:23 AM, Kuldeep Upadhyay kuldeep95...@gmail.com
mailto:kuldeep95...@gmail.com  wrote:

Dear all happy Dhanteras  Diwali.

-- 

--
To post to this group, send email: 
excelvbacli...@googlegroups.com mailto:excelvbacli...@googlegroups.com 
To unsubscribe from this group, send email
excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic%2bunsubscr...@googlegroups.com 
 
For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
Excelvbaclinic group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic%2bunsubscr...@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.

-- 

--
To post to this group, send email: 
excelvbacli...@googlegroups.com mailto:excelvbacli...@googlegroups.com 
To unsubscribe from this group, send email
excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic+unsubscr...@googlegroups.com 
 
For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
Excelvbaclinic group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic+unsubscr...@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.

-- 

--
To post to this group, send email: 
excelvbacli...@googlegroups.com mailto:excelvbacli...@googlegroups.com 
To unsubscribe from this group, send email
excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic+unsubscr...@googlegroups.com 
 
For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
Excelvbaclinic group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com
mailto:excelvbaclinic+unsubscr...@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Counting Nos formula

[Ravi Kumar]

Use this for equal

=SUMPRODUCT((F9=$A$2:$A$241)*(F9=$B$2:$B$241))

And use this for not equal

=SUMPRODUCT((F9=$A$2:$A$241)*(F9$B$2:$B$241))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent: Monday, October 21, 2013 2:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Counting Nos formula

 

Hi Team,

 

need your help to get nos by using formula. I know how to get details
through pivot table but wanted to know formula also. Pls help.

 

Rgds,

Prabhakar

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code

[Ravi Kumar]

Very nice negi ji

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, October 10, 2013 5:45 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code

 

pfa

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dr
Sent: Thursday, October 10, 2013 5:29 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Display Vlookup dialog box with vba code

 

Hi,

 

Does anyone know how to display the vlookup dialog box using vba?

 

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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Email Trigger ?

[Ravi Kumar]

Do u have any sample data, then plz provide

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Monday, October 07, 2013 2:59 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Email Trigger ?

 

Ok thanks..

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of De Premor
Sent: Monday, October 07, 2013 2:55 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Email Trigger ?

 

I think he want to check after data refreshed

I have a dynamic spreadsheet that monitors different stock prices that
is refreshed ever x amount of minutes.

On 07-10-2013 16:23, Ravinder wrote:

U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Email Trigger ?

 

Hi, 

 

I am using Excel 2007 and have Gmail as my primary email account.

 

I have a dynamic spreadsheet that monitors different stock prices that is
refreshed ever x amount of minutes.

 

I would like to have a small macro created so that when a certain cell is
either = to a certain price, will automatically send me an email to my
Gmail account with the message to be defined later.

 

Anyone ? 

 

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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material

RE: $$Excel-Macros$$ Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

[Ravi Kumar]

K try this one.

 

 

 

Sub Sendmail1()

 

ESubject = This is a test email

SendTo = raviku...@gmail.com

CCTo = 

Ebody = Testing VBA's ability to send an email.

NewFileName = C:\Users\Admin\Desktop\t\test.jpg 'change according to your
image

Application.DisplayAlerts = False

Set App = CreateObject(Outlook.Application)

Set Itm = App.CreateItem(0)

With Itm

.Subject = ESubject

 

.To = SendTo

.CC = CCTo

.Body = Ebody

.Attachments.Add (NewFileName)

.send

End With

Set App = Nothing

Set Itm = Nothing

 

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Trabelsi Hichem
Sent: Thursday, September 26, 2013 12:33 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Outlook 2010 : VBA Macro for sending image in HTML
Body doesn't display correctly

 

Hello,

 

I Use the following code to send emails automatically with embedded image in
the HTML body, this worked with Office 2003, but when i upgrated to Office
2010 it doesnt work anymore, the image doesnt appear correctly :

 

this is the code i'm using :

 

.

.

.

FileName = C:\Submission Reminder.gif

 

Set ol = CreateObject(outlook.application)

 

Set monmail = ol.CreateItem(olMailItem)

 

monmail.Recipients.Add (email)

 

monmail.Subject = Replicon : Timesheet Submission Reminder

 

monmail.htmlBody = img src= 'cid:Submission Reminder.gif'

 

monmail.Attachments.Add FileName

 

monmail.send

 

Set ol = Nothing

 

Set monmail = Nothing

 

 

I didnt find any solution which works on office 2010 on all vba forums,
could you please help me ?

 

Thank you so much :)

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

[Ravi Kumar]

 

Ok, I’ll try.

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Trabelsi Hichem
Sent: Thursday, September 26, 2013 12:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in
HTML Body doesn't display correctly

 

Hello Again, 

 

Thank you Ravi for your quick answer , but the instruction here  .Body =
Ebody  will show in the body the string   Testing VBA's ability to send an
email., i want the attached image to be displayed normally in the body
that's the problem, it worked before on Office 2003 but not anymore with the
office 2010, receivers see the image in the body like a red cross

 

Thank you




--



Le jeudi 26 septembre 2013 08:03:18 UTC+1, Trabelsi Hichem a écrit :

Hello,

 

I Use the following code to send emails automatically with embedded image in
the HTML body, this worked with Office 2003, but when i upgrated to Office
2010 it doesnt work anymore, the image doesnt appear correctly for the
receivers who have too outlook 2010 :

 

this is the code i'm using :

 

.

.

.

FileName = C:\Submission Reminder.gif

 

Set ol = CreateObject(outlook.application)

 

Set monmail = ol.CreateItem(olMailItem)

 

monmail.Recipients.Add (email)

 

monmail.Subject = Replicon : Timesheet Submission Reminder

 

monmail.htmlBody = img src= 'cid:Submission Reminder.gif'

 

monmail.Attachments.Add FileName

 

monmail.send

 

Set ol = Nothing

 

Set monmail = Nothing

 

 

I didnt find any solution which works on office 2010 on all vba forums,
could you please help me ?

 

Thank you so much :)

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

$$Excel-Macros$$ RE: [XL-VBA Clinic] Pls convert time to given format

[Ravi Kumar]

Simply use

=TEXT(A2,hhmm)



Warm Regards,
Ravi Kumar.

-Original Message-
From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of  ??  
Sent: Wednesday, September 25, 2013 12:44 PM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com;
excel-vba-h...@googlegroups.com; rajan verma; Deepak Singh
Subject: [XL-VBA Clinic] Pls convert time to given format

 Dear Friends,

i have to convert the time to given format .  format is as follows.

Time Output
08:590859
17:001700
15:30 1530
17:05 so on.
13:12
00:00
08:57
17:15
08:55
17:10

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

-- 

--
To post to this group, send email: 
   excelvbacli...@googlegroups.com
To unsubscribe from this group, send email
   excelvbaclinic+unsubscr...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
Excelvbaclinic group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ for due date

[Ravi Kumar]

Hi,

 

Another way. See the attached file.

 

 

=DATE(YEAR(D5),MONTH(D5),DAY(D5)+15)

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, September 25, 2013 4:31 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ for due date

 

PFA

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of sridher sharma
Sent: Wednesday, September 25, 2013 3:58 PM
To: excel-macros
Subject: $$Excel-Macros$$ for due date

 

i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013 is  1st day and due date is 14/05/2013) how to fined next due
DATE

NEED FORMULA 

 

 

THANX

Regards 

Sridher Sharma 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

FORUM RULES

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

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


Copy of DUE DATE (2).xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

[Ravi Kumar]

Store the value in any array or collection and then paste it to ie textbox

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Tuesday, September 24, 2013 3:01 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

Not able to access website and not getting how its working.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Menaka
Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ How to paste all the values in the text field of a
web page

 


Hi,

with the followong code I can able to paste the all the values from the
excel sheet to the webpage.But if while pasting the second value the first
value is getting replaced. So finally I can paste only the last cell value.
I want all the range of values to be entered in the text filed. Please help
me in resloving this.


[code]

Sub GetTable()

   

Dim ieApp As InternetExplorer

'Dim ieDoc As Object

Dim ie As Object

Dim ieTable As Object



Dim finalrow As Variant

 

Range(A1).Activate

colno = ActiveCell.Column

MsgBox (colno)

Range(A1).Select

finalrow = Cells(Rows.Count, 1).End(xlUp).Row

MsgBox (finalrow)



'create a new instance of ie







'Set ieApp = CreateObject(InternetExplorer.application)

Set ie = CreateObject(InternetExplorer.application)

ie.Visible = True

ie.navigate http://abcde.com;

Do

Loop Until ie.readyState = READYSTATE_COMPLETE

Application.Wait DateAdd(s, 3, Now)

While ie.Busy

DoEvents

Wend

 

For i = 2 To finalrow

' abcde is element id, if you forget then read the step number 2 again

ie.document.getelementbyid(Email).Value = Cells(i, colno).Value

Application.Wait (Now + TimeValue(0:00:10))

'MsgBox Time expired

Next


[/code]

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

FORUM RULES

1) Use concise

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

[Ravi Kumar]

Hi,

 

One example to combined range. Change your range, ie.navigate and element id
also

 

Sub testin()

Dim ie As Object

 

dataarr = Range(A2:A4) 'Change according to your criteria

For i = 1 To UBound(dataarr, 1)

If counter = 0 Then

store_value = dataarr(i, 1)

counter = 1

Else

store_value = store_value  ,  dataarr(i, 1)

End If

Next

MsgBox store_value

 

Set ie = CreateObject(internetexplorer.application)

ie.Visible = True

ie.navigate2 www.google.com http://www.google.com ''Change according
to your criteria

While ie.Busy Or ie.readyState = readystate_completed

DoEvents

Wend

 

ie.document.getelementbyid(gbqfq).Value = store_value'Change element
id according to your criteria

 

 

End Sub

 

 

Note : Change the highlighted place according to your criteria

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 5:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

can you please say how to store in array or collection


On Tuesday, September 24, 2013 3:23:26 PM UTC+5:30, Ravi Kumar wrote:

Store the value in any array or collection and then paste it to ie textbox

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com javascript:
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of Ravinder
Sent: Tuesday, September 24, 2013 3:01 PM
To: excel-...@googlegroups.com javascript: 
Cc: Soum
Subject: RE: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

Not able to access website and not getting how its working.

 

From: excel-...@googlegroups.com javascript:
[mailto:ex...@googlegroups.com javascript: ] On Behalf Of Menaka
Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-...@googlegroups.com javascript: 
Subject: $$Excel-Macros$$ How to paste all the values in the text field of a
web page

 


Hi,

with the followong code I can able to paste the all the values from the
excel sheet to the webpage.But if while pasting the second value the first
value is getting replaced. So finally I can paste only the last cell value.
I want all the range of values to be entered in the text filed. Please help
me in resloving this.


[code]

Sub GetTable()

   

Dim ieApp As InternetExplorer

'Dim ieDoc As Object

Dim ie As Object

Dim ieTable As Object



Dim finalrow As Variant

 

Range(A1).Activate

colno = ActiveCell.Column

MsgBox (colno)

Range(A1).Select

finalrow = Cells(Rows.Count, 1).End(xlUp).Row

MsgBox (finalrow)



'create a new instance of ie







'Set ieApp = CreateObject(InternetExplorer.application)

Set ie = CreateObject(InternetExplorer.application)

ie.Visible = True

ie.navigate http://abcde.com;

Do

Loop Until ie.readyState = READYSTATE_COMPLETE

Application.Wait DateAdd(s, 3, Now)

While ie.Busy

DoEvents

Wend

 

For i = 2 To finalrow

' abcde is element id, if you forget then read the step number 2 again

ie.document.getelementbyid(Email).Value = Cells(i, colno).Value

Application.Wait (Now + TimeValue(0:00:10))

'MsgBox Time expired

Next


[/code]

-- 
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 javascript: .
To post to this group, send email to excel-...@googlegroups.com
javascript: .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick

RE: $$Excel-Macros$$ How to split Alphabetic Numeric data in different cells....

[Ravi Kumar]

U can use UDF

 

'For Character

Function gettext(refc As Variant)

For i = 1 To Len(refc)

If Mid(refc, i, 1) Like [a-zA-Z] Then

temp = temp  Mid(refc, i, 1)

End If

Next

gettext = temp

 

End Function

---

'For numbers

Function getnum(refc1 As Variant)

For i = 1 To Len(refc1)

If Mid(refc1, i, 1) Like [0-9] Then

temp = temp  Mid(refc1, i, 1)

End If

Next

getnum = temp

 

End Function

 

 

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, September 25, 2013 10:38 AM
To: excel-macros@googlegroups.com
Cc: Soum; Soum
Subject: RE: $$Excel-Macros$$ How to split Alphabetic  Numeric data in
different cells

 

Try this one..for getting number and character and u can use UDF given by
Ravi for get character

 

From: Ravinder [mailto:ravinderexcelgr...@gmail.com] 
Sent: Tuesday, September 24, 2013 10:02 AM
To: 'excel-macros@googlegroups.com'
Cc: Soum (quote.ex...@gmail.com mailto:quote.ex...@gmail.com )
Subject: RE: $$Excel-Macros$$ How to split Alphabetic  Numeric data in
different cells

 

PFA

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul
Sent: Monday, September 23, 2013 9:47 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ How to split Alphabetic  Numeric data in
different cells

 

=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))-1)

=RIGHT(A1,LEN(A1)-LEN(E1))

 

see if it helps

 

On Mon, Sep 23, 2013 at 8:52 PM, Dhananjay Pinjan dppin...@gmail.com
mailto:dppin...@gmail.com  wrote:

Dear Friends,

 

Assume that following values are in A1,A2, A3 . Column.

 

I want to split the Alphabetic Name in B1, B2.. Column  Numbers in C
Column. Pl. help.


 


Alphanumeric Data

Expected Answer


A Column

B Column

C Column


Dhananjay420

Dhananjay

420


Ramesh007

Ramesh

7


Prashant786

Prashant

786


Chandrakant100

Chandrakant

100

 


Regards,

Dhananjay




-- 
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
mailto:excel-macros%2bunsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.





 

-- 

Regards

 

Ashish Koul

 

 

Visit

My Excel Blog http://www.excelvbamacros.com/ 

Like Us on Facebook
http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 

Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 

 

 

P Before printing, think about the environment.

 

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

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

[Ravi Kumar]

Welcome Menaka

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Wednesday, September 25, 2013 11:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

Thank you Ravi, its working fine :)

 

 


On Tuesday, September 24, 2013 5:48:00 PM UTC+5:30, Ravi Kumar wrote:

Hi,

 

One example to combined range. Change your range, ie.navigate and element id
also

 

Sub testin()

Dim ie As Object

 

dataarr = Range(A2:A4) 'Change according to your criteria

For i = 1 To UBound(dataarr, 1)

If counter = 0 Then

store_value = dataarr(i, 1)

counter = 1

Else

store_value = store_value  ,  dataarr(i, 1)

End If

Next

MsgBox store_value

 

Set ie = CreateObject(internetexplorer.application)

ie.Visible = True

ie.navigate2 www.google.com http://www.google.com ''Change according
to your criteria

While ie.Busy Or ie.readyState = readystate_completed

DoEvents

Wend

 

ie.document.getelementbyid(gbqfq).Value = store_value'Change element
id according to your criteria

 

 

End Sub

 

 

Note : Change the highlighted place according to your criteria

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com javascript:
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of Menaka
Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 5:18 PM
To: excel-...@googlegroups.com javascript: 
Subject: Re: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

can you please say how to store in array or collection


On Tuesday, September 24, 2013 3:23:26 PM UTC+5:30, Ravi Kumar wrote:

Store the value in any array or collection and then paste it to ie textbox

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com mailto:excel-...@googlegroups.com
[mailto:excel-...@googlegroups.com] On Behalf Of Ravinder
Sent: Tuesday, September 24, 2013 3:01 PM
To: excel-...@googlegroups.com mailto:excel-...@googlegroups.com 
Cc: Soum
Subject: RE: $$Excel-Macros$$ How to paste all the values in the text field
of a web page

 

Not able to access website and not getting how its working.

 

From: excel-...@googlegroups.com mailto:excel-...@googlegroups.com
[mailto:ex...@googlegroups.com] On Behalf Of Menaka Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-...@googlegroups.com mailto:excel-...@googlegroups.com 
Subject: $$Excel-Macros$$ How to paste all the values in the text field of a
web page

 


Hi,

with the followong code I can able to paste the all the values from the
excel sheet to the webpage.But if while pasting the second value the first
value is getting replaced. So finally I can paste only the last cell value.
I want all the range of values to be entered in the text filed. Please help
me in resloving this.


[code]

Sub GetTable()

   

Dim ieApp As InternetExplorer

'Dim ieDoc As Object

Dim ie As Object

Dim ieTable As Object



Dim finalrow As Variant

 

Range(A1).Activate

colno = ActiveCell.Column

MsgBox (colno)

Range(A1).Select

finalrow = Cells(Rows.Count, 1).End(xlUp).Row

MsgBox (finalrow)



'create a new instance of ie







'Set ieApp = CreateObject(InternetExplorer.application)

Set ie = CreateObject(InternetExplorer.application)

ie.Visible = True

ie.navigate http://abcde.com;

Do

Loop Until ie.readyState = READYSTATE_COMPLETE

Application.Wait DateAdd(s, 3, Now)

While ie.Busy

DoEvents

Wend

 

For i = 2 To finalrow

' abcde is element id, if you forget then read the step number 2 again

ie.document.getelementbyid(Email).Value = Cells(i, colno).Value

Application.Wait (Now + TimeValue(0:00:10))

'MsgBox Time expired

Next


[/code]

-- 
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
mailto:excel-macros...@googlegroups.com

Re: $$Excel-Macros$$ TESTMAIL

[Ravi Kumar]

test mail


On Fri, Sep 20, 2013 at 5:58 PM, Ravinder ravindervbacli...@gmail.comwrote:

 ** **

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

 FORUM RULES

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

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


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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Formula: Count

[Ravi Kumar]

Hi,

 

 

Another way!!

 

=SUM((E$1=$B$2:$B$10)*($C2=$A$2:$A$10))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anoop K Sharma
Sent: Wednesday, September 18, 2013 10:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula: Count

 

Check the Attachment...

 

On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com
mailto:koul.ash...@gmail.com  wrote:

xy1? what does this mean  do you want to count RS with point 1 and so on

 

Regards

Ashish

 

On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar
chandrashekarb@gmail.com mailto:chandrashekarb@gmail.com  wrote:

Hello,

 

I need formula to count no of points based on condtion please find attached
file.

 

Thanks,

 

Chandra

-- 
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
mailto:excel-macros%2bunsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.





 

-- 

Regards

 

Ashish Koul

 

 

Visit

My Excel Blog http://www.excelvbamacros.com/ 

Like Us on Facebook
http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 

Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 

 

 

P Before printing, think about the environment.

 

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




-- 

Regards,
Anoop
Sr. Developer

Facebook ID - https://www.facebook.com/anooop.k.sharma

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel

RE: $$Excel-Macros$$ SumProduct

[Ravi Kumar]

Ur welcome

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Monday, September 16, 2013 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ SumProduct

 

Hello,

 

Thanks its working fine..

On Fri, Sep 13, 2013 at 4:28 PM, Ravi Kumar excellearn2...@gmail.com
mailto:excellearn2...@gmail.com  wrote:

Hi,

 

Try this..

 

=SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
] On Behalf Of Chandra Shekar
Sent: Friday, September 13, 2013 4:21 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ SumProduct

 

Hi,

 

I have a problem with Sumproduct function please find attached file for the
same where from E1, F1  G1 are condtions based on it I need sum up Column
D.

 

Thanks in advance.

 

Regards,

 

Chandra

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

 

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

RE: $$Excel-Macros$$ SumProduct

[Ravi Kumar]

Hi,

 

Try this..

 

=SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13))

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Friday, September 13, 2013 4:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SumProduct

 

Hi,

 

I have a problem with Sumproduct function please find attached file for the
same where from E1, F1  G1 are condtions based on it I need sum up Column
D.

 

Thanks in advance.

 

Regards,

 

Chandra

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Query on vlookup

[Ravi Kumar]

Another way

 

G3 is lookup_value

 

=OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH(total,A2:F2,0)-1)

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of De Premor
Sent: Saturday, September 14, 2013 10:03 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query on vlookup

 

Try this formula

=VLOOKUP(H3,A3:G13,MATCH(TOTAL,$A$2:$G$2,0),0)

On 14-09-2013 11:28, Shrinivas Shevde wrote:

Dear All

Query on vlookup

Please look at the attached sheet.

 

Thanks in advance

-- 
Shrini 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

 

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

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File Get Max voucher Number

[Ravi Kumar]

 

Negi ji, He's saying that he have DBF table.

 

Use the below command hope you already know this and then you can manipulate
the data through excel easily otherwise plz share your dbf table with us

 

Copy to C:\Users\Admin\Desktop\DBFfolder\dbftable.dbf
C:\Users\Admin\Desktop\DBFfolder\excelfile.xls type xls

 

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder
Sent: Wednesday, September 11, 2013 3:56 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required : How i import Data in Excel
from DBF File  Get Max voucher Number

 

Use below formula or attached file.may be u r looking for this..

 

=IF(A2=,,MONTH(A2)000SUM((MONTH($A$2:A2)=MONTH(A2))*1))

 

From:  mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com
[ mailto:excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To:  mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required : How i import Data in Excel from
DBF File  Get Max voucher Number

 

Dear All,

 

I have a DBF Table containing Vouchers Month wise like 

70001 (Dated : 05-July-13)
70002 (Dated : 08-July-13)
80001 (Dated : 02-August-13)

 

Now i want to get New voucher # by month wise


 

like :

New # 70003 dated 15-July-13
or New # 80002 dated 18-Aug-13

 

Kindly Help me in this regards

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners

RE: $$Excel-Macros$$ Macro needed to add worksheet

[Ravi Kumar]

No dear,

 

Point 1)

Workbooks(primewb).Sheets(sample).Range(A4:c22).Copy
Destination:=Workbooks(Mid(fil.Name, 1, _

WorksheetFunction.Find(., fil.Name) -
1)).Sheets(Sheets.Count).Range(A1)

 

Point 2)

Workbooks(primewb).Sheets(sample).Range(A4:c22).Copy
Destination:=Workbooks(Mid(fil.Name, 1,  WorksheetFunction.Find(.,
fil.Name) - 1)).Sheets(Sheets.Count).Range(A1)

 

Above code is like in single line you can say. When we use _ it will
continue our current line with next new line. You can see above number 1 and
2 point both are same

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SG
Sent: Wednesday, September 11, 2013 5:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro needed to add worksheet

 

Hi Ravi,

 

i think the below code is incomplete.please correct me if i'm wrong.

 

 Workbooks(primewb).Sheets(sample).Range(A4:c22).Copy
Destination:=Workbooks(Mid(fil.Name, 1, _


On Tuesday, September 10, 2013 2:54:19 PM UTC+5:30, Ravi Kumar wrote:

Try this and change you folder name accordingly .

 

 

Sub copy_sheet()

 

Application.ScreenUpdating = False

Application.DisplayAlerts = False

 

 

primewb = ActiveWorkbook.Name

 

Dim fld As Object, fil As Object, fso As Object

Dim wkb As Workbook

 

 

Set fso = CreateObject(scripting.filesystemobject)

Set fld = fso.getfolder(C:\Users\Admin\Desktop\Some VBA Tricks) ' folder
having files

 

 

For Each fil In fld.Files

Set wkb = Workbooks.Open(fil.Path)

Sheets.Add after:=Sheets(Sheets.Count)

Workbooks(primewb).Sheets(sample).Range(A4:c22).Copy
Destination:=Workbooks(Mid(fil.Name, 1, _

WorksheetFunction.Find(., fil.Name) -
1)).Sheets(Sheets.Count).Range(A1)

wkb.Save

wkb.Close

Set wkb = Nothing

Next

 

Application.ScreenUpdating = True

Application.DisplayAlerts = True

 

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com javascript:
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of SG
Sent: Tuesday, September 10, 2013 2:36 PM
To: excel-...@googlegroups.com javascript: 
Subject: Re: $$Excel-Macros$$ Macro needed to add worksheet

 

Thanks for the help but it's not adding my sheet in rest of the workbooks.
i have attached that single sheet  added the macro in it.Please suggest
Where i'm going wrong.


On Monday, September 9, 2013 8:16:20 PM UTC+5:30, ashish wrote:

 

Sub copy_sheet()

 

Application.ScreenUpdating = False

Application.DisplayAlerts = False

 

 

Dim fld As Object, fil As Object, fso As Object

Dim wkb As Workbook

 

Set fso = CreateObject(scripting.filesystemobject)

Set fld = fso.getfolder(C:\Users\admin\Desktop\test) ' folder having files

 

For Each fil In fld.Files

Set wkb = Workbooks.Open(fil.Path)

ThisWorkbook.Sheets(sample).Copy After:=wkb.Sheets(wkb.Sheets.Count)

wkb.Save

wkb.Close

Set wkb = Nothing

Next

 

Application.ScreenUpdating = True

Application.DisplayAlerts = True

 

 

 

End Sub

 

 

see if it helps

 

 

On Mon, Sep 9, 2013 at 7:45 PM, SG sona...@gmail.com
mailto:sona...@gmail.com  wrote:

Hi Experts,

Once again I neeed your help.I have one excel worksheet which is common for
all workbooks. However, that worksheet is not added in the workbooks. I have
atleast 50 excel workbooks in a folder in which i have to add that single
worksheet manually.The name of all worbooks are same only the week number is
different in filenames like report wk-1,report wk-2  so on.Please help me
with a macro which would add that single sheet in all workbooks of that
folder one by one.

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...@googlegroups.com
mailto:excel-macros...@googlegroups.com .
To post to this group, send email to excel-...@googlegroups.com
mailto:excel-...@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.





 

-- 

Regards

 

Ashish

RE: $$Excel-Macros$$ Macro needed to add worksheet

[Ravi Kumar]

Try this and change you folder name accordingly .

 

 

Sub copy_sheet()

 

Application.ScreenUpdating = False

Application.DisplayAlerts = False

 

 

primewb = ActiveWorkbook.Name

 

Dim fld As Object, fil As Object, fso As Object

Dim wkb As Workbook

 

 

Set fso = CreateObject(scripting.filesystemobject)

Set fld = fso.getfolder(C:\Users\Admin\Desktop\Some VBA Tricks) ' folder
having files

 

 

For Each fil In fld.Files

Set wkb = Workbooks.Open(fil.Path)

Sheets.Add after:=Sheets(Sheets.Count)

Workbooks(primewb).Sheets(sample).Range(A4:c22).Copy
Destination:=Workbooks(Mid(fil.Name, 1, _

WorksheetFunction.Find(., fil.Name) -
1)).Sheets(Sheets.Count).Range(A1)

wkb.Save

wkb.Close

Set wkb = Nothing

Next

 

Application.ScreenUpdating = True

Application.DisplayAlerts = True

 

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SG
Sent: Tuesday, September 10, 2013 2:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro needed to add worksheet

 

Thanks for the help but it's not adding my sheet in rest of the workbooks.
i have attached that single sheet  added the macro in it.Please suggest
Where i'm going wrong.


On Monday, September 9, 2013 8:16:20 PM UTC+5:30, ashish wrote:

 

Sub copy_sheet()

 

Application.ScreenUpdating = False

Application.DisplayAlerts = False

 

 

Dim fld As Object, fil As Object, fso As Object

Dim wkb As Workbook

 

Set fso = CreateObject(scripting.filesystemobject)

Set fld = fso.getfolder(C:\Users\admin\Desktop\test) ' folder having files

 

For Each fil In fld.Files

Set wkb = Workbooks.Open(fil.Path)

ThisWorkbook.Sheets(sample).Copy After:=wkb.Sheets(wkb.Sheets.Count)

wkb.Save

wkb.Close

Set wkb = Nothing

Next

 

Application.ScreenUpdating = True

Application.DisplayAlerts = True

 

 

 

End Sub

 

 

see if it helps

 

 

On Mon, Sep 9, 2013 at 7:45 PM, SG sona...@gmail.com javascript:  wrote:

Hi Experts,

Once again I neeed your help.I have one excel worksheet which is common for
all workbooks. However, that worksheet is not added in the workbooks. I have
atleast 50 excel workbooks in a folder in which i have to add that single
worksheet manually.The name of all worbooks are same only the week number is
different in filenames like report wk-1,report wk-2  so on.Please help me
with a macro which would add that single sheet in all workbooks of that
folder one by one.

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...@googlegroups.com javascript: .
To post to this group, send email to excel-...@googlegroups.com
javascript: .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.





 

-- 

Regards

 

Ashish Koul

 

 

Visit

My Excel Blog http://www.excelvbamacros.com/ 

Like Us on Facebook
http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 

Join Us on Facebook http://www.facebook.com/groups/163491717053198/ 

 

 

P Before printing, think about the environment.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
MS

RE: $$Excel-Macros$$ EX-QUERY

[Ravi Kumar]

Did u try this formula.

 

 

Principle(1+rate/100)^month

 

Like 

 

500(1+5/100)^5

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Monday, September 09, 2013 4:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ EX-QUERY

 

Dear member plz help me

 

I am calculating compound interest on loan over a period where interest is
compounded either Monthly, Quarterly, Semi- Annually and Annually.

But it is stands valid in case of Non- leap years. Please give me a formulae
for leap years.

 

Regards,

SRIDHER SHARMA

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Urgent- Query on lookup

[Ravi Kumar]

Hi,

 

Try this..

 

 

Sub lookupconfirm()

Range(F3).Formula = =IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)0,OK),Not
OK)

Range(F3).Copy

Range(F3:F  Cells(Rows.Count, 5).End(xlUp).Row).Select

ActiveSheet.Paste

Application.CutCopyMode = False

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashwani agnihotri
Sent: Friday, September 06, 2013 11:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent- Query on lookup

 

Hi,

I have a query. I have two table named original and other. 

Now I want to look up for ID,s and check for mismatch in the status in both
table.

For ex-

If 121 is there in lookup table with status ok but the status of 121 in
original table is active I should be able to detect the mismatch

I am looking for a formula but VBA code for this will be much appreciated.

Plz find an excel as attachment

Regards,

Ashwani

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Macro for Hide Column

[Ravi Kumar]

HI,

 

You can try this..

 

 

Sub Hidecol()

Set Rng = Range(A2:E2)

 

For Each r In Rng

If UCase(r.Value) = YES Then

r.EntireColumn.Hidden = True

End If

Next

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Saturday, September 07, 2013 9:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro for Hide Column

 

Dear All,

Very Good Morning

 

I have one Query . 

 i am looking in Range (A2:E2) . If cell contain  yes word then don't
hide otherwise hide the column .

 

for example

if in A2 Cell word is Yes , i am Fine then A column must be hide

if D2 cell contain Prafull ,Yes is is fine then D column must be hide

 

if cell does not contain yes word then don't hide that column

 

Regards,

Prafull

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Activate Particular Window

[Ravi Kumar]

Dear John,

 

 

Would u share any screen shot or excel file with us. 

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of John Wilson
Sent: Saturday, September 07, 2013 8:01 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Activate Particular Window

 

I'm in the process of upgrading / rewriting a business application in Excel
that I started years ago.

It's shared on our network and people with Versions 8 through 15 are using
it (now you get an

idea of my headache).

One issue (actually quite a number but just this one for now) and it seems
to be version 15 only.

I have a userform.

When it opens, 3 other workbooks open, it gets data from them and displays
it on the userform.

I leave those files open so that they don't have to be reopened if the user
changes search criteria

until the userform is closed (and the 3 files close)

In version 15, when it's done loading, I'm stuck looking at the last Excel
file opened and not my UserForm

on the initial workbook??

I've already tried a number of different options without any success.
Versions 8 thru 14 work fine.

Any ideas?

 

Thanks,

John

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Printing help

[Ravi Kumar]

Hi,

 

 

Try this..

 

Sub sheetprint()

 

Sheets(Summary).Select

Range(D:M).Select

Selection.PrintOut

 

End Sub

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of veerendra vanam
Sent: Thursday, September 05, 2013 4:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Printing help

 




Dear all,

 

 

any one can help i need print of Indus id's for all in
summery sheet type indusid's in  sheet2

-- 

ThanksRegards
 
   Veerendra.Vanam

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Need help on silly problem quickly

[Ravi Kumar]

Hi,

 

 

Here is ur solution

 

Don't use 1 when u put number in if condition always give numbers as it
is. There is no need to give like -1, 1. Simply right -1, 1.

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help on silly problem quickly

 

Hi Team,

 

Request you to kindly provide me solution to below silly problem I am facing
in excel.


 

I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am
getting is not correct, seems some problem with formatting.

 

Pls help.

-- 

Warm Regards,

Kaushik Savla

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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


Solved- Book1 (2).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Need help on silly problem quickly

[Ravi Kumar]

Welcome friend

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:40 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on silly problem quickly

 

Thanks Ravi!

 

On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar excellearn2...@gmail.com
mailto:excellearn2...@gmail.com  wrote:

Hi,

 

 

Here is ur solution

 

Don't use 1 when u put number in if condition always give numbers as it
is. There is no need to give like -1, 1. Simply right -1, 1.

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
] On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:26 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need help on silly problem quickly

 

Hi Team,

 

Request you to kindly provide me solution to below silly problem I am facing
in excel.


 

I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am
getting is not correct, seems some problem with formatting.

 

Pls help.

-- 

Warm Regards,

Kaushik Savla

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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





 

-- 

Warm Regards,

Kaushik Savla

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

RE: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

[Ravi Kumar]

 

Ur welcome friend, yaa it happens most of the time and with most of the
people also.

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pankajinfo
Sent: Tuesday, September 03, 2013 9:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

 

Thank You Ravi So Much for providing this code.

 

this code can be used by Excel users whose data is used for presentations
but they do not get credit for data compiling.

 

 

On Fri, Aug 30, 2013 at 11:32 AM, Ravi Kumar excellearn2...@gmail.com
mailto:excellearn2...@gmail.com  wrote:

Dear Pankaj,

 

 

There is some changes in the code and u can use the attached file as well

 

Private Sub Workbook_Open()

 

On Error Resume Next

Application.DisplayAlerts = False

If 2013-08-31 = Format(Now(), -mm-dd) Then

MsgBox File will expire on 2013-08-31

Else

Worksheets(Sheet3).Activate

 

For Each sh In ActiveWorkbook.Sheets

Cells.Select

Selection.ClearContents

sh.Activate

sh.ChartObjects.Delete

Next

ActiveWorkbook.Save

 

End If

 

Application.DisplayAlerts = True

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: Ravi Kumar [mailto:excellearn2...@gmail.com
mailto:excellearn2...@gmail.com ] 
Sent: Friday, August 30, 2013 11:22 AM
To: 'excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com '
Subject: RE: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

 

Hi Pankaj,

 

 

PFA solution.

 

Note: Press alt+f11 then go to Thisworkbook. Select workbook from the
left drop down and select open from the right drop down then paste the
below code in this. You can use the attached file as well

 

Private Sub Workbook_Open()

 

On Error Resume Next

Application.DisplayAlerts = False

If Format(Now(), -mm-dd) = 2013-08-31 Then

MsgBox File will expire on 2013-08-31

Else

Worksheets(Sheet3).Activate

 

For Each sh In ActiveWorkbook.Sheets

Cells.Select

Selection.ClearContents

sh.Activate

sh.ChartObjects.Delete

Next

ActiveWorkbook.Save

 

End If

 

Application.DisplayAlerts = True

End Sub

 

 

 

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of pankajinfo
Sent: Friday, August 30, 2013 9:58 AM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

 

Dear All,

 

 

I want to create a excel file with Date limit.

 

Like in a file there are some contents(Graphs, Dashboards Etc) with 3
sheets.

 

What i wants is after a time period like 31-Aug13 it gets expired and no one
can open it or if someone opens after 31-Aug-13 it will delete all the file
contents and automatically saves without confirmation.

 

-- 

 

Thanks

Pankaj Kumar

9910075248

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data

RE: $$Excel-Macros$$ Copy data to next empty row

[Ravi Kumar]

Hi,

 

Find out the last row of third workbook/sheet,

 

Workbooks(book3).Activate

Worksheets(sheet3).activate

Finalrow = cells(rows.count,1).end(xlup).row

Range(Afinalrow+1).select

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of DanJ
Sent: Friday, August 30, 2013 10:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy data to next empty row

 

Dear Experts,

 

I have a range,  A37:A115,  in my first (1st)  workbook where I copy and
paste data from my second and third workbook, respectively.

 

Since the number of rows to be copied from the second workbook vary daily,
the next empty row in range A37:A115 of  the first workbook changes too.
How do i determine or code the next empty row where the data from the third
workbook  have to be copied and pasted?

 

Thank you in advance for your help.

 

DanJ

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Copy data to next empty row

[Ravi Kumar]

Hi,

 

Sorry about that but your question is still not clear to me. Could u plz
send me Screen shot in excel or any excel files if you have.

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dante Julian
Sent: Friday, August 30, 2013 12:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy data to next empty row

 

Hi,

Thank you for your quick reply.

I'm sorry if my question wasn't clear. 

What I wanted to find is the next empty row in the first workbook in the
range A37:A115 , i.e., after  I copied and pasted thereon the data from 
the second workbook. 

Again, Thank you.

DanJ

 

 

  _  

From: Ravi Kumar excellearn2...@gmail.com mailto:excellearn2...@gmail.com

To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com  
Sent: Friday, August 30, 2013 2:24 PM
Subject: RE: $$Excel-Macros$$ Copy data to next empty row

 

Hi,

 

Find out the last row of third workbook/sheet,

 

Workbooks(book3).Activate

Worksheets(sheet3).activate

Finalrow = cells(rows.count,1).end(xlup).row

Range(Afinalrow+1).select

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of DanJ
Sent: Friday, August 30, 2013 10:09 AM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Copy data to next empty row

 

Dear Experts,

 

I have a range,  A37:A115,  in my first (1st)  workbook where I copy and
paste data from my second and third workbook, respectively.

 

Since the number of rows to be copied from the second workbook vary daily,
the next empty row in range A37:A115 of  the first workbook changes too.
How do i determine or code the next empty row where the data from the third
workbook  have to be copied and pasted?

 

Thank you in advance for your help.

 

DanJ

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to 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/3iL-MbtQduo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent

RE: $$Excel-Macros$$ Re: Copy data to next empty row

[Ravi Kumar]

Hi,

 

Ok, please see the below code, if still it's not fine then let me know

 

Sub findlastrow()

Dim rng As Range

 

Set rng = Range(A37:A115 )

 

For Each c In rng

If c.Value =  Then

storeval = c.Row

MsgBox storeval

Exit Sub

End If

 

Next

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of DanJ
Sent: Friday, August 30, 2013 12:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Copy data to next empty row

 

Dear Experts,

 

Thank you for your quick replies.

 

Sorry, if my question was not clear.  

 

What I wanted to find  is the last row within the range A37:A115 of the
first workbook.

 

Again, thank you.

 

DanJ

On Friday, August 30, 2013 12:39:15 PM UTC+8, DanJ wrote:

Dear Experts,

 

I have a range,  A37:A115,  in my first (1st)  workbook where I copy and
paste data from my second and third workbook, respectively.

 

Since the number of rows to be copied from the second workbook vary daily,
the next empty row in range A37:A115 of  the first workbook changes too.
How do i determine or code the next empty row where the data from the third
workbook  have to be copied and pasted?

 

Thank you in advance for your help.

 

DanJ

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

RE: $$Excel-Macros$$ Re: Copy data to next empty row

[Ravi Kumar]

 

Yes, that's perfect

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dante Julian
Sent: Friday, August 30, 2013 1:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Copy data to next empty row

 

Dear Ravi,

Did figure it out. In your code, I replaced the line Msgbox storeval with
c.Select.

Thank you and best regards,

DanJ



 

 

  _  

From: Ravi Kumar excellearn2...@gmail.com mailto:excellearn2...@gmail.com

To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com  
Sent: Friday, August 30, 2013 2:57 PM
Subject: RE: $$Excel-Macros$$ Re: Copy data to next empty row

 

Hi,

 

Ok, please see the below code, if still it's not fine then let me know

 

Sub findlastrow()

Dim rng As Range

 

Set rng = Range(A37:A115 )

 

For Each c In rng

If c.Value =  Then

storeval = c.Row

MsgBox storeval

Exit Sub

End If

 

Next

 

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of DanJ
Sent: Friday, August 30, 2013 12:21 PM
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Copy data to next empty row

 

Dear Experts,

 

Thank you for your quick replies.

 

Sorry, if my question was not clear.  

 

What I wanted to find  is the last row within the range A37:A115 of the
first workbook.

 

Again, thank you.

 

DanJ

On Friday, August 30, 2013 12:39:15 PM UTC+8, DanJ wrote:

Dear Experts,

 

I have a range,  A37:A115,  in my first (1st)  workbook where I copy and
paste data from my second and third workbook, respectively.

 

Since the number of rows to be copied from the second workbook vary daily,
the next empty row in range A37:A115 of  the first workbook changes too.
How do i determine or code the next empty row where the data from the third
workbook  have to be copied and pasted?

 

Thank you in advance for your help.

 

DanJ

 

 

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to 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/3iL-MbtQduo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

 

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

RE: $$Excel-Macros$$ Embed Picture in particular cell

[Ravi Kumar]

 

 

Your welcome waseem, OK.. I'll see your query

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Thursday, August 29, 2013 1:16 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Embed Picture in particular cell

 

thanx a lot Ravi.

 it is not what I am asking. But it is too good.

I shall use it.

 

On Thu, Aug 29, 2013 at 12:53 PM, Ravi Kumar excellearn2...@gmail.com
mailto:excellearn2...@gmail.com  wrote:

Hi waseem,

 

 

See if this helps

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
] On Behalf Of Waseem Saifi
Sent: Thursday, August 29, 2013 11:59 AM
To: excel-macros
Subject: $$Excel-Macros$$ Embed Picture in particular cell

 

Dear Experts,
   

   Is it possible to embed picture as background in specific cell in Excel?

Regards,

Waseem Saifi

-- 
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
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

 

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

-- 
Are you

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

[Ravi Kumar Vandavasi]

Dear Sir,
 
Please find the excel sheet attached for better understanding.
 
Regards,
Ravi Kumar
 

On Wednesday, March 28, 2012 4:04:29 PM UTC-7, Don Guillett wrote:

   Do you mean values 0 such as 2 for the last example? 
  
 Don Guillett
 Microsoft MVP Excel
 SalesAid Software
 dguille...@gmail.com
   
  *From:* Ravi Kumar Vandavasi friendswrite...@gmail.com 
 *Sent:* Tuesday, March 27, 2012 10:39 AM
 *To:* excel-macros@googlegroups.com 
 *Subject:* $$Excel-Macros$$ Reading custom format as it appears in a cell
  
  I have an excel file each cell may have different custom formats such as 
 000 or 0940101 or 0080100 etc. I would 
 like to count number of characters in each cell. If I use len() function it 
 retreives the length as it appears in the formula bar and not the maked 
 characters by custom format. 
 Please tell me how to read masked characters by custom format.
  
 Thanks  Regards,
 Ravi Kumar Vandavasi
 -- 
 FORUM RULES (986+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 NOTE : Don't ever post personal or confidential data in a workbook. Forum 
 owners and members are not responsible for any loss.
  

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


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

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

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

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

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

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

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

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


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

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

[Ravi Kumar Vandavasi]

Dear Sir,
 
I have a series of Numbers where there might be less than 15 digits i.e. 
custom format is used as 00 (14 instead of 15 or 16 instead 
of 15). So, I need to identify these numbers which are wrongly custom 
formatted. For better understanding, please check the attached file.
 
Regards,
Ravi Kumar 

On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote:

 Dear Ravi,

 Please use =REPT(0,15-LEN(A2))A2 instead of Custom format..
 then you can easly count lenght..

 See attached sheet.

 On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi 
 friendswrite...@gmail.com wrote:

 I have an excel file each cell may have different custom formats such as 
 000 or 0940101 or 0080100 etc. I would 
 like to count number of characters in each cell. If I use len() function it 
 retreives the length as it appears in the formula bar and not the maked 
 characters by custom format. 
 Please tell me how to read masked characters by custom format.
  
 Thanks  Regards,
 Ravi Kumar Vandavasi

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

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




 -- 
 Thanks  regards,
 Noorain Ansari
  ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
  


On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: 

 Dear Ravi,

 Please use =REPT(0,15-LEN(A2))A2 instead of Custom format..
 then you can easly count lenght..

 See attached sheet.

 On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi 
 friendswrite...@gmail.com wrote:

 I have an excel file each cell may have different custom formats such as 
 000 or 0940101 or 0080100 etc. I would 
 like to count number of characters in each cell. If I use len() function it 
 retreives the length as it appears in the formula bar and not the maked 
 characters by custom format. 
 Please tell me how to read masked characters by custom format.
  
 Thanks  Regards,
 Ravi Kumar Vandavasi

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

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




 -- 
 Thanks  regards,
 Noorain Ansari
  ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
  



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

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

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

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

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

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

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

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


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

$$Excel-Macros$$ Reading custom format as it appears in a cell

[Ravi Kumar Vandavasi]

I have an excel file each cell may have different custom formats such as 
000 or 0940101 or 0080100 etc. I would 
like to count number of characters in each cell. If I use len() function it 
retreives the length as it appears in the formula bar and not the maked 
characters by custom format. 
Please tell me how to read masked characters by custom format.
 
Thanks  Regards,
Ravi Kumar Vandavasi

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Vlookup in Macro

[Ravi Kumar Vandavasi]

U can use on error goto msg

msg: Inputbox()

On Dec 13, 9:52 am, Raj Mahapatra rajafs...@gmail.com wrote:
 hi Vaibhav,

 thanks for this.

 but i want to dispaly an input box as *lookfor is not in the rng* while
 there is error.



 On Fri, Dec 10, 2010 at 1:32 PM, in.vaib...@gmail.com wrote:
  Hi,

  Add line;

  On error resume next

  Rgds
  Vaibhav J

  Sent on my BlackBerry® from Vodafone
  --
  *From: *Raj Mahapatra rajafs...@gmail.com
  *Sender: *excel-mac...@googlegroups.com
  *Date: *Fri, 10 Dec 2010 10:02:19 +0530
  *To: *excel-macros@googlegroups.com
  *ReplyTo: *excel-mac...@googlegroups.com
  *Subject: *$$Excel-Macros$$ Vlookup in Macro

  hi group,

  In the following vlookup code in macro, if any object is #N/A in the rng
  then *run time error 1004*occurs.  In such case, i want that it should
  show a message as *lookfor data is not in the range*

  help me how to put msg box if lookfor is not in the rng.

  Sub vlookup()
  Dim lookfor As Range
  Dim rng As Range
  Dim col As Integer

  Set lookfor = ActiveCell.Offset(0, 2)
      Set rng = Sheets(MV).Columns(A:C)
      col = 3

      dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0)
  End Sub
  Thanks  Regards

  Rajesh Mahapatra

  --

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

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

  
  Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;...

  --

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

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

  
  Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- 
 Hide quoted text -

 - Show quoted text -

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

$$Excel-Macros$$ Re: Appending formula

[Ravi Kumar Vandavasi]

Dear Prashanth,

Append your formula like this. This should help.

=IF(OR(D16=Summary!$C$3,C16=AAA, C16=BBB, C16=CCC),High,IF
(D16Summary!$C$3,Medium,Low))

Regards,
V Ravi Kumar

On Sep 14, 10:18 am, Prashanth Banneni praba...@gmail.com wrote:
 Hi All,

 I have a query, which needs to be appended.

 I have this formula in column F which shows the importance as High, Medium
 and Low  based on column E.

 However i want it to also check Column C and change the Importance to Only
 HIGH if column C values are AAA, BBB, CCC, DDD and so on.

 Please find attached the Excel sheet for reference.

 Awaiting an early response from Excel Gurus.

 Thanks in Advance

 Prashanth

  Test.xls
 99KViewDownload

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: IF Condition

[Ravi Kumar Vandavasi]

=IF(B45,IF(E42,IF(H42,Yes,No), No), NO)

On Aug 6, 5:53 pm, Putta Madaiah puttamada...@gmail.com wrote:
 Hi All,

 Can anyone provide me the formulas as per the requirement in the attachment.

 Rgds,
 Putta - Bangalore

  Formula.xlsx
 35KViewDownload

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---