Re: $$Excel-Macros$$ Help Need for Vlookup Solution

[amar takale]

Hello Vabz
Thanks for Logic based on your criterion formula But Can you explain
it.What is  minus Row 5 & Row 10 logic.I cant Understand it.In my data
there are 9 column & 13 Row but it is different for different name as per.
I will use it but not work I use it & minus Row 8 in formula But formula
show NA.
Regards
Amar

On Wed, Sep 26, 2012 at 12:12 PM, Vabz  wrote:

> Hi
>
> Sorry for Late reply, I have defined some logic based on your crieterion,
> see it works or not..
>
> Rgds//vabs
>
>
> On Tuesday, September 25, 2012 5:43:07 PM UTC+5:30, amar takale wrote:
>
>> Need help.
>>
>> On Tue, Sep 25, 2012 at 2:38 PM, amar takale  wrote:
>>
>>> Hi Vabz
>>> I will try it but how to range criteria.Bcos after giving formula I used
>>> data validation for name.If I click Name Then all other criteria show inone
>>> shot.
>>>
>>>
>>> On Tue, Sep 25, 2012 at 12:00 PM, Vabz  wrote:
>>>
 Dear Amar

 You can use sumproduct for your query

 Rgds


 On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote:

> Pls find attached below file
>
> See Attached file.
>
> On Mon, Sep 24, 2012 at 6:43 PM, amar takale wrote:
>
>> Dear Group Members,
>>
>>
>>
>> Please Solution Need!
>>
>>
>>
>> I need to apply Vlookup+Match formula to get value in sheet1 (C5 to
>> F5) cell But it show same Output below.
>>
>>
>>
>>
>>
>> Sheet1 (C5 to F5) cell& Below cell is the result cell where I want
>> to use the formula to get the output from sheet2.
>>
>>
>>
>>
>>
>>  Best Regards,
>>
>> Amar
>>
>> --
>> Join official facebook page of this forum @ https://www.facebook.com/
>> **discu**ssexcel 
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.**com.
>>
>>
>>
>
>  --
 Join official facebook page of this forum @ https://www.facebook.com/**
 discussexcel 

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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



>>>
>>>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.

Re: $$Excel-Macros$$ Run-Time Error 3170

[wirelesscellularguy]

Hi Swapnil,

Thanks for the corrections. I implemented them.

I again need your help to pass the Start Date and End Date from the excel 
to Access Query(as we did for Enter Date & Enter Cell, before).

In the Criteria, I entered "Between [Start Date] And [End Date]" but 
couldn't figure out what the code would be in the vba.

Please help.

Regards,
Wireless

On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote:
>
> Hi,
>  
> I don't know exact reason for above error, because when I try to execute 
> code it is giving me error at following line:
> Set MyDatabase = DBEngine.OpenDatabase("C:\Database1.mdb")
>  
> But when I convert Database and Sample excel in 2003 format it is working 
> fine.
> Also note that query "DR" is wrong... it should be like:
>  
> SELECT [Drop Rate].Date, [Drop Rate].Cell, [Drop Rate].[Drop Rate]
> FROM [Drop Rate]
> WHERE [Drop Rate].Date=[Enter Date] and [Drop Rate].Cell = [Enter Cell];
> Pls find attached files for reference. Keep all files in one folder and 
> then run macro
>  
> *Note: 1. Database path is hardcoded in the macro.*
> * 2. I have convert excel link table ("Drop Rate") in local ms 
> access table and it is recommended that instaead of using excel link tables 
> use access tables. And if you want to use excel link table then before 
> running macro link excel table*
>  
> Regards,
>  
> Swapnil.
>
> On Fri, Sep 14, 2012 at 11:51 AM, wirelesscellularguy <
> wirelessc...@gmail.com > wrote:
>
>> Hi Swapnil,
>>
>> Many Thanks for replying. I have enclosed the relevant files.
>>
>> Regards,
>> Wireless
>>
>> On Friday, September 14, 2012 11:37:09 AM UTC+5:30, Swapnil Palande wrote:
>>
>>>  Hi,
>>>  
>>> Pls you provide sample files.
>>>  
>>> Regards,
>>>  
>>> Swapnil.
>>>
>>>  On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy <
>>> wirelessc...@gmail.com**> wrote:
>>>
  Hi All,

 I am trying to query my Access Database(Database1.accdb) through vba.
 I am getting run-time error 3170 at the highlighted line.

 Sub GetData()


 Dim MyDatabase As DAO.Database
 Dim MyQueryDef As DAO.QueryDef
 Dim MyRecordset As DAO.Recordset
 Dim i As Integer


 Set MyDatabase = DBEngine.OpenDatabase _
 ("D:\Documents and Settings\padmanad\Desktop\**Data**base1.accdb")
 Set MyQueryDef = MyDatabase.QueryDefs("DR")


 With MyQueryDef
 .Parameters("[Enter Date]") = Worksheets(1).Range("D3")

 .Parameters("[Enter Cell]") = Worksheets(1).Range("D4")
 End With


 Set MyRecordset = MyQueryDef.OpenRecordset
 'Step 5: Clear previous contents
 Sheets("Sheet1").Select
 ActiveSheet.Range("A1").**CopyFr**omRecordset MyRecordset


 For i = 1 To MyRecordset.Fields.Count
 ActiveSheet.Cells(2, i).Value = MyRecordset.Fields(i - 1).Name
 Next i

 MsgBox "Get Your Result In the Spreadsheet"

 End Sub

 Please help

 Regards,
 Wireless 

 -- 
 Join official facebook page of this forum @ https://www.facebook.com/**
 discussexcel 
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. 
 Forum owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@**
 googlegroups.com.
  
  

>>>
>>>  -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or 

Re: $$Excel-Macros$$ Run-Time Error 3170

[wirelesscellularguy]

Hi Swapnil,

With slight modification of the code, i could now pass the Start Date and 
the End Date

Regards,
Wireless

On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote:
>
> Hi,
>  
> I don't know exact reason for above error, because when I try to execute 
> code it is giving me error at following line:
> Set MyDatabase = DBEngine.OpenDatabase("C:\Database1.mdb")
>  
> But when I convert Database and Sample excel in 2003 format it is working 
> fine.
> Also note that query "DR" is wrong... it should be like:
>  
> SELECT [Drop Rate].Date, [Drop Rate].Cell, [Drop Rate].[Drop Rate]
> FROM [Drop Rate]
> WHERE [Drop Rate].Date=[Enter Date] and [Drop Rate].Cell = [Enter Cell];
> Pls find attached files for reference. Keep all files in one folder and 
> then run macro
>  
> *Note: 1. Database path is hardcoded in the macro.*
> * 2. I have convert excel link table ("Drop Rate") in local ms 
> access table and it is recommended that instaead of using excel link tables 
> use access tables. And if you want to use excel link table then before 
> running macro link excel table*
>  
> Regards,
>  
> Swapnil.
>
> On Fri, Sep 14, 2012 at 11:51 AM, wirelesscellularguy <
> wirelessc...@gmail.com > wrote:
>
>> Hi Swapnil,
>>
>> Many Thanks for replying. I have enclosed the relevant files.
>>
>> Regards,
>> Wireless
>>
>> On Friday, September 14, 2012 11:37:09 AM UTC+5:30, Swapnil Palande wrote:
>>
>>>  Hi,
>>>  
>>> Pls you provide sample files.
>>>  
>>> Regards,
>>>  
>>> Swapnil.
>>>
>>>  On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy <
>>> wirelessc...@gmail.com**> wrote:
>>>
  Hi All,

 I am trying to query my Access Database(Database1.accdb) through vba.
 I am getting run-time error 3170 at the highlighted line.

 Sub GetData()


 Dim MyDatabase As DAO.Database
 Dim MyQueryDef As DAO.QueryDef
 Dim MyRecordset As DAO.Recordset
 Dim i As Integer


 Set MyDatabase = DBEngine.OpenDatabase _
 ("D:\Documents and Settings\padmanad\Desktop\**Data**base1.accdb")
 Set MyQueryDef = MyDatabase.QueryDefs("DR")


 With MyQueryDef
 .Parameters("[Enter Date]") = Worksheets(1).Range("D3")

 .Parameters("[Enter Cell]") = Worksheets(1).Range("D4")
 End With


 Set MyRecordset = MyQueryDef.OpenRecordset
 'Step 5: Clear previous contents
 Sheets("Sheet1").Select
 ActiveSheet.Range("A1").**CopyFr**omRecordset MyRecordset


 For i = 1 To MyRecordset.Fields.Count
 ActiveSheet.Cells(2, i).Value = MyRecordset.Fields(i - 1).Name
 Next i

 MsgBox "Get Your Result In the Spreadsheet"

 End Sub

 Please help

 Regards,
 Wireless 

 -- 
 Join official facebook page of this forum @ https://www.facebook.com/**
 discussexcel 
  
 FORUM RULES (1120+ members already BANNED for violation)
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
  
 2) Don't post a question in the thread of another member.
  
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
  
 4) Acknowledge the responses you receive, good or bad.
  
 5) Cross-promotion of, or links to, forums competitive to this forum in 
 signatures are prohibited. 
  
 6) Jobs posting is not allowed.
  
 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
  
 NOTE : Don't ever post personal or confidential data in a workbook. 
 Forum owners and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@**
 googlegroups.com.
  
  

