Re: $$Excel-Macros$$ Need macro for repetative formatting

[Suyog Kulkarni]

Hello All,

Pl help & try to solve my problem.

Regards,
Suyog




On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote:
>
> Hello Vicky,
>
> I'm not at all coping data from any where otherwise I would have used the 
> "paste special". I'm pulling data from software & which some times finish 
> within 10 rows & 10 columns & sometimes it's cross 30 columns & 100 plus 
> rows.
>
> If somehow I want to tell excel that follow my 10 steps upto last row & 
> last column which is having text. It may be "row 10 column 10" or "row 85 
> or column 60" or anything. Sometimes it's come so hectic to just waste time 
> on formatting only. 
>
> Pl help & solve this problem.
>
> With Regards,
> Suyog 
>
> On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote:
>>
>> Hi Suyog,
>>
>>
>> My understanding is you would like to have same format for all data so my 
>> logic is rather formating each line of data I have saved your format in 
>> "Format" tab in attached sheet and then that format will be applied to your 
>> copied data in Original Sheet.
>>
>> Same as we do in Excel using *Paste special + Paste+Formats.* 
>>
>> Hope this makes sense.
>>
>> Regards,
>>
>>
>> On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni wrote:
>>
>>> Hello All,
>>>
>>> Greetings for the day. 
>>> Pl refer attached excel, I'm using one database software & when I pull 
>>> out different reports from that I need to do 10 steps for each report every 
>>> time. I've tried to record macro also but I don't know how to find out 
>>> "last cell which contains text" sometimes report may finish in F column & 
>>> 30th row or sometimes it cross P column & 150th row. 
>>>
>>> Refer attached excel, I've added my steps, sample of original report & 
>>> sample of expected report. If I got answer of this, this will increase my 
>>> productivity & can save lots of time. 
>>>
>>> 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.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>

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

FORUM RULES

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

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

$$Excel-Macros$$ Save only a few sheets

[Stefano Tagliaferri]

Hello! Sorry for my English (Google translator)! 
I would like to write an Excel macro that can save to a different folder of 
the active, two or three sheets belonging to the folder where I'm working. 
It's possible? Thanks for your help
Stefano

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Excel

[pmyk]

If you know which cells to copy, use this:
Sheets("Sheet1").Select  
Range("A2:B20").Select  
Selection.Copy  
Sheets("Sheet2").Select
Range("A2").Select   
ActiveSheet.Paste

On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote:
>
> I have a database and want to populate data into cells from another sheet 
> in the same database in excel, any suggestion how I can go about this?
>  
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Extract only text from alphanumeric string

[pmyk]

SImple and good suggestion.

On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote:
>
> PFA,
>
>
>
>
> On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow 
> 
> > wrote:
>
>> Hi Team,
>>
>> I need to extract only the text from the alphanumeric string, can you 
>> please help me with a formula.
>>
>> Sample data attached
>>
>>   12Mum159 Mum  46Kol2335 Kol  63Ch270 Ch  180Del307 De 
>>
>> 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...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Thanks and Regards, Rp.
>  

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

FORUM RULES

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

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

$$Excel-Macros$$ Help required on formula

[Jocky Beta]

Hi All,

Pls fin above attached sheet in which Query sheet when i type any word
related to Item code ELEC0001 (Kindly see the master sheet) it will search
the Item Name automatically. But when i put bulb it's not showing any vale
as well as Item name also.

hence request you to kindly help me on 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.
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.


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

Re: $$Excel-Macros$$ Need suggestion.

[Abhishek Jain]

If you'd add me on chat, you will know when I am online.

PS: The group doesn't need to be bothered about it, so let's just keep it
between us.

Thanks & regards,

Abhsihek


On Fri, Mar 28, 2014 at 12:31 AM, Prabhu Pinky wrote:

