Dear VAbz, i dont have a special words to say thanks..It's charm.. lax
On Sunday, October 26, 2014 12:56:50 PM UTC+5:30, Vabz wrote: > Hi > > check this.. before generating new file all data will get cleared & post > generate file... > > you will get msg once file is generated and folder containing file will > get opened too > > +++++ > *I did not do this for you. God is here working through me for you.* > > On Sun, Oct 26, 2014 at 11:27 AM, Laxmanan M <laxfly...@gmail.com > <javascript:>> wrote: > >> Dear Vabz, >> >> Thanks for this challenging task..I ran this in my machine and it is >> working as expected..No words to say thanks..One small Q..After ran this >> the output file is getting genereated perfectly.But when close my macro i >> need to clear this result cells and i again make this file as fresh >> one..Also It would be helpful if i have the Pop up msg whcih is saying your >> file is stored in the Specified path once after the .Csv file >> generation.BcozOutput file is generated without any notification. >> >> >> Thanks, >> Lax >> >> >> On Sunday, October 26, 2014 1:29:35 AM UTC+5:30, Vabz wrote: >> >>> Check this... >>> >>> Click blue button to run macro.. >>> >>> When prompted select month name in data sheet, in your case it will be >>> cell AP3 (cell highlighted with green color for current example, you can >>> select any other month too) & you will get output file as desired.. >>> >>> Note, i have kept same file / sheet name in my code you may need to >>> amend it as you needed... >>> >>> >>> Cheers!! >>> >>> +++++ >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Sun, Oct 26, 2014 at 12:15 AM, Laxmanan M <laxfly...@gmail.com> >>> wrote: >>> >>>> Hi pramod and vabz, >>>> Thanks for the help. >>>> >>>> Here I have give the file "sample data"is the data file and we can >>>> apply the code in the same file.the format file is just the output file >>>> data format means the output file should have the data's in the same >>>> format >>>> of the "format".this file should save as .csv extension of the macro ran >>>> file. >>>> Simply saying that the data's of the sample file should save as a .csv >>>> output file with format of "format" file attached in the same post. >>>> >>>> Thanks, >>>> Lax >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros...@googlegroups.com. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