>>>
>>>  -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> 6) Jobs posting is not allowed.
>>  
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>  
>> NOTE : Don't ever post personal o

$$Excel-Macros$$ Macro running time

[Krishnaraddi V. Madolli]

Hi Experts,

Can anyone let me know how populate running time of macro.
Ex: If I run any macro, At the end of macro I should get how much time it took 
to complete macro.

Regards,

Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email: 
krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com
 |  The leader in innovative claims and productivity management solutions

Success is never permanent, Failure is never final, so always do not stop 
effort until your victory makes a history.
[http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please
 consider the environment before printing this message

"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


<>

Re: $$Excel-Macros$$ Run-Time Error 3170

[Swapnil Palande]

try below code:

 Between cdate('01/08/2012') And cdate('31/08/2012')"
regards,

swapnil.
On Wed, Sep 26, 2012 at 2:03 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:

> Hi Swapnil,
>
> With slight modification of the code, i could now pass the Start Date and
> the End Date
>
> Regards,
> Wireless
>
>
> On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote:
>
>> Hi,
>>
>>  I don't know exact reason for above error, because when I try to
>> execute code it is giving me error at following line:
>> Set MyDatabase = DBEngine.OpenDatabase("C:\**Database1.mdb")
>>
>> But when I convert Database and Sample excel in 2003 format it is working
>> fine.
>> Also note that query "DR" is wrong... it should be like:
>>
>> SELECT [Drop Rate].Date, [Drop Rate].Cell, [Drop Rate].[Drop Rate]
>> FROM [Drop Rate]
>> WHERE [Drop Rate].Date=[Enter Date] and [Drop Rate].Cell = [Enter Cell];
>> Pls find attached files for reference. Keep all files in one folder and
>> then run macro
>>
>> *Note: 1. Database path is hardcoded in the macro.*
>> * 2. I have convert excel link table ("Drop Rate") in local ms
>> access table and it is recommended that instaead of using excel link tables
>> use access tables. And if you want to use excel link table then before
>> running macro link excel table*
>>
>> Regards,
>>
>> Swapnil.
>>
>>  On Fri, Sep 14, 2012 at 11:51 AM, wirelesscellularguy <
>> wirelessc...@gmail.com**> wrote:
>>
>>> Hi Swapnil,
>>>
>>> Many Thanks for replying. I have enclosed the relevant files.
>>>
>>> Regards,
>>> Wireless
>>>
>>> On Friday, September 14, 2012 11:37:09 AM UTC+5:30, Swapnil Palande
>>> wrote:
>>>
  Hi,

 Pls you provide sample files.

 Regards,

 Swapnil.

  On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy <
 wirelessc...@gmail.com**> wrote:

>  Hi All,
>
> I am trying to query my Access Database(Database1.accdb) through vba.
> I am getting run-time error 3170 at the highlighted line.
>
> Sub GetData()
>
>
> Dim MyDatabase As DAO.Database
> Dim MyQueryDef As DAO.QueryDef
> Dim MyRecordset As DAO.Recordset
> Dim i As Integer
>
>
> Set MyDatabase = DBEngine.OpenDatabase _
> ("D:\Documents and Settings\padmanad\Desktop\**Database1.accdb")
> Set MyQueryDef = MyDatabase.QueryDefs("DR")
>
>
> With MyQueryDef
> .Parameters("[Enter Date]") = Worksheets(1).Range("D3")
>
> .Parameters("[Enter Cell]") = Worksheets(1).Range("D4")
> End With
>
>
> Set MyRecordset = MyQueryDef.OpenRecordset
> 'Step 5: Clear previous contents
> Sheets("Sheet1").Select
> ActiveSheet.Range("A1").**CopyFromRecordset MyRecordset
>
>
> For i = 1 To MyRecordset.Fields.Count
> ActiveSheet.Cells(2, i).Value = MyRecordset.Fields(i - 1).Name
> Next i
>
> MsgBox "Get Your Result In the Spreadsheet"
>
> End Sub
>
> Please help
>
> Regards,
> Wireless
>
> --
> Join official facebook page of this forum @ https://www.facebook.com/*
> *discu**ssexcel 
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to excel-macros...@**
> googlegroups.**com.
>
>
>

  --
>>> Join official facebook page of this forum @ https://www.facebook.com/**
>>> discussexcel 
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> m

Re: $$Excel-Macros$$ Macro running time

[Vabz]

Hi

Please refer following link for more details:

http://www.mrexcel.com/archive/VBA/20164.html 

Rgds//Vabs

On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V. 
Madolli wrote:
>
>  Hi Experts,
>
>  
>
> Can anyone let me know how populate running time of macro.
>
> Ex: If I run any macro, At the end of macro I should get how much time it 
> took to complete macro.
>
>  
>
> Regards,
>
>  
>
> Krishnaraddi V Madolli.
>
> Data Analytics Team
>
> Sedgwick Claims Management Services, Inc.
> Xchanging Towers, SJR iPark, 
>
> EPIP Area, Whitefield 
>
> Bangalore - 560 066. India.
>
> Direct Line: +1.800.920.9657 Extn 1915
>
> Switchboard: +90-(0)80-3054 Extn 1915
>
> Email: krishnaraddi.mado...@asia.xchanging.com  
>
> krishnaraddi.mado...@sedgwickcms.com 
>
> www.sedgwickcms.com|
>   
> *The leader in innovative claims and productivity management solutions*
>
>  
>
> Success is never permanent, Failure is never final, so always do not stop 
> effort until your victory makes a history.
>
> *[image: 
> http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]
> **Please consider the environment before printing this message***
>
>  
>  
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential 
> and may also be privileged. If you are not the intended recipient of this 
> e-mail you may not copy, forward, disclose or otherwise use it or any part 
> of it in any form whatsoever. If you are not the intended recipient please 
> telephone or e-mail the sender and delete this message and any attachment 
> from your system."
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ Macro running time

[Krishnaraddi V. Madolli]

Thanks, I got it.

Regards,

Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email: 
krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com
 |  The leader in innovative claims and productivity management solutions

Success is never permanent, Failure is never final, so always do not stop 
effort until your victory makes a history.
[http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please
 consider the environment before printing this message

From: Vabz [mailto:v...@vabs.in]
Sent: 09/26/2012 16:28
To: excel-macros@googlegroups.com
Cc: Krishnaraddi V. Madolli
Subject: Re: $$Excel-Macros$$ Macro running time

Hi

Please refer following link for more details:

http://www.mrexcel.com/archive/VBA/20164.html

Rgds//Vabs

On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V. Madolli 
wrote:
Hi Experts,

Can anyone let me know how populate running time of macro.
Ex: If I run any macro, At the end of macro I should get how much time it took 
to complete macro.

Regards,

Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email: krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com
 |  The leader in innovative claims and productivity management solutions

Success is never permanent, Failure is never final, so always do not stop 
effort until your victory makes a history.
Please consider the environment before printing this message


"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


<>

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

[Vabz]

HI

Inn short 5 & 10 is row no. in which Sam & Ram is written.

Rgds//Vabs


On Wednesday, September 26, 2012 1:31:47 PM UTC+5:30, amar takale wrote:
>
> Hello Vabz
> Thanks for Logic based on your criterion formula But Can you explain 
> it.What is  minus Row 5 & Row 10 logic.I cant Understand it.In my data 
> there are 9 column & 13 Row but it is different for different name as per.
> I will use it but not work I use it & minus Row 8 in formula But formula 
> show NA.
> Regards
> Amar
>
> On Wed, Sep 26, 2012 at 12:12 PM, Vabz > wrote:
>
>> Hi
>>
>> Sorry for Late reply, I have defined some logic based on your crieterion, 
>> see it works or not..
>>
>> Rgds//vabs
>>
>>
>> On Tuesday, September 25, 2012 5:43:07 PM UTC+5:30, amar takale wrote:
>>
>>> Need help.
>>>
>>> On Tue, Sep 25, 2012 at 2:38 PM, amar takale  wrote:
>>>
  Hi Vabz
 I will try it but how to range criteria.Bcos after giving formula I 
 used data validation for name.If I click Name Then all other criteria show 
 inone shot.


 On Tue, Sep 25, 2012 at 12:00 PM, Vabz  wrote:

> Dear Amar
>
> You can use sumproduct for your query
>
> Rgds
>
>
> On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote:
>
>> Pls find attached below file
>>
>> See Attached file.
>>
>> On Mon, Sep 24, 2012 at 6:43 PM, amar takale wrote:
>>
>>> Dear Group Members, 
>>>
>>>  
>>>
>>> Please Solution Need!
>>>
>>>  
>>>  
>>> I need to apply Vlookup+Match formula to get value in sheet1 (C5 to 
>>> F5) cell But it show same Output below.
>>>
>>>  
>>>
>>>  
>>>
>>> Sheet1 (C5 to F5) cell& Below cell is the result cell where I want 
>>> to use the formula to get the output from sheet2.
>>>
>>>  
>>>  
>>>  
>>>  
>>>  Best Regards,
>>>   
>>> Amar
>>>
>>> -- 
>>> Join official facebook page of this forum @ 
>>> https://www.facebook.com/**discu**ssexcel
>>>  
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>> Advice will not get quick attention or may not be answered.
>>>  
>>> 2) Don't post a question in the thread of another member.
>>>  
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>  
>>> 4) Acknowledge the responses you receive, good or bad.
>>>  
>>> 5) Cross-promotion of, or links to, forums competitive to this forum 
>>> in signatures are prohibited. 
>>>  
>>> 6) Jobs posting is not allowed.
>>>  
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
>>> allowed.
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.**com.
>>>  
>>>  
>>>
>>
>>  -- 
> Join official facebook page of this forum @ https://www.facebook.com/*
> *discussexcel 
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
> Advice will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum 
> in signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
> allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. 
> Forum owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google 
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to excel-macros...@**
> googlegroups.com.
>  
>  
>