> Yea sure...please let me know your feasible time to contact.
> On 27-Mar-2014 11:32 PM, "Abhishek Jain"  wrote:
>
>> You may please contact me via chat.
>>
>> Thanks
>>
>>
>> On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
>>
>>> No abhi...since its official... Am unable to share...
>>> On 27-Mar-2014 6:00 PM, "Abhishek Jain"  wrote:
>>>
 Please provide more info or screenshot of the screen where you have to
 input the date generating the report.

 Regards, Abhishek



 On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky 
 wrote:

> Yes abhi...it shld be in vba excel. Pls help
> On 26-Mar-2014 3:30 PM, "Abhishek Jain" 
> wrote:
>
>> Does it have to be Excel VBA?
>>
>> I am sure there are many FTP clients that support automated and
>> scheduled transfers (upload or download). If you want that I can look 
>> into
>> some.
>>
>> Regards,
>>
>> Abhishek
>>
>>
>> On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky > > wrote:
>>
>>> Hi experts,
>>>
>>> i need your suggestions on my new project.
>>>
>>>
>>>  *Here is my scenario:*
>>>
>>> in our office, we have a ftp link for one application. on a daily
>>> bases i am opening that link and entering my login id and pwd. there we
>>> have many tabs for many reports.
>>>
>>> am just selecting my required report and entering date range and
>>> pulling report. is it possible to do this action using vba code?. daily 
>>> at
>>> particular time this macro should automatically run and save the file in
>>> particular folder.
>>>
>>> please help with your suggestions and ideas to complete this project.
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks & Regards,
>>> Prabhu R
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are 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)

Re: $$Excel-Macros$$ Need suggestion.

[Prabhu Pinky]

Yea sure...please let me know your feasible time to contact.
On 27-Mar-2014 11:32 PM, "Abhishek Jain"  wrote:

> You may please contact me via chat.
>
> Thanks
>
>
> On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
>
>> No abhi...since its official... Am unable to share...
>> On 27-Mar-2014 6:00 PM, "Abhishek Jain"  wrote:
>>
>>> Please provide more info or screenshot of the screen where you have to
>>> input the date generating the report.
>>>
>>> Regards, Abhishek
>>>
>>>
>>>
>>> On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
>>>
 Yes abhi...it shld be in vba excel. Pls help
 On 26-Mar-2014 3:30 PM, "Abhishek Jain"  wrote:

> Does it have to be Excel VBA?
>
> I am sure there are many FTP clients that support automated and
> scheduled transfers (upload or download). If you want that I can look into
> some.
>
> Regards,
>
> Abhishek
>
>
> On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky 
> wrote:
>
>> Hi experts,
>>
>> i need your suggestions on my new project.
>>
>>
>>  *Here is my scenario:*
>>
>> in our office, we have a ftp link for one application. on a daily
>> bases i am opening that link and entering my login id and pwd. there we
>> have many tabs for many reports.
>>
>> am just selecting my required report and entering date range and
>> pulling report. is it possible to do this action using vba code?. daily 
>> at
>> particular time this macro should automatically run and save the file in
>> particular folder.
>>
>> please help with your suggestions and ideas to complete this project.
>>
>>
>>
>>
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are 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

Re: $$Excel-Macros$$ How to match a combobox result with an textbox

[Abhishek Jain]

A sample file would help understand better.

Thanks.


On Thu, Mar 27, 2014 at 8:28 PM, Tommy  wrote:

> Hi,
>
> i am stuck on my project, an i am still a noob on VBA :P
>
> i have a userform with  4 textboxes and a combobox with 5 options that
> link each one to 5 sheets.
> Sheets  (A,B,C,D and E)
> Combobox with options ( 1,2,3,4 and 5)
> textboxes (textnorth, textsouth,textwest and texteast)
>
> when i choose option 1 from combobox, it should only display the result of
> the cell "C3" from sheet A  on textbox (textnorth) and nothing on the other
> textboxes
>
> when i choose option 2 from combobox, it should only display the result of
> the cell "C3" from sheet B  on textbox (texteast) and nothing on the other
> textboxes
>
>
> when i choose option 3 from combobox, it should only display the results
> of the cell "C3" from sheet C and D  on the textboxes (textnorth and
> txtwest) and nothing on the other textboxes
>
>
> i tried using the match function, but its not working.
>
> Can anyone help me please ?
>
> Thks in advance.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Need suggestion.

