Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-20 Thread Sam Mathai Chacko 
Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm
On Aug 21, 2013 11:04 AM, "P.VIJAYKUMAR"  wrote:

> Respected Mog-Godiva,
>
> You can find the digitizer from the following links,
> http://digitizer.sourceforge.net/
> http://www.mathtools.net/Excel/Graphics_and_Visualization/
>
>
> Regards,
> Vijaykumar
>
>
> On Wed, Aug 21, 2013 at 5:43 AM, Mog Godiva-Man wrote:
>
>> Anyone know where I can get some Addin for digitizing data from graphical
>> line/chart images in excel.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are 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.
>>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> P.VIJAY KUMAR
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/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$$ Microsoft Excel based application that digitizes data from pictures

2013-08-20 Thread P.VIJAYKUMAR 
Respected Mog-Godiva,

You can find the digitizer from the following links,
http://digitizer.sourceforge.net/
http://www.mathtools.net/Excel/Graphics_and_Visualization/


Regards,
Vijaykumar


On Wed, Aug 21, 2013 at 5:43 AM, Mog Godiva-Man  wrote:

> Anyone know where I can get some Addin for digitizing data from graphical
> line/chart images in excel.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are 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.
>



-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

$$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-20 Thread Prafull Jadhav 
Dear All,

Very Good Morning,

I have made 10 charts and now I want to change the  Size of Font  14 to 9
for Chart Title.

is it possible to change it through the VBA

for example

For each

For Next

Do until
  if yes , Please  provide the same

  Thanks in Advance

Regards,

Prafull Jadhav.

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are 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$$ Is there a way to insert images into a specific cell?

2013-08-20 Thread Eugene Bernard 
Instead of inserting the images, why can't you use hyperlinks !!!.

Regards
Eugene


On Tue, Aug 20, 2013 at 3:39 AM, Chaya Cooper  wrote:

> I often use Excel to organize rows of text (i.e. terminology, examples,
> subsets, etc.) and often need to include images in a row. However since
> images aren't actually in a specific cell they therefore aren't linked to
> the rest of the information in the row, making it impossible to sort the
> data, as well as quite cumbersome to format.
>
> As a result, I have been splitting the information up into tables in both
> Excel and Word, but I would obviously like to find a simpler way to do this
> so that all of the information can be kept together. Is there a way for me
> to use images in Excel in much the same way I do in the Word tables?
>
> As I am using this for several hundred images, I would ideally like to
> drag the images in order to insert or move them the way that I do in Word.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-20 Thread svenyarl 
I am open to suggestions on how best to go about this and am aware this 
might be a fairly simple request but I either lack the expertise or the 
correct vernacular to find the answer myself. 

On a daily basis I receive files of approximately 56000 rows of part 
numbers along with each parts pertinent data. From this I must remove parts 
located on a separate list of about 8000 parts from the original in order 
for the files to load correctly. So far I have been solving this by VLOOKUP 
and then manually deleting but I am aware there must be a quicker and 
easier way either by VBA, Macro, or SQL scripting. I am open to any 
suggestions as to how best to do this.

Ultimately I would like the result to be that by selecting a particular 
column and for instance running a macro it would delete the matching part 
numbers and their corresponding rows being that the column the part number 
is located on changes from file to file.

I do not expect anyone to do the work for me (although if you do I will be 
eternally grateful) if you could give me the correct syntax for what I am 
trying to do so I can appropriately find the answer this would be extremely 
helpful.

Thank you in advance. 

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

FORUM RULES

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

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

$$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-20 Thread Mog Godiva-Man 
Anyone know where I can get some Addin for digitizing data from graphical
line/chart images in excel.

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are 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 or UDF to do Vlookup for values delimited with ]

2013-08-20 Thread De Premor 

try to replace current code with this

Function LookForCode(Str As String, Data As Range, Colx As Integer, 
Optional Delim As String = "]")

Dim Kode, Tmp As String
For Each Kode In Split(Str, Delim)
If Kode <> "" Then Tmp = Tmp & " " & 
WorksheetFunction.VLookup(Kode, Data, Colx, 0)

Next
LookForCode = Trim(Tmp)
End Function

Pada 20/08/2013 22:56, prkhan56 menulis:

Thanks Ravinder,
Couple of things if you would kindly rectify it please.
1) For some reason, the UDF does not work for codes which is not on 
the active sheet.  I had posted my problem for sake of explanation on 
the same sheet but in reality it is on other sheet.
2) If you could please convert it to a macro so that I can *select the 
codes* on any sheet in the  active workbook and run the macro then it 
would *_replace the codes with the answer on the same cell._*

Really appreciate your help as it would save me lot of time.
Regards
Rashid Khan

On Monday, August 19, 2013 11:49:04 AM UTC+4, Ravinder Negi wrote:


PFA.There are three argument in UDF first lookup value ,
lookarea(range),colnum

*From:* Rashid Khan >
*To:* excel-...@googlegroups.com 
*Sent:* Sunday, August 18, 2013 9:32 PM
*Subject:* $$Excel-Macros$$ Formula or UDF to do Vlookup for
values delimited with ]