>>>  -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for vi

RE: $$Excel-Macros$$ circular x axis in excel graph

[Rajan_Verma]

Nice


Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of David Grugeon
Sent: 26 September 2012 6:04
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ circular x axis in excel graph

See attachment for the sort of chart required.


Regards
David Grugeon


On 26 September 2012 10:22, David Grugeon  wrote:
> There is an explanation how to do it and a very useful sample workbook 
> download at this site
>
> http://www.ozgrid.com/Excel/polar-plot-chart.htm
>
>
> Regards
> David Grugeon
>
>
> On 26 September 2012 09:56, David Grugeon  wrote:
>> I do not know of a chat type in excel that does what you want 
>> directly. Since you only have 8 data points (360 is the same as 0 so 
>> can be ignored) you could do it by making 8 doughnut charts and 
>> putting them on top of each other.  Clunky, I know, but it is 
>> probably better than trying to plot the 8 points and join them each 
>> to 0,0 coordinate.  Turtle Graphics anyone?
>>
>> Regards
>> David Grugeon
>>
>>
>> On 26 September 2012 05:41, Sam Mathai Chacko  wrote:
>>> maybe you can draw a sample in paint and post it so that people 
>>> understand what exactly you are looking for in the chart.
>>>
>>>
>>> On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob 
>>> 
>>> wrote:

 Dear friends,
 this is my first query to this group i am having a data which may 
 be as follows
 anglestrength
 0  10
 45 20
 90 30
 13520
 1800
 22520
 27030
 31520
 36010

 the values under heading angle are in degrees i would like to plot 
 them in a graph such that the independent axis shows up on a circle 
 as angular location and strength value shows up as radial lines

 Please guide

 regards,
 christi jacob


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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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


>>>
>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>> --
>>> Join official facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>>> Need Advice will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum 
>>> in signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

3) Don't 

RE: $$Excel-Macros$$ Hiiiiiiiiiii

[Rajan_Verma]

 

 

You can visit here

 

http://excelpoweruser.wordpress.com/2011/07/20/embaded-flash-object-in-excel
/

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 26 September 2012 11:15
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hiii

 

Can you explain next steps after click Shockwave Flash Object'.Then how to
create programme in that flash
Yours cricket file no see I dont no what is problem.

On Wed, Sep 26, 2012 at 10:44 AM, SAGAR KASANGOTTUWAR
 wrote:

Can you please explain the process for excel 2007 /2010..

 

 

Thanks in Advance;

 

Sagar

On Wed, Sep 26, 2012 at 9:33 AM, Ms-Exl-Learner . 
wrote:

No Need To Get Surprised

You can create a lot more like this by just adding the any flash files in
your excel worksheet.

I have created a Flash cricket in excel for you and the step by step guide
for creating the same is given below for your reference.

Method:-

***

Using Office XP, Excel or Word (New Workbook)

 

>From the 'View' menu select 'Toolbars' and tick the 'Control Toolbox'

 

On the 'Control Toolbox' toolbar click on the 'More controls' icon

 

A list of controls will be displayed. Scroll down until you find the
'Shockwave Flash Object' and then click on it.

 

Excel

This should change your cursor to a crosshair. Move to the area on the
worksheet where you want to inset the 'Shockwave Flash Object'.

Left click, hold and drag to create a box of the required size.

 

Word

Word will automatically insert the control where the cursor is.

It's size can be set by dragging the edges or via it's 'Properties'

 

Next right click on the control you have just inserted and select
'Properties'.

 

Set the following properties

 

* Autoload = True

* EmbedMovie = True

* Enabled = True

* Loop = True

* Playing = True

* Visible = True

* Movie = c:\flash.swf (Change this to the location of your .swf file)

 

Close the 'Properties' control

 

Save the file.

 

Close the file.

 

Reopen the file.

 

The .swf file should start playing automatically.


Hope that helps!
.
<><><><><><>
Ms.Exl.Learner
<><><><><><>


--

 

On Tue, Sep 25, 2012 at 1:23 PM, Vabz  wrote:

Thanks for sharing..

 

Rgds//



On Tuesday, September 25, 2012 11:49:32 AM UTC+5:30, Amit Desai (MERU)
wrote:

Well thanks.. thats not mine.. it was aforwarded file, which I think so good
for group.

 

Infact I have an inspiration to learn this..

 

Best Regards,

Amit

 

From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] On
Behalf Of NOORAIN ANSARI


Sent: 25 September 2012 11:39

To: excel-...@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hiii

 

Excellent Creativity Amit.

On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) 
wrote:

To all my dear friends,

 

Nice Excel filewith ABCD on Friendship...

Please see the attachment and click on flowers.

Best Regards,

Amit

 

  _  

Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACR

$$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

[Matty]

I need to sum up a range of data based on multiple criteria using only the 
first number in a date string.  For example I have a range of data I have 
to sum attached to specific dates.  I need to sum the total product for the 
month and I am trying to base that criteria on the first number in the date 
line.  The LEFT function came to mind but that seems to be for text only 
and returns an error value.  I don't want to have to use a different 
formula for each date range.  I need something that is going to recognize 
that first number in the range and sum accordingly as the number of 
dates is inconsistent.  

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

[Rajan_Verma]

Would be good  if you provide a sample file 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Matty
Sent: 26 September 2012 8:07
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help
Needed

 