[Abhishek Jain]

You may please contact me via chat.

Thanks


On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:

> No abhi...since its official... Am unable to share...
> On 27-Mar-2014 6:00 PM, "Abhishek Jain"  wrote:
>
>> Please provide more info or screenshot of the screen where you have to
>> input the date generating the report.
>>
>> Regards, Abhishek
>>
>>
>>
>> On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
>>
>>> Yes abhi...it shld be in vba excel. Pls help
>>> On 26-Mar-2014 3:30 PM, "Abhishek Jain"  wrote:
>>>
 Does it have to be Excel VBA?

 I am sure there are many FTP clients that support automated and
 scheduled transfers (upload or download). If you want that I can look into
 some.

 Regards,

 Abhishek


 On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky 
 wrote:

> Hi experts,
>
> i need your suggestions on my new project.
>
>
>  *Here is my scenario:*
>
> in our office, we have a ftp link for one application. on a daily
> bases i am opening that link and entering my login id and pwd. there we
> have many tabs for many reports.
>
> am just selecting my required report and entering date range and
> pulling report. is it possible to do this action using vba code?. daily at
> particular time this macro should automatically run and save the file in
> particular folder.
>
> please help with your suggestions and ideas to complete this project.
>
>
>
>
>
>
> Thanks & Regards,
> Prabhu R
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are 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 all

Re: $$Excel-Macros$$ Extract only text from alphanumeric string

[Rupesh Patil]

PFA,




On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow wrote:

> Hi Team,
>
> I need to extract only the text from the alphanumeric string, can you
> please help me with a formula.
>
> Sample data attached
>
>   12Mum159 Mum  46Kol2335 Kol  63Ch270 Ch  180Del307 De
>
> 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.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks and Regards, Rp.

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


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

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

[Michael Stokes]

Ashish,

The code works great!!! How could it be modified to create a new Excel 
document for each Word table discovered?  Kindly advise.  Thank you, 
Michael 

