Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
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.* > > > *Thanks & Regards,* > *Indrajit* > > > On Wed, Oct 3, 2012 at 7:27 PM, Indrajit $nai > wrote: > >> *@ 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 & "|" & 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 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 . >>> >>> >>> >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ 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, 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 & "|" & >>> 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 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$$ Required help in Work Allocation VBA based excel file.
*@ 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 & "|" & >> 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 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$$ Required help in Work Allocation VBA based excel file.
.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 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$$ Required help in Work Allocation VBA based excel file.
*@ 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://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$$ Required help in Work Allocation VBA based excel file.
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 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$$ Required help in Work Allocation VBA based excel file.
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 one thing I'm not > able to understand; > > whenever I'm trying to add some addition TextBox then I'm getting an error > in the below mention lines: > > 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, > ",") > > Like if I want to put "Image No" in the Master file popup form, so that this > "Image No" value also get pasted in the Slave2 file. > Kindly assist me how to do this. > > Thanks & Regards, > Indrajit > > > > > On Sat, Sep 29, 2012 at 2:28 PM, Indrajit $nai > wrote: >> >> @ 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 String >>> Dim wbkOpen As Workbook >>> Dim LastRow As Long >>> >>> If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook >>> >>> FilePath = "C:\Users\Indra\Desktop\" >>> 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" >>> Dim r >>> r = Evaluate("match(""" & Me.TextBox3.Value & >>> """,'MasterSheet'!B4:B1000,0)") >>> >>> 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 >>> If Not IsError(r) Then >>> Cells(r, "f") = "Assigned" >>> End If >>> Else >>> MsgBox "Workbook '" & FileName & "' is already >>> opened" & vbLf & "Close the workbook and try again", vbInformation, >>> "ExcelFox.com" >>> If Not IsError(r) Then >>> Cells(r, "f") = "Unassigned" >>> End If >>> 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 >>> >>> >>> > 1. Through this Master file I'm able to create the slave files, but >>> > it's not >>> > opening, showing an error "invalid format". >>> >>> I'm not sure how you create the slave files. So I can't comment on that. >>> >>> > 3. In the Master file "Batch Assign to" and "Batch Status" is not >>> > updating >>> > after assigning any Batch to the slave file. >>> >>> See the code above. >>> >>> 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 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. >>> ---
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ 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 String > Dim wbkOpen As Workbook > Dim LastRow As Long > > If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook > > FilePath = "C:\Users\Indra\Desktop\" > 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" > Dim r > r = Evaluate("match(""" & Me.TextBox3.Value & > """,'MasterSheet'!B4:B1000,0)") > > 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 > If Not IsError(r) Then > Cells(r, "f") = "Assigned" > End If > Else > MsgBox "Workbook '" & FileName & "' is already > opened" & vbLf & "Close the workbook and try again", vbInformation, > "ExcelFox.com" > If Not IsError(r) Then > Cells(r, "f") = "Unassigned" > End If > 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 > > > > 1. Through this Master file I'm able to create the slave files, but it's > not > > opening, showing an error "invalid format". > > I'm not sure how you create the slave files. So I can't comment on that. > > > 3. In the Master file "Batch Assign to" and "Batch Status" is not > updating > > after assigning any Batch to the slave file. > > See the code above. > > 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 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 Goo
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
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 = ThisWorkbook FilePath = "C:\Users\Indra\Desktop\" 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" Dim r r = Evaluate("match(""" & Me.TextBox3.Value & """,'MasterSheet'!B4:B1000,0)") 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 If Not IsError(r) Then Cells(r, "f") = "Assigned" End If Else MsgBox "Workbook '" & FileName & "' is already opened" & vbLf & "Close the workbook and try again", vbInformation, "ExcelFox.com" If Not IsError(r) Then Cells(r, "f") = "Unassigned" End If 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 > 1. Through this Master file I'm able to create the slave files, but it's not > opening, showing an error "invalid format". I'm not sure how you create the slave files. So I can't comment on that. > 3. In the Master file "Batch Assign to" and "Batch Status" is not updating > after assigning any Batch to the slave file. See the code above. 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 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$$ Required help in Work Allocation VBA based excel file.
*@ 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;* >> * >> * >> *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 tit
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ 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$$ Required help in Work Allocation VBA based excel file.
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 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 questi
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
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 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$$ Required help in Work Allocation VBA based excel file.
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, 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$$ Required help in Work Allocation VBA based excel file.
*@ Group, *suppose I've 200 files in a particular path, now I want to consolidate all of those files data in the master file, I mean to say; in a master file there is a button which will consolidate all the data from those 200 slave file through a single click. Hope it's possible through VBA, if its possible then please provide me the code. *@ Rajan, *thanks for your suggestion. But we don't have MS-Access in our office, only MS-Excel is available. -- 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 Sun, Sep 23, 2012 at 3:22 PM, Indrajit $nai wrote: > Thanks *Krishna*, thanks a lot. :) > > it's a gr8 solution. :) > > -- > 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 Sun, Sep 23, 2012 at 3:05 PM, Krishna Kumar wrote: > >> Hi >> >> Here is a draft version. Work on this and do necessary changes. >> >> >> >> On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai >> wrote: >> > @Group, @ Rajan, @ Don - any solution? >> > >> > Thanks & Regards, >> > Indrajit >> > >> > >> > >> > On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai < >> talk2indra...@gmail.com> >> > wrote: >> >> >> >> @ Rajan, Yes there are 200 files with the same format. I can do the >> >> consolidation part through VBA, it's not a problem. >> >> >> >> It will be like; there should be a button in the master file, whenever >> I >> >> click on the button a Work allocation form will appear, where I'll put >> Batch >> >> Id (unique no), Site name, and the Emp id, then that particular Batch >> will >> >> assign to that emp. when he/she will finish that work, he/she will >> click on >> >> submit button from the slave file and it will reflect to my master >> file too. >> >> >> >> @ Don, thanks for your attention. >> >> >> >> We have almost 200 emp. in our Com., works at the same time. Now I >> want to >> >> allocate work from 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 22, 2012 at 8:45 PM, dguillett1 >> wrote: >> >>> >> >>> 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...@gmail.com >> >>> >> >>> From: Indrajit $nai >> >>> 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 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 updation, that's >> why I >> >>> wanna create this file through VBA, and I'm not so good in VBA. >> Kindly help >> >>> me to create this Work allocation file. >> >>> >> >>> Thanks & Regards, >> >>> Indrajit >> >>> >> >>> >> >>> >> >>> On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma < >> rajanverma1...@gmail.com> >> >>> wrote: >> >>>> >> >&
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
Thanks *Krishna*, thanks a lot. :) it's a gr8 solution. :) -- 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 Sun, Sep 23, 2012 at 3:05 PM, Krishna Kumar wrote: > Hi > > Here is a draft version. Work on this and do necessary changes. > > > > On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai > wrote: > > @Group, @ Rajan, @ Don - any solution? > > > > Thanks & Regards, > > Indrajit > > > > > > > > On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai > > > wrote: > >> > >> @ Rajan, Yes there are 200 files with the same format. I can do the > >> consolidation part through VBA, it's not a problem. > >> > >> It will be like; there should be a button in the master file, whenever I > >> click on the button a Work allocation form will appear, where I'll put > Batch > >> Id (unique no), Site name, and the Emp id, then that particular Batch > will > >> assign to that emp. when he/she will finish that work, he/she will > click on > >> submit button from the slave file and it will reflect to my master file > too. > >> > >> @ Don, thanks for your attention. > >> > >> We have almost 200 emp. in our Com., works at the same time. Now I want > to > >> allocate work from 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 22, 2012 at 8:45 PM, dguillett1 > wrote: > >>> > >>> 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...@gmail.com > >>> > >>> From: Indrajit $nai > >>> 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 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 updation, that's > why I > >>> wanna create this file through VBA, and I'm not so good in VBA. Kindly > help > >>> me to create this Work allocation file. > >>> > >>> Thanks & Regards, > >>> Indrajit > >>> > >>> > >>> > >>> On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma > > >>> wrote: > >>>> > >>>> How you want to Update this file? > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> 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 > >>>> 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 update there respective file, and the > main > >>>> file gets update automatically. > >>>> &
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@Group, @ Rajan, @ Don - any solution?* Thanks & Regards, Indrajit On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai wrote: > *@ Rajan, *Yes there are 200 files with the same format. I can do the > consolidation part through VBA, it's not a problem. > > It will be like; there should be a button in the master file, whenever I > click on the button a Work allocation form will appear, where I'll put > Batch Id (unique no), Site name, and the Emp id, then that particular Batch > will assign to that emp. when he/she will finish that work, he/she will > click on submit button from the slave file and it will reflect to my master > file too. > > *@ Don,* thanks for your attention. > > We have almost 200 emp. in our Com., works at the same time. Now I want to > allocate work from 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 22, 2012 at 8:45 PM, dguillett1 wrote: > >> 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...@gmail.com >> >> *From:* Indrajit $nai >> *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 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 updation, that's why I >> wanna create this file through VBA, and I'm not so good in VBA. Kindly help >> me to create this Work allocation file. >> >> Thanks & Regards, >> Indrajit >> >> >> >> On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma wrote: >> >>> *How you want to Update this file?* >>> >>> ** >>> >>> ** >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 <%2B91%207838100659> [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 >>> 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 update there respective file, and the main >>> file gets update automatically. >>> >>> >>> >>> >>> If it is possible then please provide me the code. Kindly find attached >>> the Work allocation file for your reference. >>> >>> >>> >>> Thanks in advance. >>> >>> >>> >>> >>> >>> -- >>> 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. >>> >>> -- >>> 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) Ackn
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
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...@gmail.com From: Indrajit $nai 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 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 updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks & Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma wrote: How you want to Update this file? 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 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 update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- 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. -- 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 mailto:excel-macros%2bunsubscr...@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
RE: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
Ok, My question is , do you have 200 Different files with Same Format and you want to consolidate All files data into a single workbook within One Worksheet?? 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: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 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks & Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma wrote: How you want to Update this file? 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 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 update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- 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. -- 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 <mailto:excel-macros%2bunsubscr...@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
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. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks & Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma wrote: > *How you want to Update this file?* > > * * > > * * > > *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 > 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 update there respective file, and the main > file gets update automatically. > > > ** ** > > If it is possible then please provide me the code. Kindly find attached > the Work allocation file for your reference. > > ** ** > > Thanks in advance. > > ** ** > > ** ** > > -- > 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. > > -- > 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
RE: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
How you want to Update this file? 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 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 update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- 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. -- 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.