I need to sum up a range of data based on multiple criteria using only the
first number in a date string.  For example I have a range of data I have to
sum attached to specific dates.  I need to sum the total product for the
month and I am trying to base that criteria on the first number in the date
line.  The LEFT function came to mind but that seems to be for text only and
returns an error value.  I don't want to have to use a different formula for
each date range.  I need something that is going to recognize that first
number in the range and sum accordingly as the number of dates is
inconsistent.  

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: Calculated Field not Working

[SG]

any update plz...
plz help me to understand this.
On Monday, September 24, 2012 9:06:59 PM UTC+5:30, SG wrote:

> hi Vabz,
>  
> Still i'm not able to find the difference.Though i have also used the same 
> formula in calculated field in my sheet.
> Plz let me know...so that i would be able to help it in other sheets.
>
> On Thursday, September 20, 2012 6:59:33 PM UTC+5:30, Vabz wrote:
>
>> Hi, 
>>
>> Just use formula insert field button to define formula.. thats it.
>>
>> There was error in formula given by me & was working well in chetan's 
>> file.
>>
>> Rgds//Vabs
>>
>> On Thursday, September 20, 2012 6:54:45 PM UTC+5:30, SG wrote: 
>>>
>>> hi Chetan/vabz
>>>  
>>> thanks for the help. I got the solutions.plz explain what you have done 
>>> to get the ans.
>>> i don't know that whose file is this which gave me ans.
>>> plz explain.
>>>
>>> On Wednesday, September 19, 2012 11:42:14 PM UTC+5:30, Chethan wrote:
>>>
 check..if these help. check and let me know
  
 Regards
 CK

 On Wed, Sep 19, 2012 at 2:45 PM, SG  wrote:

> Experts,
>  
> plz help mei need solution.plz look in to this 
>
> On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote:
>
>> Hi Experts,
>>  
>> I'm again in to a problem whic is silly but still i can't make it.I 
>> calculate the scores for individuals seperately but this time i want to 
>> make all under one table.For this, i have created a pivot table & for 
>> Calculating the Score, I have used Calculated field which is not giving 
>> me 
>> the right ans.I'm attaching the sheet.Plz look in to this.I have 
>> highlighted the column for which i nedd your help.
>>  
>> thanks in advance
>>
> -- 
> Join official facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
> Advice will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum 
> in signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
> allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. 
> Forum owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google 
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com.
>  
>  
>



 -- 

 Chethan



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

[Matty]

Here it is.  I hope this helps.  Using Sheet 2 for the source data to 
display on Sheet 1.  I believe I got as far as I could with the function 
but also believe it will show you what I am trying to do.  I tried using 
the LEFT function but can't figure out a way to make it work.  I am trying 
to sum the data for individual days into a month.  Thanks!
 
 
 

On Wednesday, September 26, 2012 11:19:24 AM UTC-4, Rajan_Verma wrote:

>  *Would be good  if you provide a sample file *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Matty
> *Sent:* 26 September 2012 8:07
> *To:* excel-...@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Sumif Based on First Number of a Date Range 
> Help Needed
>
>  
>  
> I need to sum up a range of data based on multiple criteria using only the 
> first number in a date string.  For example I have a range of data I have 
> to sum attached to specific dates.  I need to sum the total product for the 
> month and I am trying to base that criteria on the first number in the date 
> line.  The LEFT function came to mind but that seems to be for text only 
> and returns an error value.  I don't want to have to use a different 
> formula for each date range.  I need something that is going to recognize 
> that first number in the range and sum accordingly as the number of 
> dates is inconsistent.  
>
> -- 
> Join official facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
>  
>  
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




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

$$Excel-Macros$$ Urgent required IBM Websphere MQ Consultant - NewYork city

[Gurjan Singh]

*Position:*IBM Websphere MQ Consultant
*Location: *New York city
*Duration:*Long term


*Responsibilities *


1. IBM Websphere MQ Series administration and system experience is a must
2. Wide hands-on project experience with MQ Series and Message Broker
administration and system on Windows 2003 servers/Linux is a must
3. Must have hands-on experience installing and configuring Microsoft
Windows Clusters
4. Must have hands-on experience installing and configuring MQ Clusters
5. Must have hands-on experience installing and configuring Message Broker
v 6.x
6. Must have hands-on experience installing and configuring with Omegamon
7. Minimum of 7 years experience in MQ Series Administration and some
applications development/support within a large organization
8. Experienced in administration and support of transaction processing
systems
9. Must have experience working with Oracle, SQL, DB2 and other major
database platforms
10. Experienced in Message Oriented Middleware (MOM) implementation and
operation
11. Experience supporting an application software development group during
development project cycles and after deployment
12. Knowledge of C, Java, JMS is helpful, in so far as to be able to
support developers who use those languages and to develop small support
applications to streamline day to day operations
13. Must be able to work on projects that extend MQ Series infrastructure,
MQ Clustering, SSL channels support, Publish/Subscribe, etc.
14. Strong experience in supporting enterprise business critical messaging
through a high available MQSI / MQ Series architecture which exploits MQ
Series clustering and queue sharing
15. Must be fully competent to work under general direction on complex
projects usually on specific assigned projects, issues and problems.
Several projects will usually be active at the same time, so the ability to
multitask is essential to success for this position
16. Strong experience in performing and supporting problem determination
and resolution, production changes, and maintenance following Problem and
Change Management processes
17. Ability to gain awareness of business or function, for which
application is designed, is important
18. Strong experience with MQ Series Workflow admin production support
19. Must have experience configuring and securing communication channels
between internal and external server resources.
20. Must have experience installing, configuring, and troubleshooting
WebSphere Service Registry and Repository (WSRR)
21. Must have the ability to produce and provide documentation and mentor
existing staff
22. Networking concepts, TCP/IP is desired
23. Excellent verbal and written communications skills are a must.



-- 
*--
Thanks & Regards

Garry
HMG America LLC
PH: 732-645-2086
E:g...@hmgamerica.com
http://www.hmgamerica.com/*

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Urgent required L2 Support Network Engineer - Redmond, WA

[Gurjan Singh]

-- Forwarded message --
From: Gurjan Singh 
Date: Wed, Sep 26, 2012 at 9:49 PM
Subject: Urgent required L2 Support Network Engineer - Redmond, WA
To: g...@hmgamerica.com, Gurjan Singh 


*Position: *L2 Support Network Engineer

* Location: *Redmond, WA, **

*Duration: *6 months, CTH**


* *

*Requirements:*

· Minimum of a CCNP (or equivalent) Certification with at least 5
years’ experience and Above 4 years’ experience on Cisco switches and
routers in a large scale, highly available operational data network.

· Strong understanding of TCP/IP

· Experience administering and troubleshooting F5, Cisco, Juniper
and Citrix load-balancers

· Solid understanding of Layer2 and Layer3 traffic forwarding

· Expert in Cisco device configuration.

· Solid Understanding of MPLS, L3VPNs and VRFs

· Working knowledge of BGP, OSPF,STP, HSRP, CDP, UDLD.

· Proven troubleshooting and event correlation skills.

· Strong analytical skills

· Working experience of security fundamentals

· Understanding of Network Management practices, procedures and
tools



Others :



· Strong interpersonal communication skills

· Working knowledge of packet capture and analysis tools ( is a big
plus )

· Strong verbal and written communication skills

· Capable of managing time and priorities with little direction

· Understanding of ITIL framework

· Team player with a constructive perspective, committed to the
success of the organization






-- 
*--
Thanks & Regards

Garry
HMG America LLC
PH: 732-645-2086
E:g...@hmgamerica.com
http://www.hmgamerica.com/*

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

[Rajan_Verma]

Hi

Use this

See the attached

 