On Wednesday, October 2, 2013 1:09:44 AM UTC-4, ashish wrote:
>
> try this
>
> Sub import_word_table_to_excel()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> Dim fldpath
> Dim fld, fil As Object
> Dim appWord As Word.Application
> Dim docWord As Word.Document
> Dim tableWord As Word.Table
> Dim sdoc As String
>
>
> ' use to choose the folder having word documents
>
> Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Folder"
> Application.FileDialog(msoFileDialogFolderPicker).Show
> fldpath = 
> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
> Set fso = CreateObject("scripting.filesystemobject")
> Set fld = fso.getfolder(fldpath)
>
> Set appWord = New Word.Application
> appWord.Visible = True
> For Each fil In fld.Files
>
> ' browse word documents in a folder
>
>
> If UCase(Right(fil.Path, 4)) = UCase(".doc") Or UCase(Right(fil.Path, 5)) 
> = UCase(".docx") Then
> Set docWord = appWord.Documents.Open(fil.Path)
> For Each tableWord In docWord.Tables
> ' copy word tables
> tableWord.Range.Copy
> ' paste it on sheet 1 of excel file
> Sheets(1).Paste Destination:=Sheets(1).Range("A65356").End(xlUp).Offset(1, 
> 0)
> Next
> docWord.Close
> End If
> Next fil
>
>
> appWord.Quit
> Sheets(1).Select
> Set tableWord = Nothing
> Set docWord = Nothing
> Set appWord = Nothing
>
> Application.DisplayAlerts = True
> Application.ScreenUpdating = True
>
> End Sub
>
>
> On Mon, Sep 30, 2013 at 12:47 PM, Nasir Khan 
> 
> > wrote:
>
>>
>> Hello All,
>> I have got lot of MS Word files in a folder eg. C:\Test\> here>
>> I wish to copy and paste the Tables from all the word documents in the 
>> above mentioned folder to excel.
>>  
>> I found Macro1 (see below) which copy and paste the Table in Excel.
>> My requirement is to get the tables from all the documents from each 
>> folder in the path C:\Test\
>> Can Macro 1 be amended *to copy and paste all tables from each folder in 
>> C:\Test\*
>>  
>> *MACRO 1 TO IMPORT WORD TABLE*
>> Sub ImportWordTable()
>> On Error GoTo errHandler
>> Dim wordDoc As Object
>> Dim wdFileName As Variant
>> Dim noTble As Integer
>> Dim rowNb As Long
>> Dim colNb As Integer
>> Dim x As Long, y As Long
>> x = 1: y = 1
>> wdFileName = Application.GetOpenFilename("Word files 
>> (*.docx),*.docx", , _
>> "Browse for file containing table to be imported") 'adjust this to 
>> the document type you are after
>> If wdFileName = False Then Exit Sub
>> Set wordDoc = GetObject(wdFileName)
>> With wordDoc
>> noTble = wordDoc.tables.Count
>> If noTble = 0 Then
>> MsgBox "No Tables in this document", vbExclamation, "No 
>> Tables to Import"
>> Exit Sub
>> End If
>>  
>>  
>> For k = 1 To noTble
>> With .tables(k)
>> For rowNb = 1 To .Rows.Count
>> For colNb = 1 To .Columns.Count
>> Cells(x, y) = 
>> WorksheetFunction.Clean(.cell(rowNb, colNb).Range.Text)
>> y = y + 1
>> Next colNb
>> y = 1
>> x = x + 1
>> Next rowNb
>> End With
>> x = x + 2
>> Next
>> End With
>> Set wordDoc = Nothing
>> Exit Sub
>> errHandler:
>> MsgBox "Error in generating tables - " & Err.Number & " - " & 
>> Err.Description
>> End Sub
>>  
>> *MACRO 2 TO RUN ON ALL THE FOLDERS - this gives me runtime error as shown 
>> below*
>>  
>> Sub RunOnAllFolders()
>> Dim file
>> Dim path As String
>> Dim MyArray()
>> Dim N As Long
>>  path = "C:\Test\"
>> file = Dir(path & "*.docx")
>> ReDim MyArray(0)
>> Do While file <> ""
>> If MyArray(0) = "" Then
>> MyArray(0) = file
>> Else
>> ReDim Preserve MyArray(UBound(MyArray) + 1)
>> MyArray(UBound(MyArray)) = file
>> End If
>> file = Dir()
>> Loop
>> For N = 0 To UBound(MyArray)
>>Documents.Open filename:=path & MyArray(N) *'<> ActiveX Component can't create Object >>*
>>
>>  *Call ImportWordTable*
>> 
>> ActiveDocument.Save
>> ActiveDocument.Close
>> file = Dir()
>> Next N
>> End Sub
>> Can the runtime error 429 be rectified from Macro 2
>>  
>> Any help would be appreciated.
>> Regards
>> Nasir 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

Re: $$Excel-Macros$$ Need suggestion.

[Prabhu Pinky]

No abhi...since its official... Am unable to share...
On 27-Mar-2014 6:00 PM, "Abhishek Jain"  wrote:

> Please provide more info or screenshot of the screen where you have to
> input the date generating the report.
>
> Regards, Abhishek
>
>
>
> On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
>
>> Yes abhi...it shld be in vba excel. Pls help
>> On 26-Mar-2014 3:30 PM, "Abhishek Jain"  wrote:
>>
>>> Does it have to be Excel VBA?
>>>
>>> I am sure there are many FTP clients that support automated and
>>> scheduled transfers (upload or download). If you want that I can look into
>>> some.
>>>
>>> Regards,
>>>
>>> Abhishek
>>>
>>>
>>> On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote:
>>>
 Hi experts,

 i need your suggestions on my new project.


  *Here is my scenario:*

 in our office, we have a ftp link for one application. on a daily bases
 i am opening that link and entering my login id and pwd. there we have many
 tabs for many reports.

 am just selecting my required report and entering date range and
 pulling report. is it possible to do this action using vba code?. daily at
 particular time this macro should automatically run and save the file in
 particular folder.

 please help with your suggestions and ideas to complete this project.






 Thanks & Regards,
 Prabhu R

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

 FORUM RULES

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

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are 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 be

