Search:

Type: Posts; User: DJ-DOO

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    609

    MsOf03 Setting & Copying Range in Excel

    Hi Folks,

    I'm in the process of writing a simple macro to update a spreadsheet. I am filtering a worksheet for a specific value which I've done, I then need to copy a number of columns and paste...
  2. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I am required to develop a tool to be used within the organisation to allow users to parse relevant chapters of the IS/IP reports. So they wish to be able to click on the relevant chapter to parse. ...
  3. Replies
    8
    Views
    2,220

    Re: Parsing Word doc and export to Excel

    Hi westconn1...any joy after?
  4. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Ed I'm wondering, based on my selection in the multi list box, it is possible to put an 'x' in the corresponding cell in the next column? :confused: That way, I could incorporate your answer into...
  5. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Hi Ed,

    Thank you for putting so much work into the answer for me. :bigyello:

    However, unfortunately, :blush: I'm trying to, once selected, go directly to that bookmark, then set the range...
  6. Replies
    8
    Views
    2,220

    Re: Parsing Word doc and export to Excel

    Hi westconn1

    I've attached a test doc, I've shortened it and I've just substituted the sensitive information with latin ;)...on the index page, there is the TOC & I've listed the relevant bookmark...
  7. Replies
    8
    Views
    2,220

    Re: Parsing Word doc and export to Excel

    Hi

    Could I use bookmarks as I've been discussing with Ed in the vb 6 and earlier forum?

    There is an index page on which all chapters are listed all chapters have hyperlinks, and there are...
  8. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I was wrong the original bookmarks work!!

    _Toc292701022
    _Toc292701023
    |
    |
    V
    _Toc292701074"
  9. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I have managed to locate the bookmarks, they were hidden bookmarks, now unfortunately they aren't in order (numerically).

    e.g.

    _Toc129482794
    _Toc292701023
    _Toc63137014
    _Toc63137015

    these...
  10. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    could you set ranges by heading style rather than bookmarks?? so from one h2 style to the next?? I don't know and again, I'm really appreciative of your help as I'm quite inexperienced in vba, I am...
  11. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I tried putting in the link into goto but to no avail....:(

    How it works at the moment, as I'm running this out of excel vba, I open the workbook (multi list already populated), I tick relevant...
  12. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    ..that's great...thanks...

    I toggled the field codes for the index....

    this is the result....

    {HYPERLINK\|"_Toc292701022"}
    {HYPERLINK\|"_Toc292701023"}
    |
    ...
  13. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Ed_from_AZ...There are already bookmarks within the doc, so I'm just wondering, the word documents I'm working on have an index, each chapter listed in the index has a hyperlink that when clicked...
  14. Replies
    8
    Views
    2,220

    Re: Parsing Word doc and export to Excel

    hi dmaruca...

    The index is in normal style, which lists the chapter headings, and the actual chapter headings are in h2 style. Unfortunately they're .doc files, so I can't parse xml. Could you...
  15. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    hi Ed_from_AZ....sorry I'm running in from within excel vba, not running out of excel...

    the config file is a worksheet within the workbook.

    That's a good idea about setting up the bookmarks,...
  16. Replies
    8
    Views
    2,220

    Parsing Word doc and export to Excel

    Hello Everyone!

    I am a third year student and I am on my work placement I have been assigned a task of parsing 100s of documents and export them to excel. At this time I've only 3 weeks...
  17. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Now that I've changed to vba, maybe I should repost in office development forum
  18. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Hey Guys thank you so much for all of your input. :thumb:

    As per Ed_from_AZ's suggestion I decided to drive from within an application. However, my requirements have since changed slightly.
    ...
  19. Re: Searching MS Word Heading Styles in VB6 for Unique String

    Sure no problem...

    I'm having trouble putting the code into vb tags so I just put it in html tags for easier reading

    The snippet I've posted below is for a batch parse, so I'm parsing all word...
  20. Re: Searching MS Word Heading Styles in VB6 for Unique String

    I am talking about vb6. :p

    I need to parse both paragraph and tabular data from a word document. I have created a macros to parse tabular data. The documents I will be parsing are broken down...
  21. MsOf03 Searching MS Word Heading Styles in VB6 for Unique String

    Hi :wave:

    I'm a third year software design student. I'm currently in the middle of my work placement. I had been asked to create a tool to parse word documents for relevant tabular data and...
  22. Searching MS Word Heading Styles in VB6 for Unique String

    Hi :wave:

    I'm a third year software design student. I'm currently in the middle of my work placement. I had been asked to create a tool to parse word documents for relevant tabular data and...
  23. Replies
    25
    Views
    10,381

    Parsing Word Document & Export to Excel

    Hi...:wave:

    I'm a third year software design student and I'm currently on my work placement. I have never used VB before, but my research has led me to believe that this is the best method...I...
Results 1 to 23 of 23



Click Here to Expand Forum to Full Width