Vista - Re: Converting a Word doc to a multi-column Excel spreadsheet

01-12-2009

"DD Pgh" <DD Pgh@xxxxxx> wrote in message
news:5B71BC28-88FC-4743-8734-EC7A83EB2B28@xxxxxx

Quote:

>I have a need to convert a Word doc with properly applied formatting styles
> into a multi-column Excel spreadsheet.
>
> I think that this processing would predetermine a format style, like
> Heading
> 1, as the row determinator, such that every time the conversion process
> encountered content tagged with a Heading 1 format style, the converted
> spreadsheet would begin a new row.
>
> This process would then identify the various format styles utilized
> between
> each Heading 1, and convert the content for those styles into the columns
> associated with the row of the Heading 1 which they followed.
>
> In other words, treating Excel as a database, the content tagged with a
> Heading 1 format style would become the record key (in column A), and the
> content associated with each format style following the first Heading 1
> and
> before the next Heading 1 would convert to become fields associated with
> the
> first Heading 1 (in columns B, C, D, etc.).
>
> I understand that this process would require a rigid application of format
> styles, but that is the case for my situation.
>
> I would appreciate any feedback on the topic. Does a vbscript exist for
> such a task, or could one be written?
>
> Thank you.

I think it might be doable, but I don't understand why you would want to do
it in VBScript. Word comes with its own customized scripting language (VBA
for Word) and its own editor and debugging package which makes it easy to
access the Word object model. Excel has its own flavor of VBA specialized
for Excel. You should have an easier learning experience if you try to do
this job in some flavor of VBA.

There are a number of Microsoft newsgroups associated with Word VBA, one of
them being microsoft.public.word.vba.general. There are no Microsoft Excel
newsgroups with VBA in their names, but I think
microsoft.public.excel.programming would be applicable. You might
cross-post yourquestion in those two newsgroups. You might want to say what
versions of Word and Excel this has to be compatible with, and whether
multibyte (Unicode for example) character sets are involved.

-Paul Randall

01-12-2009

this info is very helpful.
I'll post to microsoft.public.word.vba.general and explore Word VBA.
thanks very much!

"Paul Randall" wrote:

Quote:

>
> "DD Pgh" <DD Pgh@xxxxxx> wrote in message
> news:5B71BC28-88FC-4743-8734-EC7A83EB2B28@xxxxxx

Quote:

> >I have a need to convert a Word doc with properly applied formatting styles
> > into a multi-column Excel spreadsheet.
> >
> > I think that this processing would predetermine a format style, like
> > Heading
> > 1, as the row determinator, such that every time the conversion process
> > encountered content tagged with a Heading 1 format style, the converted
> > spreadsheet would begin a new row.
> >
> > This process would then identify the various format styles utilized
> > between
> > each Heading 1, and convert the content for those styles into the columns
> > associated with the row of the Heading 1 which they followed.
> >
> > In other words, treating Excel as a database, the content tagged with a
> > Heading 1 format style would become the record key (in column A), and the
> > content associated with each format style following the first Heading 1
> > and
> > before the next Heading 1 would convert to become fields associated with
> > the
> > first Heading 1 (in columns B, C, D, etc.).
> >
> > I understand that this process would require a rigid application of format
> > styles, but that is the case for my situation.
> >
> > I would appreciate any feedback on the topic. Does a vbscript exist for
> > such a task, or could one be written?
> >
> > Thank you.

>
> I think it might be doable, but I don't understand why you would want to do
> it in VBScript. Word comes with its own customized scripting language (VBA
> for Word) and its own editor and debugging package which makes it easy to
> access the Word object model. Excel has its own flavor of VBA specialized
> for Excel. You should have an easier learning experience if you try to do
> this job in some flavor of VBA.
>
> There are a number of Microsoft newsgroups associated with Word VBA, one of
> them being microsoft.public.word.vba.general. There are no Microsoft Excel
> newsgroups with VBA in their names, but I think
> microsoft.public.excel.programming would be applicable. You might
> cross-post yourquestion in those two newsgroups. You might want to say what
> versions of Word and Excel this has to be compatible with, and whether
> multibyte (Unicode for example) character sets are involved.
>
> -Paul Randall
>
>
>

