Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

2015-02-15 Thread Gaurav Devrani
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

2015-02-14 Thread Vaibhav Joshi
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

2015-02-13 Thread Gaurav Devrani
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

2015-02-13 Thread Vaibhav Joshi
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

2015-02-13 Thread Gaurav Devrani
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

2015-02-13 Thread Eugenio Grant
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

2015-02-12 Thread Gaurav Devrani
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

2015-02-11 Thread Gaurav Devrani
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

2015-02-11 Thread Eugenio Grant
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.