=SUMPRODUCT(N(MONTH(Sheet1!$A$3:$A$122)=MONTH(Sheet2!$A6&1))*OFFSET(INDEX(Sh
eet1!$B$2:$R$121,,MATCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4),
0)),1,,,SUM(N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Matty
Sent: 26 September 2012 9:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range
Help Needed

 

Here it is.  I hope this helps.  Using Sheet 2 for the source data to
display on Sheet 1.  I believe I got as far as I could with the function but
also believe it will show you what I am trying to do.  I tried using the
LEFT function but can't figure out a way to make it work.  I am trying to
sum the data for individual days into a month.  Thanks!

 

 

 


On Wednesday, September 26, 2012 11:19:24 AM UTC-4, Rajan_Verma wrote:

Would be good  if you provide a sample file 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-...@googlegroups.com 
[mailto:excel-...@googlegroups.com  ] On Behalf Of Matty
Sent: 26 September 2012 8:07
To: excel-...@googlegroups.com  
Subject: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help
Needed

 

I need to sum up a range of data based on multiple criteria using only the
first number in a date string.  For example I have a range of data I have to
sum attached to specific dates.  I need to sum the total product for the
month and I am trying to base that criteria on the first number in the date
line.  The LEFT function came to mind but that seems to be for text only and
returns an error value.  I don't want to have to use a different formula for
each date range.  I need something that is going to recognize that first
number in the range and sum accordingly as the number of dates is
inconsistent.  

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-...@googlegroups.com
 .
To unsubscribe from this group, send email to
excel-macros...@googlegroups.com  .
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not al

$$Excel-Macros$$ Re: If data validation removed! possible.

[Vabz]

Hi,
 
Yes you can do that..
 
Rgds//Vabs

On Wednesday, September 26, 2012 5:27:23 PM UTC+5:30, Mohammed Muneer wrote:

>   Dear Ashish,
>  
>  
>  
>  
>  
> Can we run the same formula without validation by manual entry into the 
> cells, F5-G5-H5.
>  
>  
>  
>  
>  
> Please help needed again with small correction in the previous copy.
>  
>  
>  
>  
>  
>  
>  
> Regards,
>  
> Muneer,
>  
> CC.
>   

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ circular x axis in excel graph

[Christi Jacob]

Hello Rajan,
the result is close to the requirement although it looks like the radar has
been rotated by some angle.
thanks

can the graph be modified for angles which are not evenly spaced
(ie in the example the angles are spaced 45deg apart. in actual case the
first angle might be 25deg followed by 65 deg followed by 90deg...)

regards,
christi jacob

On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma wrote:

>  *Hi*
>
> * *
>
> *Not exactly same.. but I made something  **J***
>
> * *
>
> *See the attached *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Christi Jacob
> *Sent:* 26 September 2012 7:09
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ circular x axis in excel graph
>
> ** **
>
> Dear friends,
>
> i am attaching a image file of the expected graph
>
> note: instead of radial line i actually require a curve through the points
> as shown in the image file (   :(   )
>
>  
>
> also the number of data points may be 8, 10, 20 etc in various cases
>
> hence if it is possible to automate it it will be good
>
>  
>
> thanks
>
> christi jacob
>
> On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon 
> wrote:
>
> See attachment for the sort of chart required.
>
>
> Regards
> David Grugeon
>
>
>
> On 26 September 2012 10:22, David Grugeon  wrote:
> > There is an explanation how to do it and a very useful sample workbook
> > download at this site
> >
> > http://www.ozgrid.com/Excel/polar-plot-chart.htm
> >
> >
> > Regards
> > David Grugeon
> >
> >
> > On 26 September 2012 09:56, David Grugeon  wrote:
> >> I do not know of a chat type in excel that does what you want
> >> directly. Since you only have 8 data points (360 is the same as 0 so
> >> can be ignored) you could do it by making 8 doughnut charts and
> >> putting them on top of each other.  Clunky, I know, but it is probably
> >> better than trying to plot the 8 points and join them each to 0,0
> >> coordinate.  Turtle Graphics anyone?
> >>
> >> Regards
> >> David Grugeon
> >>
> >>
> >> On 26 September 2012 05:41, Sam Mathai Chacko 
> wrote:
> >>> maybe you can draw a sample in paint and post it so that people
> understand
> >>> what exactly you are looking for in the chart.
> >>>
> >>>
> >>> On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob <
> christi.ja...@gmail.com>
> >>> wrote:
> 
>  Dear friends,
>  this is my first query to this group
>  i am having a data which may be as follows
>  anglestrength
>  0  10
>  45 20
>  90 30
>  13520
>  1800
>  22520
>  27030
>  31520
>  36010
> 
>  the values under heading angle are in degrees
>  i would like to plot them in a graph such that the independent axis
> shows
>  up on a circle as angular location and strength value shows up as
> radial
>  lines
> 
>  Please guide
> 
>  regards,
>  christi jacob
> 
> 
>  --
>  Join official facebook page of this forum @
>  https://www.facebook.com/discussexcel
> 
>  FORUM RULES (1120+ members already BANNED for violation)
> 
>  1) Use concise, accurate thread titles. Poor thread titles, like
> Please
>  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will
>  not get quick attention or may not be answered.
> 
>  2) Don't post a question in the thread of another member.
> 
>  3) Don't post questions regarding breaking or bypassing any security
>  measure.
> 
>  4) Acknowledge the responses you receive, good or bad.
> 
>  5) Cross-promotion of, or links to, forums competitive to this forum
> in
>  signatures are prohibited.
> 
>  6) Jobs posting is not allowed.
> 
>  7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
> 
>  NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
>  owners and members are not responsible for any loss.
>  ---
>  You received this message because you are subscribed to the Google
> Groups
>  "MS EXCEL AND VBA MACROS" group.
>  To post to this group, send email to excel-macros@googlegroups.com.
>  To unsubscribe from this group, send email to
>  excel-macros+unsubscr...@googlegroups.com.
> 
> 
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>> Sam Mathai Chacko
> >>>
> >>> --
> >>> Join official facebook page of this forum @
> >>> https://www.facebook.com/discussexcel
> >>>
> >>> FORUM RULES (1120+ members already BANNED for violation)
> >>>
> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will
> >>> not get quick attention or may not be answered.
> >>>
> >>> 2) Don't post

$$Excel-Macros$$ Re: Urgent required IBM Websphere MQ Consultant - NewYork city

[Vabz]

Job posting is prohibited, can we ban him..
 

On Wednesday, September 26, 2012 9:15:46 PM UTC+5:30, Gurjan Singh wrote:

> *Position:*IBM Websphere MQ Consultant
> *Location: *New York city
> *Duration:*Long term
>
>
> *Responsibilities *
>
>
> 1. IBM Websphere MQ Series administration and system experience is a must 
> 2. Wide hands-on project experience with MQ Series and Message Broker 
> administration and system on Windows 2003 servers/Linux is a must 
> 3. Must have hands-on experience installing and configuring Microsoft 
> Windows Clusters 
> 4. Must have hands-on experience installing and configuring MQ Clusters 
> 5. Must have hands-on experience installing and configuring Message Broker 
> v 6.x 
> 6. Must have hands-on experience installing and configuring with Omegamon 
> 7. Minimum of 7 years experience in MQ Series Administration and some 
> applications development/support within a large organization 
> 8. Experienced in administration and support of transaction processing 
> systems 
> 9. Must have experience working with Oracle, SQL, DB2 and other major 
> database platforms 
> 10. Experienced in Message Oriented Middleware (MOM) implementation and 
> operation 
> 11. Experience supporting an application software development group during 
> development project cycles and after deployment 
> 12. Knowledge of C, Java, JMS is helpful, in so far as to be able to 
> support developers who use those languages and to develop small support 
> applications to streamline day to day operations 
> 13. Must be able to work on projects that extend MQ Series infrastructure, 
> MQ Clustering, SSL channels support, Publish/Subscribe, etc. 
> 14. Strong experience in supporting enterprise business critical messaging 
> through a high available MQSI / MQ Series architecture which exploits MQ 
> Series clustering and queue sharing 
> 15. Must be fully competent to work under general direction on complex 
> projects usually on specific assigned projects, issues and problems. 
> Several projects will usually be active at the same time, so the ability to 
> multitask is essential to success for this position 
> 16. Strong experience in performing and supporting problem determination 
> and resolution, production changes, and maintenance following Problem and 
> Change Management processes 
> 17. Ability to gain awareness of business or function, for which 
> application is designed, is important 
> 18. Strong experience with MQ Series Workflow admin production support 
> 19. Must have experience configuring and securing communication channels 
> between internal and external server resources. 
> 20. Must have experience installing, configuring, and troubleshooting 
> WebSphere Service Registry and Repository (WSRR) 
> 21. Must have the ability to produce and provide documentation and mentor 
> existing staff 
> 22. Networking concepts, TCP/IP is desired 
> 23. Excellent verbal and written communications skills are a must.
>
>
>
> -- 
> *--
> Thanks & Regards
>
> Garry
> HMG America LLC
> PH: 732-645-2086
> E:g...@hmgamerica.com 
> http://www.hmgamerica.com/*
>
>
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Re: Urgent required L2 Support Network Engineer - Redmond, WA