01-12-2009	#1 (permalink)
Paul Randall n/a posts	Re: Converting a Word doc to a multi-column Excel spreadsheet "DD Pgh" <DD Pgh@xxxxxx> wrote in message news:5B71BC28-88FC-4743-8734-EC7A83EB2B28@xxxxxx Quote: >I have a need to convert a Word doc with properly applied formatting styles > into a multi-column Excel spreadsheet. > > I think that this processing would predetermine a format style, like > Heading > 1, as the row determinator, such that every time the conversion process > encountered content tagged with a Heading 1 format style, the converted > spreadsheet would begin a new row. > > This process would then identify the various format styles utilized > between > each Heading 1, and convert the content for those styles into the columns > associated with the row of the Heading 1 which they followed. > > In other words, treating Excel as a database, the content tagged with a > Heading 1 format style would become the record key (in column A), and the > content associated with each format style following the first Heading 1 > and > before the next Heading 1 would convert to become fields associated with > the > first Heading 1 (in columns B, C, D, etc.). > > I understand that this process would require a rigid application of format > styles, but that is the case for my situation. > > I would appreciate any feedback on the topic. Does a vbscript exist for > such a task, or could one be written? > > Thank you. I think it might be doable, but I don't understand why you would want to do it in VBScript. Word comes with its own customized scripting language (VBA for Word) and its own editor and debugging package which makes it easy to access the Word object model. Excel has its own flavor of VBA specialized for Excel. You should have an easier learning experience if you try to do this job in some flavor of VBA. There are a number of Microsoft newsgroups associated with Word VBA, one of them being microsoft.public.word.vba.general. There are no Microsoft Excel newsgroups with VBA in their names, but I think microsoft.public.excel.programming would be applicable. You might cross-post yourquestion in those two newsgroups. You might want to say what versions of Word and Excel this has to be compatible with, and whether multibyte (Unicode for example) character sets are involved. -Paul Randall
My System Specs

01-12-2009	#2 (permalink)
DD Pgh n/a posts	Re: Converting a Word doc to a multi-column Excel spreadsheet this info is very helpful. I'll post to microsoft.public.word.vba.general and explore Word VBA. thanks very much! "Paul Randall" wrote: Quote: > > "DD Pgh" <DD Pgh@xxxxxx> wrote in message > news:5B71BC28-88FC-4743-8734-EC7A83EB2B28@xxxxxx Quote: > >I have a need to convert a Word doc with properly applied formatting styles > > into a multi-column Excel spreadsheet. > > > > I think that this processing would predetermine a format style, like > > Heading > > 1, as the row determinator, such that every time the conversion process > > encountered content tagged with a Heading 1 format style, the converted > > spreadsheet would begin a new row. > > > > This process would then identify the various format styles utilized > > between > > each Heading 1, and convert the content for those styles into the columns > > associated with the row of the Heading 1 which they followed. > > > > In other words, treating Excel as a database, the content tagged with a > > Heading 1 format style would become the record key (in column A), and the > > content associated with each format style following the first Heading 1 > > and > > before the next Heading 1 would convert to become fields associated with > > the > > first Heading 1 (in columns B, C, D, etc.). > > > > I understand that this process would require a rigid application of format > > styles, but that is the case for my situation. > > > > I would appreciate any feedback on the topic. Does a vbscript exist for > > such a task, or could one be written? > > > > Thank you. > > I think it might be doable, but I don't understand why you would want to do > it in VBScript. Word comes with its own customized scripting language (VBA > for Word) and its own editor and debugging package which makes it easy to > access the Word object model. Excel has its own flavor of VBA specialized > for Excel. You should have an easier learning experience if you try to do > this job in some flavor of VBA. > > There are a number of Microsoft newsgroups associated with Word VBA, one of > them being microsoft.public.word.vba.general. There are no Microsoft Excel > newsgroups with VBA in their names, but I think > microsoft.public.excel.programming would be applicable. You might > cross-post yourquestion in those two newsgroups. You might want to say what > versions of Word and Excel this has to be compatible with, and whether > multibyte (Unicode for example) character sets are involved. > > -Paul Randall > > >
My System Specs

Similar Threads
Thread	Forum
Creating Lables from excel spreadsheet in MS Word	Vista mail
Converting e-mail to Spreadsheet	Vista mail
Problems with converting a Word or Excel Documents to Pdf	.NET General
create Excel spreadsheet without loading Excel	VB Script
Pocket word an excel files not converting properly	Vista General