$$Excel-Macros$$ How to match a combobox result with an textbox

[Tommy]

Hi,

i am stuck on my project, an i am still a noob on VBA :P

i have a userform with  4 textboxes and a combobox with 5 options that link 
each one to 5 sheets.
Sheets  (A,B,C,D and E)
Combobox with options ( 1,2,3,4 and 5)
textboxes (textnorth, textsouth,textwest and texteast)

when i choose option 1 from combobox, it should only display the result of 
the cell "C3" from sheet A  on textbox (textnorth) and nothing on the other 
textboxes

when i choose option 2 from combobox, it should only display the result of 
the cell "C3" from sheet B  on textbox (texteast) and nothing on the other 
textboxes


when i choose option 3 from combobox, it should only display the results of 
the cell "C3" from sheet C and D  on the textboxes (textnorth and txtwest) 
and nothing on the other textboxes


i tried using the match function, but its not working.

Can anyone help me please ?

Thks in advance.

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

FORUM RULES

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

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

$$Excel-Macros$$ Extract only text from alphanumeric string

[Capt. Jack Sparrow]

​Hi Team,

I need to extract only the text from the alphanumeric string, can you
please help me with a formula.

Sample data attached

  12Mum159 Mum  46Kol2335 Kol  63Ch270 Ch  180Del307 De

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


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

$$Excel-Macros$$ error while sending email with gmail (using CDO)

[priti verma]

Hi all,
Can someone tell me why i am getting this error---The "sendusing"
confugration value is invalid.

i am working on access version 2010.and using this code.



Sub sendmail()
Dim imsg As Object
Dim iconf As Object
Dim flds As Object
Dim schema As String
Dim stremailId As String
Dim strpassword As String

stremailId = InputBox("emailid")

strpassword = InputBox("password")



Set imsg = CreateObject("CDO.Message")
Set iconf = CreateObject("CDO.Configuration")
Set flds = iconf.Fields

'send one copy with SMTP server (with autentication)
schema = "http://schemas.microsoft.com/cdo/configuration/";
flds.Item(schema & "sendusing") = 2 'cdoSendUsingPort
flds.Item(schema & "smtpserver") = "smtp.gmail.com"
flds.Item(schema & "smtpserverport") = 25
flds.Item(schema & "smtpauthenticate") = cdoBasic
flds.Item(schema & "sendusername") = stremailId
flds.Item(schema & "sendpassword") = strpassword
flds.Item(schema & "smtpusessl") = 1
flds.Update
If Len(stremailId) > 0 And Len(strpassword) > 0 Then
 With imsg
.to = "pritiverma1392@gmailcom"
.From = "pritioscill...@gmail.com"
.Subject = "TEST"
.HTMLBody = "test mail"
.Sender = "Sender"
'.Organization = "My Company"
'.ReplyTo = "addr...@mycompany.com"rr
   '.AddAttachment Rs.Fields(1)
   .Send
  End With
  MsgBox "Messege sent successfully", vbInformation
Else
MsgBox "you are not loged in", vbCritical
DoCmd.OpenForm "Login", acNormal
End If
End Sub


Thanks in advance

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

FORUM RULES

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

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

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

[Vabs]

Hi

You can format cell as DD-Mmm- or

you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.

Thanks


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

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Need suggestion.

[Abhishek Jain]

Please provide more info or screenshot of the screen where you have to
input the date generating the report.

Regards, Abhishek



On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:

> Yes abhi...it shld be in vba excel. Pls help
> On 26-Mar-2014 3:30 PM, "Abhishek Jain"  wrote:
>
>> Does it have to be Excel VBA?
>>
>> I am sure there are many FTP clients that support automated and scheduled
>> transfers (upload or download). If you want that I can look into some.
>>
>> Regards,
>>
>> Abhishek
>>
>>
>> On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote:
>>
>>> Hi experts,
>>>
>>> i need your suggestions on my new project.
>>>
>>>
>>>  *Here is my scenario:*
>>>
>>> in our office, we have a ftp link for one application. on a daily bases
>>> i am opening that link and entering my login id and pwd. there we have many
>>> tabs for many reports.
>>>
>>> am just selecting my required report and entering date range and pulling
>>> report. is it possible to do this action using vba code?. daily at
>>> particular time this macro should automatically run and save the file in
>>> particular folder.
>>>
>>> please help with your suggestions and ideas to complete this project.
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks & Regards,
>>> Prabhu R
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are 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, sen