[Vabz]

Job posting is prohibited, can we ban him..
 

On Wednesday, September 26, 2012 9:51:29 PM UTC+5:30, Gurjan Singh wrote:

>
>
> -- Forwarded message --
> From: Gurjan Singh >
> Date: Wed, Sep 26, 2012 at 9:49 PM
> Subject: Urgent required L2 Support Network Engineer - Redmond, WA
> To: ga...@hmgamerica.com , Gurjan Singh 
> 
> >
>
>
> *Position: *L2 Support Network Engineer
>
> * Location: *Redmond, WA, **
>
> *Duration: *6 months, CTH**
>
>
> * *
>
> *Requirements:*
>
> · Minimum of a CCNP (or equivalent) Certification with at least 5 
> years’ experience and Above 4 years’ experience on Cisco switches and 
> routers in a large scale, highly available operational data network.
>
> · Strong understanding of TCP/IP
>
> · Experience administering and troubleshooting F5, Cisco, Juniper 
> and Citrix load-balancers
>
> · Solid understanding of Layer2 and Layer3 traffic forwarding
>
> · Expert in Cisco device configuration.
>
> · Solid Understanding of MPLS, L3VPNs and VRFs
>
> · Working knowledge of BGP, OSPF,STP, HSRP, CDP, UDLD.
>
> · Proven troubleshooting and event correlation skills.
>
> · Strong analytical skills
>
> · Working experience of security fundamentals
>
> · Understanding of Network Management practices, procedures and 
> tools
>
>  
>
> Others :
>
>  
>
> · Strong interpersonal communication skills
>
> · Working knowledge of packet capture and analysis tools ( is a 
> big plus )
>
> · Strong verbal and written communication skills
>
> · Capable of managing time and priorities with little direction
>
> · Understanding of ITIL framework
>
> · Team player with a constructive perspective, committed to the 
> success of the organization
>
>  
>
>  
>
>
> -- 
> *--
> Thanks & Regards
>
> Garry
> HMG America LLC
> PH: 732-645-2086
> E:g...@hmgamerica.com 
> http://www.hmgamerica.com/*
>
>
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

[Matty]

Genius!  Thank you so much!  
 

On Wednesday, September 26, 2012 12:31:04 PM UTC-4, Rajan_Verma wrote:

>  *Hi*
>
> *Use this*
>
> *See the attached*
>
> * *
>
> *
> =SUMPRODUCT(N(MONTH(Sheet1!$A$3:$A$122)=MONTH(Sheet2!$A6&1))*OFFSET(INDEX(Sheet1!$B$2:$R$121,,MATCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4),0)),1,,,SUM(N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4
> *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Matty
> *Sent:* 26 September 2012 9:07
> *To:* excel-...@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ Sumif Based on First Number of a Date 
> Range Help Needed
>
>  
>  
> Here it is.  I hope this helps.  Using Sheet 2 for the source data to 
> display on Sheet 1.  I believe I got as far as I could with the function 
> but also believe it will show you what I am trying to do.  I tried using 
> the LEFT function but can't figure out a way to make it work.  I am trying 
> to sum the data for individual days into a month.  Thanks!
>  
>  
>  
>  
>  
>  
>  
>
> On Wednesday, September 26, 2012 11:19:24 AM UTC-4, Rajan_Verma wrote:
>
>  *Would be good  if you provide a sample file *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On 
> Behalf Of *Matty
> *Sent:* 26 September 2012 8:07
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sumif Based on First Number of a Date Range 
> Help Needed
>
>  
>  
> I need to sum up a range of data based on multiple criteria using only the 
> first number in a date string.  For example I have a range of data I have 
> to sum attached to specific dates.  I need to sum the total product for the 
> month and I am trying to base that criteria on the first number in the date 
> line.  The LEFT function came to mind but that seems to be for text only 
> and returns an error value.  I don't want to have to use a different 
> formula for each date range.  I need something that is going to recognize 
> that first number in the range and sum accordingly as the number of 
> dates is inconsistent.  
>
> -- 
> Join official facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com.
>  
>  
>
> -- 
> Join official facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES (1120+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> 6) Jobs posting is not allowed.
>  
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
>  
>  
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

$$Excel-Macros$$ Urgent required MS Access Developer - METRO AREA,DC

[Gurjan Singh]

One of our client is looking for a MS Access Developer

The description is:

Build an Access DB that will collect and report Mortgage Servicing
information.
Skill level:

Senior (7+ yrs)


Skills:
- Experience Connecting with external Sybase/Oracle databases
- EXTENSIVE MS Access Development
- Web-enabled UI
- Security (User ID/Role, RO UI, Lock tables)
- Activity logging
- SQL optimization, subquery, correlated query




-- 
*--
Thanks & Regards

Garry
HMG America LLC
PH: 732-645-2086
E:g...@hmgamerica.com
http://www.hmgamerica.com/*

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ circular x axis in excel graph

[David Grugeon]

I think you can make a list of all 360 points and leave those without data blank
Regards
David Grugeon


On 27 September 2012 03:03, Christi Jacob  wrote:
> Hello Rajan,
> the result is close to the requirement although it looks like the radar has
> been rotated by some angle.
> thanks
>
> can the graph be modified for angles which are not evenly spaced
> (ie in the example the angles are spaced 45deg apart. in actual case the
> first angle might be 25deg followed by 65 deg followed by 90deg...)
>
> regards,
> christi jacob
>
> On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma 
> wrote:
>>
>> Hi
>>
>>
>>
>> Not exactly same.. but I made something  J
>>
>>
>>
>> See the attached
>>
>>
>>
>>
>>
>> Regards
>>
>> Rajan verma
>>
>> +91 7838100659 [IM-Gtalk]
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Christi Jacob
>> Sent: 26 September 2012 7:09
>>
>>
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ circular x axis in excel graph
>>
>>
>>
>> Dear friends,
>>
>> i am attaching a image file of the expected graph
>>
>> note: instead of radial line i actually require a curve through the points
>> as shown in the image file (   :(   )
>>
>>
>>
>> also the number of data points may be 8, 10, 20 etc in various cases
>>
>> hence if it is possible to automate it it will be good
>>
>>
>>
>> thanks
>>
>> christi jacob
>>
>> On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon 
>> wrote:
>>
>> See attachment for the sort of chart required.
>>
>>
>> Regards
>> David Grugeon
>>
>>
>>
>> On 26 September 2012 10:22, David Grugeon  wrote:
>> > There is an explanation how to do it and a very useful sample workbook
>> > download at this site
>> >
>> > http://www.ozgrid.com/Excel/polar-plot-chart.htm
>> >
>> >
>> > Regards
>> > David Grugeon
>> >
>> >
>> > On 26 September 2012 09:56, David Grugeon  wrote:
>> >> I do not know of a chat type in excel that does what you want
>> >> directly. Since you only have 8 data points (360 is the same as 0 so
>> >> can be ignored) you could do it by making 8 doughnut charts and
>> >> putting them on top of each other.  Clunky, I know, but it is probably
>> >> better than trying to plot the 8 points and join them each to 0,0
>> >> coordinate.  Turtle Graphics anyone?
>> >>
>> >> Regards
>> >> David Grugeon
>> >>
>> >>
>> >> On 26 September 2012 05:41, Sam Mathai Chacko 
>> >> wrote:
>> >>> maybe you can draw a sample in paint and post it so that people
>> >>> understand
>> >>> what exactly you are looking for in the chart.
>> >>>
>> >>>
>> >>> On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob
>> >>> 
>> >>> wrote:
>> 
>>  Dear friends,
>>  this is my first query to this group
>>  i am having a data which may be as follows
>>  anglestrength
>>  0  10
>>  45 20
>>  90 30
>>  13520
>>  1800
>>  22520
>>  27030
>>  31520
>>  36010
>> 
>>  the values under heading angle are in degrees
>>  i would like to plot them in a graph such that the independent axis
>>  shows
>>  up on a circle as angular location and strength value shows up as
>>  radial
>>  lines
>> 
>>  Please guide
>> 
>>  regards,
>>  christi jacob
>> 
>> 
>>  --
>>  Join official facebook page of this forum @
>>  https://www.facebook.com/discussexcel
>> 
>>  FORUM RULES (1120+ members already BANNED for violation)
>> 
>>  1) Use concise, accurate thread titles. Poor thread titles, like
>>  Please
>>  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>  Advice will
>>  not get quick attention or may not be answered.
>> 
>>  2) Don't post a question in the thread of another member.
>> 
>>  3) Don't post questions regarding breaking or bypassing any security
>>  measure.
>> 
>>  4) Acknowledge the responses you receive, good or bad.
>> 
>>  5) Cross-promotion of, or links to, forums competitive to this forum
>>  in
>>  signatures are prohibited.
>> 
>>  6) Jobs posting is not allowed.
>> 
>>  7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>  allowed.
>> 
>>  NOTE : Don't ever post personal or confidential data in a workbook.
>>  Forum
>>  owners and members are not responsible for any loss.
>>  ---
>>  You received this message because you are subscribed to the Google
>>  Groups
>>  "MS EXCEL AND VBA MACROS" group.
>>  To post to this group, send email to excel-macros@googlegroups.com.
>>  To unsubscribe from this group, send email to
>>  excel-macros+unsubscr...@googlegroups.com.
>> 
>> 
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> Sam Mathai Chacko
>> >>>
>> >>> --
>> >>> Join official facebook page of this forum @
>> >>> https://www.facebook.com/discussexcel
>> >>>
>> >>> FORUM RULES (1120+ members 

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

[Indrajit $nai]

*@ Krishna, Sir I'm waiting for your reply. :)*


On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai wrote:

> *@ Krishna, thanks for the reply, It working now, but some issue;*
> *
> *
> *1. Through this Master file I'm able to create the slave files, but it's
> not opening, showing an error "invalid format".*
> *2. If the file is created before, then the data is saving in those slave
> files, which is ok.*
> *3. In the Master file "Batch Assign to" and "Batch Status" is not
> updating after assigning any Batch to the slave file.*
> *
> *
> *You have done a lot for me; please do a little more; then this will be a
> perfect tool to work with.*
> *
> *
> *Thanks & Regards*
> *Indrajit*
> *
> *
> *
> *
> On Tue, Sep 25, 2012 at 10:35 PM, Krishna Kumar wrote:
>
>> Remove any missing libraries via Tool > References in the VBE window.
>>
>> Also keep red lines in single line rather than multiple lines
>>
>> Kris
>>
>>
>> On Tue, Sep 25, 2012 at 7:12 PM, Indrajit $nai 
>> wrote:
>> > @Krishna, thanks for the solution, but one problem is there, when I'm
>> using
>> > the below mention code I'm getting an error.
>> >
>> > PFA the error snapshot.
>> >
>> > Waiting for your reply.
>> >
>> >
>> > Thanks & Regards,
>> > Indrajit
>> >
>> > Disclaimer:
>> > This electronic message and any files transmitted with it are
>> confidential
>> > and intended solely for the use of the individual or entity to whom
>> they are
>> > addressed. If you are not the intended recipient you are hereby notified
>> > that any disclosure, copying, distribution or taking any action in
>> reliance
>> > on the contents of this information is strictly prohibited and may be
>> > unlawful.
>> >
>> >
>> >
>> > On Mon, Sep 24, 2012 at 5:49 PM, Krishna Kumar 
>> > wrote:
>> >>
>> >> Hi
>> >>
>> >> Put this code in Userform module.
>> >>
>> >> Dim wbkActive As Workbook
>> >> Private Sub CommandButton1_Click()
>> >>
>> >> Dim FilePathAs String
>> >> Dim FileNameAs String
>> >> Dim wbkOpen As Workbook
>> >> Dim LastRow As Long
>> >>
>> >> If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook
>> >>
>> >> FilePath = wbkActive.Worksheets(1).[i1]
>> >> If Right(FilePath, 1) <> "\" Then FilePath = FilePath & "\"
>> >>
>> >> If Len(Me.TextBox1.Value) Then
>> >> If Len(Me.TextBox2.Value) Then
>> >> If Len(Me.TextBox3.Value) Then
>> >> FileName = FilePath & Me.TextBox3.Value & ".xlsx"
>> >> If Not FileIsOpen(FileName) Then
>> >> Set wbkOpen = Workbooks.Open(FilePath &
>> >> Me.TextBox3.Value & ".xlsx")
>> >> With wbkOpen.Worksheets(1)
>> >> LastRow = .Range("b" & .Rows.Count).End(3).Row
>> + 1
>> >> .Range("a" & LastRow) = LastRow - 3
>> >> .Range("b" & LastRow).Resize(, 3) =
>> >> Split(Me.TextBox2.Value & "," & Me.TextBox1.Value & "," &
>> >> Me.TextBox3.Value, ",")
>> >> End With
>> >> wbkOpen.Close 1
>> >> Set wbkOpen = Nothing
>> >> MsgBox "Done", , "ExcelFox.com"
>> >> Unload Me
>> >> Else
>> >> MsgBox "Workbook '" & FileName & "' is already
>> >> opened." & vbLf & "Close the workbook and try again", vbInformation,
>> >> "ExcelFox.com"
>> >> Exit Sub
>> >> End If
>> >> Else
>> >> MsgBox "Emp ID is missing", vbInformation,
>> "ExcelFox.com"
>> >> Me.TextBox3.SetFocus
>> >> End If
>> >> Else
>> >> MsgBox "Batch No is missing", vbInformation, "ExcelFox.com"
>> >> Me.TextBox2.SetFocus
>> >> End If
>> >> Else
>> >> MsgBox "Site is missing", vbInformation, "ExcelFox.com"
>> >> Me.TextBox1.SetFocus
>> >> End If
>> >> End Sub
>> >>
>> >> Private Sub CommandButton2_Click()
>> >> Unload Me
>> >> End Sub
>> >>
>> >> Function FileIsOpen(ByVal FileName As String) As Boolean
>> >>
>> >> Dim ff  As Long
>> >>
>> >> On Error GoTo Xit
>> >> ff = FreeFile()
>> >> Open FileName For Random Access Read Write Lock Read Write As ff
>> >> Close ff
>> >> FileIsOpen = False
>> >> Exit Function
>> >> Xit:
>> >> Close ff
>> >> FileIsOpen = True
>> >> End Function
>> >>
>> >>
>> >> In I1 enter the network path.
>> >>
>> >>
>> >> Kris
>> >> ExcelFox
>> >>
>> >> --
>> >> Join official facebook page of this forum @
>> >> https://www.facebook.com/discussexcel
>> >>
>> >> FORUM RULES (1120+ members already BANNED for violation)
>> >>
>> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will
>> >> not get quick attention or may not be answered.
>> >>
>> >> 2) Don't post a question in the thread of another member.
>> >>
>> >> 3) Don't post questi

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

[Paul]

Hi Don,

Is there an address that contains your solution as it does not display in 
either of the below URLs: 

http://x61.ch/ee9a3f (google home page)

*http://tinyurl.com/85lubjc* (google search using original post title)

Thanks.
Paul

