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 wrote: > *@ Krishna, waiting for your reply. :)* > > > > On Wed,

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 wrote: > *@ Krishna, no Sir; still showing the same error! > * > > > > On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar wrote: > >> .Range("b" & LastRow).Resize(, 4) = Split(Me.TextBox2.Value & "|" & >> M

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 viola

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

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 t

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 wrote: > @ Krishna, thanks a lot Sir, it's working fine.but

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 wrote: > Hi > > Replace the commandbutton1 code with this one. > > Private Sub CommandButton1_Click() > Dim wbkActive As Workbook > Dim FilePathAs String > Dim FileNameAs S

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

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 wrote: *@ 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;

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

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 wrote: > @Krishna, thanks for the solution, but one problem is there, when I'm using > the below mention code

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

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

2012-09-23 Thread Indrajit $nai
rom a single master file to them. If it's possible >> through >> >> any other idea, then please share with me. >> >> >> >> Thanks & Regards, >> >> Indrajit >> >> >> >> >> >> >> >> On Sat, Sep

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

2012-09-23 Thread Indrajit $nai
te: > >>> > >>> And my question is why have 200 files. Provide a sample master file > and a > >>> sample slave file. > >>> > >>> Don Guillett > >>> Microsoft Excel Developer > >>> SalesAid Software > >>> dguille...@g

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

2012-09-23 Thread Indrajit $nai
;> Don Guillett >> Microsoft Excel Developer >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Indrajit $nai >> *Sent:* Saturday, September 22, 2012 9:03 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Requir

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 d

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 cr

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

2012-09-22 Thread Indrajit $nai
; > *+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$$ Requi

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