Re: $$Excel-Macros$$ Need suggestion.

[Prabhu Pinky]

Yes abhi...it shld be in vba excel. Pls help
On 26-Mar-2014 3:30 PM, "Abhishek Jain"  wrote:

> Does it have to be Excel VBA?
>
> I am sure there are many FTP clients that support automated and scheduled
> transfers (upload or download). If you want that I can look into some.
>
> Regards,
>
> Abhishek
>
>
> On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote:
>
>> Hi experts,
>>
>> i need your suggestions on my new project.
>>
>>
>>  *Here is my scenario:*
>>
>> in our office, we have a ftp link for one application. on a daily bases i
>> am opening that link and entering my login id and pwd. there we have many
>> tabs for many reports.
>>
>> am just selecting my required report and entering date range and pulling
>> report. is it possible to do this action using vba code?. daily at
>> particular time this macro should automatically run and save the file in
>> particular folder.
>>
>> please help with your suggestions and ideas to complete this project.
>>
>>
>>
>>
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

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

[Neeraj Chauhan]

Dear experts,

 

We have given below date format how to convert right format of date like
13-Jan-2014

 


TT Modified Date & Time


13/01/2014


15/01/2014 19:51


2-Nov-14


1-Jun-14


2-Nov-14


15/01/2014 19:57


1-Jun-14


13/01/2014 17:10


15/01/2014 19:47


18/01/2014 15:44

 

 

 

From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] 
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently

 

Dear experts,

 

We have givne below date format how to convert right format of date like
13-Jan-2014

 


TT Modified Date & Time


13/01/2014


15/01/2014 19:51


2-Nov-14


1-Jun-14


2-Nov-14


15/01/2014 19:57


1-Jun-14


13/01/2014 17:10


15/01/2014 19:47


18/01/2014 15:44

 

 

 

Description: Description: image001

Neeraj Chauhan

+91-9756706350

 



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

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

FORUM RULES

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

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

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

[Pramod Singh]

i means to say that u have  know of vba excel web scrapting book  .

i want to learn . web scrapting .


On Thu, Mar 27, 2014 at 3:21 PM, Divaker Pandey  wrote:

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



-- 
*PramodSingh*

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

FORUM RULES

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

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

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

[Neeraj Chauhan]

 

 

From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] 
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently

 

Dear experts,

 

We have givne below date format how to convert right format of date like
13-Jan-2014

 


TT Modified Date & Time


13/01/2014


15/01/2014 19:51


2-Nov-14


1-Jun-14


2-Nov-14


15/01/2014 19:57


1-Jun-14


13/01/2014 17:10


15/01/2014 19:47


18/01/2014 15:44

 

 

 

Description: Description: image001

Neeraj Chauhan

+91-9756706350

 



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

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

FORUM RULES

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

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

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

[Divaker Pandey]

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

Divaker


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

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

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

FORUM RULES

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

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

$$Excel-Macros$$ help required urgently

[Neeraj Chauhan]

Dear experts,

 

We have givne below date format how to convert right format of date like
13-Jan-2014

 


TT Modified Date & Time


13/01/2014


15/01/2014 19:51


2-Nov-14


1-Jun-14


2-Nov-14


15/01/2014 19:57


1-Jun-14


13/01/2014 17:10


15/01/2014 19:47


18/01/2014 15:44

 

 

 

Description: Description: image001

Neeraj Chauhan

+91-9756706350

 



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Copy data from multiple sheets into single sheet.

[Ashish Bhalara]

Dear Vallinayagam

This sheet are password protected so I can not see the coding of copy paste.
Kindly provide the coding or file containing without password.