On Saturday, 31 March 2012 13:55:49 UTC+11, George cui wrote:
>
> Don Guillett ,
>
> Thanks Great.
>
> On Fri, Mar 30, 2012 at 8:54 PM, dguillett1 
> > wrote:
>
>>   try
>>  *http://tinyurl.com/85lubjc* 
>>  
>> ‘
>> https://www.google.com/#hl=en&sugexp=epsugrstma&gs_nf=1&tok=fmljWU-Ihu1jot1KsCdb-w&cp=46&gs_id=9&xhr=t&q=read+sap+ECC6+table+content+to+excel+using+VBA&pf=p&output=search&sclient=psy-ab&oq=read+sap+ECC6+table+content+to+excel+using+VBA&aq=&aqi=&aql=&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=9b0c83a130f3bca0&biw=1066&bih=670
>>  
>>   
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguil...@gmail.com 
>>   
>>  *From:* Garcia  
>> *Sent:* Thursday, March 29, 2012 9:20 PM
>> *To:* excel-...@googlegroups.com  
>> *Subject:* Re: $$Excel-Macros$$ read sap ECC6 table content to excel 
>> using VBA
>>  
>> Hi, Don Guillett, 
>>  
>> sorry ,i can not open  http://x61.ch/ee9a3f , this link can not work,the 
>> link is change to  https://www.google.com/ .Thanks.
>>  
>> Garcia
>>
>>
>> On Thursday, March 29, 2012 8:28:40 PM UTC+8, Don Guillett wrote: 
>>>
>>>   http://x61.ch/ee9a3f
>>>  
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguil...@gmail.com 
>>>   
>>>  *From:* Garcia  
>>> *Sent:* Thursday, March 29, 2012 3:03 AM
>>> *To:* excel-...@googlegroups.com  
>>> *Subject:* $$Excel-Macros$$ read sap ECC6 table content to excel using 
>>> VBA
>>>  
>>> Hi,expert, 
>>> can you help me to read sap table content (ECC 6) to excel with VBA,it's 
>>> really thanks for your help.
>>> Garcia
>>> -- 
>>> FORUM RULES (986+ members already BANNED for violation)
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>>  
>>> 2) Don't post a question in the thread of another member.
>>>  
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>  
>>> 4) Acknowledge the responses you receive, good or bad.
>>>  
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>>  
>>> --**--**
>>> --**
>>> To post to this group, send email to excel-...@googlegroups.com
>>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-...@googlegroups.com
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-...@googlegroups.com
>>
>
>
>
> -- 
> Best Regards
> George
>
> 

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

FORUM RULES (1120+ members already BANNED for violation)

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

Re: $$Excel-Macros$$ Hiiiiiiiiiii

[VBA VABZ]

hi

Really nice..

Rgds

On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU)  wrote:

>  To all my dear friends,
>
> ** **
>
> Nice Excel filewith ABCD on Friendship...
>
> Please see the attachment and click on flowers.
>
> Best Regards,
>
> Amit
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: need guidance in learning macros and VBA

[vba]

Hi Prince,

Itz really great source of info.

Thanks for sharing..

Cheerz

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Prince Dubey 
Sender: excel-macros@googlegroups.com
Date: Sun, 23 Sep 2012 06:13:37 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: need guidance in learning macros and VBA

Hi Ram Gopal,


Please see these links these will help you to learn.
 http://home.pacbell.net/beban   http://excel.tips.net   
http://www.andrewsexceltips.net/   http://www.andypope.info/   
http://akoul.blogspot.com   http://www.ashishmathur.com   
http://www.discussexcel.com   http://members.aol.com/Machero   
http://www.exceluser.com/   http://www.cpearson.com   
http://www.excelhero.com/   http://dj.joss.free.fr/   
http://www.mvps.org/dmcritchie/excel/excel.htm   
http://www.contextures.com/tiptech.html   http://www.dailydoseofexcel.com/   
https://mvp.support.microsoft.com/profile/Dilip.Kumar.Pandey   
http://www.edferrero.com   http://www.prodomosua.eu   http://www.vbapro.com   
http://www.longhead.com/   http://www.jkp-ads.com   http://www.lacher.com   
http://spreadsheetpage.com   http://www.peltiertech.com/   
http://exceler.blogspot.com   http://www.excelguru.ca   
http://xcell05.free.fr   http://puremis.net/excel/   
http://www.datapigtechnologies.com   http://www.jumper.ch   
http://www.nickhodge.co.uk   http://ExcelExperts.com  
 
http://orlando.mvps.org   http://www.xl-expert.com   http://www.appspro.com   
http://www.r-cor.com   http://www.beyondtechnology.com   
http://www.rondebruin.nl   
http://www.ExcelExpertTraining.com   
http://www.oaltd.co.uk   http://users.quick-line.ch/ramel/   
http://www.turedata.se   http://www.tushar-mehta.com   
http://www.vbaexpress.com   www.ozgrid.com   
www.excelpoweruser.wordpress.com 
[MyBlog]   
www.ozgrid.com   akoul.posterous.com   www.mrexcel.com   www.contextures.com   
www.rondebruin.nl   peltiertech.com   chandoo.org   www.mvps.org/links.html   
www.vbaexpress.com   www.functionx.com   www.freevbcode.com   
www.excelforum.com   https://www.facebook.com/ExcelLover   
https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897   
https://www.facebook.com/microsoftexcel   
https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2F&h=014d2&ref=ts
   
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
   
http://www.excelvbamacros.com/   http://ashish-msaccess.blogspot.com/   
http://www.facebook.com/groups/163491717053198/   
http://www.facebook.com/groups/214214011997936/   
http://www.facebook.com/pages/Access-VBA-Macros-Codes/212032078844161   
http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 


On Sunday, September 23, 2012 9:57:47 AM UTC+5:30, ram gopal yadav wrote:
>
> Hi all,
>
> Please tell me the books or video links useful for learning macros and 
> VBA. 
>
> Looking for valuable advice. Thanks in advance.
>
>
> Regards.
>
> RAM GOPAL YADAV
> Mobile No's:- 08130155401,
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebo

Re: $$Excel-Macros$$ Magicc!! juz for fun..

[VBA VABZ]

Hi..

I mean u can do this on any excel file..

Rgds

On Sat, Sep 22, 2012 at 2:55 PM, Rajan_Verma wrote:

> *File??*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vabz
> *Sent:* 22 September 2012 2:51
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Magicc!! juz for fun..
>
> ** **
>
> Hi,
>
> ** **
>
> Jus save your file before doing this trick!!
>
> ** **
>
> 
>
> ** **
>
> Press Ctr + H in excel, in find what type * (star / astrix), leave all
> other column blank..
>
> ** **
>
> ** **
>
> In options keep every thing untick & hit enter..
>
> ** **
>
> 
>
> ** **
>
> ** **
>
> Cheers!!
>
> ** **
>
> Rgds//Vabs
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ VSTO

[joseph . camill]

Hi,

Does anyone have any VSTO tutorial.

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

[reshma shri]

Hi  Bhasker 

I too am a  medical transcriptionist and if its not too much for me to ask 
can u give the tool u use to find wav file length in XL and explain how to 
use it.

Regards
Reshma

On Friday, July 9, 2010 6:26:11 PM UTC+5:30, Bhasker wrote:
>
>  Hi
>>  
>> I am a medical transcriptionist by profession, I am in requirement of one 
>> tool where i can find the duration of a set of files, the dictation files 
>> can be in wav, dss, and mp3 format, can anybody help in this regard, I have 
>> a tool it does generate list only for dss and wav not for mp3 in an excel 
>> sheet with the serial number, wave file name, duration. I am attaching the 
>> excel sheet for the reference.
>>
>> Regards
>>
>>
>> Bhasker
>>
>
>
>
> -- 
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Help for VBA code (Excel Table copy to word)

[amar takale]

Hi All Experts
I need VBA code for Excel table paste in word on one click.If I Select
Table or range for one or more table Then click Button then automatically
Table paste  in word with format which format in excel.
Regards
Amar

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ VBA Macro

[Swapnil Palande]

Hi Shrinivas,

Can u provide code.

Regards,

Swapnil.

On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde wrote:

> Dear All
> Some days back I was trying to write macro and I could write small macro.
> While practising many times I found Error messagr
> Like "Run Time Error 402 "
> But I cant undrstand meaning of this
>
> Is there any documents which can explain all types of error.
>
> --
> Shrini
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Re: Help for VBA code (Excel Table copy to word)

[Vabz]

Hi

Please refer  link :

Rgds//Vabs


On Thursday, September 27, 2012 11:09:18 AM UTC+5:30, amar takale wrote:
>
> Hi All Experts
> I need VBA code for Excel table paste in word on one click.If I Select 
> Table or range for one or more table Then click Button then automatically 
> Table paste  in word with format which format in excel.
> Regards 
> Amar
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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