Hello All,
I am attaching a sample of my problem.
I need to do Vlookup from a Range which has Codes in Col A and
Text in Col B.
I want to have the output required (highlighted in Yellow) on Col
D based on the Answers Col C.
My problem is that the Codes are delimited with ].
I do not want to separate the Answers using Text to Column.
I tried the following and got the desired result if there is only
one code in the Answers Column.
=VLOOKUP(LEFT(C2,FIND("]",C2)-1),RangeCodes,2,0)
As you can see in the attached sheet if there are many Codes
combined together then I cannot get the desired result.
Is there a formula or a UDF which can give me the desired result.
Please note that there are several Columns with the Codes
combined.  I have just used a sample column to demonstrate my problem.
TIA
Rashid Khan
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel


FORUM RULES

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

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


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


FORUM RULES

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

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


--
Are you =EXP(

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-20 Thread prkhan56 
Thanks Ravinder,
Couple of things if you would kindly rectify it please.
 
1) For some reason, the UDF does not work for codes which is not on the 
active sheet.  I had posted my problem for sake of explanation on the same 
sheet but in reality it is on other sheet.  
2) If you could please convert it to a macro so that I can *select the codes
* on any sheet in the  active workbook and run the macro then it would *replace 
the codes with the answer on the same cell.*
  
Really appreciate your help as it would save me lot of time.
Regards
Rashid Khan
 

On Monday, August 19, 2013 11:49:04 AM UTC+4, Ravinder Negi wrote:

>
> PFA.There are three argument in UDF first lookup value , 
> lookarea(range),colnum
>   --
>  *From:* Rashid Khan >
> *To:* excel-...@googlegroups.com  
> *Sent:* Sunday, August 18, 2013 9:32 PM
> *Subject:* $$Excel-Macros$$ Formula or UDF to do Vlookup for values 
> delimited with ]
>  
> Hello All,
> I am attaching a sample of my problem.
> I need to do Vlookup from a Range which has Codes in Col A and Text in Col 
> B.
>  
> I want to have the output required (highlighted in Yellow) on Col D based 
> on the Answers Col C.
>  
> My problem is that the Codes are delimited with ].
> I do not want to separate the Answers using Text to Column.
>  
> I tried the following and got the desired result if there is only one code 
> in the Answers Column.
> =VLOOKUP(LEFT(C2,FIND("]",C2)-1),RangeCodes,2,0)
>  
> As you can see in the attached sheet if there are many Codes combined 
> together then I cannot get the desired result.
>  
>  
>  
> Is there a formula or a UDF which can give me the desired result.
>  
> Please note that there are several Columns with the Codes combined.  I 
> have just used a sample column to demonstrate my problem.
>  
> TIA
>  
> Rashid Khan
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/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 - How to enter the text in the cells of column by using textbox in userform

2013-08-20 Thread Mangesh Vimay 
Thanks a ton !!!

On 8/20/13, De Premor  wrote:
> paste this on userform1
>
> '
> Dim Target As Range
>
> Private Sub CommandButton1_Click()
>  Target.Offset(1).Select
>  Unload Me
> End Sub
>
> Private Sub TextBox1_Change()
>  Target = TextBox1.Text
> End Sub
>
> Private Sub UserForm_Activate()
>  Set Target = Selection
>  TextBox1.Text = Target
> End Sub
>
> '--
> Pada 19/08/2013 23:36, Mangesh Vimay menulis:
>> Hi Friends,
>>
>> Please suggest me vba code to enter the text in A1, A2, A3..likewise
>> by using VBA Userform textbox. I have attached sample file for you
>> reference. Double click on cell A1, A2 will open the useform for which
>> I need the code.
>>
>> Thanks in advance.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>


-- 
With regards,

*MaNgEsH*

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are 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$$ Folder Query (urgrnt)

2013-08-20 Thread Shrinivas Shevde 
Dear Anil and Ashish
Thanks problem solved

Regards
Shrinivas


On Tue, Aug 20, 2013 at 9:32 AM, ashish koul  wrote:

> try this
>
> Sub choose_file()
>
> Dim flname As String
> Dim fd As FileDialog, fl As Variant
> Set fd = Application.FileDialog(msoFileDialogFilePicker)
> With fd
> .AllowMultiSelect = True
> .Title = "Please choose the file"
> .Filters.Add "Excel Files", "*.xls*", 1
> .Show
> End With
>
> For Each fl In fd.SelectedItems
> MsgBox fl
> Next
>
>
>
> End Sub
>
>
>
>
>
> On Mon, Aug 19, 2013 at 2:27 PM, अनिल नारायण गवली  > wrote:
>
>> Dear Shrinivas,
>>
>> Pl see that u have filter the ext with the following one.
>>
>> .Filters.Add "Excel", "*.xls; *.xlsx; *.xlsm; *.xlsb", 1
>>
>> Warm Regards,
>> Gawli Anil
>>
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
>>
>> On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas Shevde > > wrote:
>>
>>> Dear All
>>> I am facing a small problem I like to have help for expert.
>>> I am trying to write a macro which will browse the folder and open the
>>> selected file one by one.
>>> But whenever I am opening a folder from macro I could not see any file
>>> in that folder.
>>> If I am opening the same folder directly there are many files in that
>>> can anyone help me its urgent
>>>
>>>
>>> --
>>> 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 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.
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.