Thanks
Ashish


On Thu, Mar 27, 2014 at 3:28 PM, Vallinayagam wrote:

> Hi,
>
> Attached file contains a macro which will be useful for you.
>
> Regards,
> Vallinayagam
>
>
> On Wednesday, March 26, 2014 11:47:01 PM UTC+5:30, jafna wrote:
>
>> Hello experts,
>>
>> Can any one explain the process that i subjected how to do in efficient
>> way, which will help us to reduce our copying time.
>>
>> Requirements,
>>
>> 1) Need data from more than 200 worksheet into one sheet,
>> 2) The combined data need in one format what i mentioned in sheet
>> Requirement.
>>
>> Many thanks in advance.
>>
>> Regards
>> Satiq
>> Kuwait
>>
>  --
> 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.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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

FORUM RULES

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

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

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

[Anand Shahane]

Priyanka pls find the formula
After subtracting the two dates
Day()*24+hour()*60+min()
On Mar 23, 2014 12:45 AM, "Abhishek Jain"  wrote:

> Yes, it will. As long as the dates and times are in correct format so as
> Excel reads them as values to allow subtraction, it will work. I just used
> simple subtraction and set the format show only minutes. See 'Format Cell'
> tab on the result for more clarity.
>
> Regards,
> Abhishek
>
>
> On Sat, Mar 22, 2014 at 9:02 PM, Priyanka Sachdeva <
> priyanka.sachdeva...@gmail.com> wrote:
>
>> Thanks a lot for the prompt response .. will give this a try
>>
>> 1 questions. Would this formula still work if the cell values are as below
>>
>> Inception Date = 02-12-2014  10:26:12 AM  (mm-dd-yyy  hr:mm:ss)
>>Closure Date = 02-12-2014  10:29:00 PM
>>
>> i.e it has a AM and PM instead of a 24 hour clock (eg 10:29:00 PM instead
>> of 22:29:00)
>>
>>
>> Regards,
>> Priyanka S
>>
>>
>> On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain wrote:
>>
>>> Please see attached.
>>>
>>> HTH
>>>
>>>
>>> On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva <
>>> priyanka.sachdeva...@gmail.com> wrote:
>>>
 Hello All,

 Am looking to calculate the difference in minutes between 2 dates. (
 Inception Date and Closure Date)

 Eg : Inception Date = 02-12-2014  10:26:12  (mm-dd-yyy  hr:mm:ss)
Closure Date = 02-12-2014  22:29:00


 I need a formula to calculate the difference in minutes i between these
 2 dates. have to do it for a bulk of records.

 Did go through a few earlier posts but could not find anything that
 would work. Hope some1 could help me with it

 Thanks in Advance !

 Regards,
 Priyanka S


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

 FORUM RULES

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

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

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

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

[Divaker Pandey]

please explain what is your purpose.

Divaker


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

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

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

FORUM RULES

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

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

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

[Divaker Pandey]

best way to calculate date difference.

using text function.

See in attached sheet.

Divaker


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

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

 Regards,
 Abhishek


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

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

RE: $$Excel-Macros$$ How to show numeric number larger than 20 digits in CSV file

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ram sharma
Sent: Thursday, March 27, 2014 11:17 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to show numeric number larger than 20 digits in 
CSV file

 

i have 20 digit number in my excel sheet, but when i move this number into 
another cell then it display in 9.71E+15 like this. i want to move this number 
using macro programming and display excatly number not 9.71E+15 value.
how i can do this?

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

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


moving long number as text.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[Priyanka Sachdeva]

Thanks All ! .. It worked


On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar wrote:

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

 1 questions. Would this formula still work if the cell values are as
 below

 Inception Date = 02-12-2014  10:26:12 AM  (mm-dd-yyy  hr:mm:ss)
Closure Date = 02-12-2014  10:29:00 PM

 i.e it has a AM and PM instead of a 24 hour clock (eg 10:29:00 PM
 instead of 22:29:00)


 Regards,
 Priyanka S


 On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain 
 wrote:

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