Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
okay... Thanks Vaibhav. On Sat, Feb 14, 2015 at 5:43 AM, Vaibhav Joshi v...@vabs.in wrote: I mean free file.. On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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)
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
I mean free file.. On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Hi Vaibhav, What is FF? Can you please tell me ? Dont have any idea about that please. On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi v...@vabs.in wrote: Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Cheers, also you could have created FF save it as .doc. On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe . To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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.
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Cool. :) On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Thaks for the complete answer, it works like a charm! On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Hi, Please check the file , On Wed, Feb 11, 2015 at 10:06 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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. -- Thanks Regards Gaurav Devrani -- Are you
Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file
Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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$$ Reestructure Excel File and Save as Word file
Variables identified as type = double should be treated differently in order to adjust to a expected format... On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Why second line need to be restructured in different format. Like Pos3 pos 5 Please let me know. I will work on that. On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant eugenio.gr...@gmail.com wrote: I have a Excel Sheet lile this: type Begin End Text Var simple 1 2 Car v43 double 3 5 Ball v50 I want to reestructure and save to Word, (via VBA or Macro) reestructured like this: [v43] Car simple POS 1 to 2 [v50] Ball double POS 3 POS 5 Thanks for your help. -- 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. -- Thanks Regards Gaurav Devrani -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe. To unsubscribe from this group and all its topics, 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. -- *_* *Eugenio Grant MoraData Procesos**eugenio.gr...@gmail.com eugenio.gr...@gmail.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.