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

2015-08-18 Thread Daniel Dias
Hi Unable to download files. pls could you mail this to my id. dias.da...@gmail.com Regards On Sunday, 7 October 2012 14:58:10 UTC+5:30, Bullet wrote: *@ Krishna, Sir right now it's working fine.thanks a lot for all your kind support throughout. :) it's really make my job simpler.*

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

2012-10-07 Thread Indrajit $nai
*@ Krishna, Sir right now it's working fine.thanks a lot for all your kind support throughout. :) it's really make my job simpler.* * * * * *Thanks Regards,* *Indrajit* * * On Wed, Oct 3, 2012 at 7:27 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, waiting for your

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

2012-10-03 Thread Indrajit $nai
*@ Krishna, waiting for your reply. :)* On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, no Sir; still showing the same error! * On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar krishnak...@gmail.comwrote: .Range(b LastRow).Resize(, 4) =

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

2012-10-02 Thread Krishna Kumar
Replace Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) with Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value, |) Kris On Tue, Oct 2, 2012 at 2:47 PM, Indrajit $nai talk2indra...@gmail.com wrote: @ Krishna, thanks a lot Sir, it's working

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

2012-10-02 Thread Krishna Kumar
in this line it should be 3 .Range(b LastRow).Resize(, 3) in your code it's 4 Kris 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

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

2012-10-02 Thread Indrajit $nai
*@ Krishna, but Sir, still it's showing the same error!!!* On Tue, Oct 2, 2012 at 4:10 PM, Krishna Kumar krishnak...@gmail.com wrote: in this line it should be 3 .Range(b LastRow).Resize(, 3) in your code it's 4 Kris Kris ExcelFox -- Join official facebook page of this forum @

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

2012-10-02 Thread Krishna Kumar
.Range(b LastRow).Resize(, 4) = Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value | Me.TextBox4.Value, |) Kris ExcelFox -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

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

2012-09-29 Thread Indrajit $nai
*@ Krishna, thanks a lot Sir. Lemme try this :)* On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim

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

2012-09-28 Thread Indrajit $nai
*@ Krishna, Sir I'm waiting for your reply. :)* * * On Thu, Sep 27, 2012 at 2:38 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, thanks for

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

2012-09-28 Thread Krishna Kumar
Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive =

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

2012-09-26 Thread Indrajit $nai
*@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ 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,

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

2012-09-25 Thread Krishna Kumar
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 talk2indra...@gmail.com wrote: @Krishna, thanks for the solution, but one problem is there, when I'm using

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

2012-09-24 Thread Krishna Kumar
Provide a meaningful workbook. So that one could understand what's going on. 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

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

2012-09-24 Thread Krishna Kumar
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

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

2012-09-23 Thread Indrajit $nai
$nai talk2indra...@gmail.com *Sent:* Saturday, September 22, 2012 9:03 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create

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

2012-09-23 Thread Indrajit $nai
? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 22 September 2012 7:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required help in Work Allocation VBA based

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

2012-09-23 Thread Indrajit $nai
Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file

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

2012-09-22 Thread Rajan_Verma
in Work Allocation VBA based excel file. Hi All, I wanna a create Work Allocation VBA based excel file, here-under is my requirement. 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone

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

2012-09-22 Thread Indrajit $nai
]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 22 September 2012 7:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. ** ** Hi All, ** ** I

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

2012-09-22 Thread Rajan_Verma
] On Behalf Of Indrajit $nai Sent: 22 September 2012 7:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created

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

2012-09-22 Thread dguillett1
-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during