Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Quote ? (MS Office 2000)

    Hi there! Someone has given me the task of finding out how long it would take to come up with a VBA program that would take a whole collection of documents - create new ones based on a new template and copy the guts from the old one and paste them into the new one? Document properties are being used for title and subject, company name and several custom properties.

    Would this be possible at all - or just the twisted fantasy of some management type!

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    Its possible, I've done something like that already.

    If you know VBA then it shouldn't been too difficult.

    To get the framework in place should take about 2 to 5 days and then to develop the section to rip the information from the old document and place it in the new should take about 2 or 3 days per basic document layout of 1 to 4 pages.

    These are estimated times which includes some basic tesing and is dependant on your knowledge of and versatility in VBA and the speed of you machine and complexity of the documents.

    Hope this helps!

    James

  4. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VBA Quote ? (MS Office 2000)

    The complicated part is apr

  5. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    In effect, do you just want to apply a new template to each document and set some document properties?

  6. #5
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    Yes - that's the long and the short of it. However, I have almost 7000 documents to do - and they are not in a single directory structure. The "suggestion" given to me was to have someone write the code and then someone else just has to push "start" and POOF ... VOILA ... we're done.

  7. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    THe hardest part of such code would be the interface to allow you to select the files/directories.

    You could pay someone, like me, to write such a macro, but such discussions are more appropriate offline.

  8. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    I think there are probably 1000's of such VBA programs out there. I too have written an entire document assembly program in VBA that does what your boss wants. There are also OTS (off the self) products that are just waiting for you to slap in the templates and define the parameters.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #8
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VBA Quote ? (MS Office 2000)

    For reasons described above, I don't think that's the hardest part. An example is attached. (This is a .DOT temporarily renamed to .DOC for ease of posting.) (At some point I stopped sorting the folder names; I can't recall why.)
    Attached Files Attached Files

  10. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    It's the hardest part because the original querstion did not specify how to identify the files or directories to be converted.

    As I recall, there were a few thousand files involved.
    Unless those are all in a single directory tree, the interface for finding the files could be complex.

  11. #10
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    Me too.

    The problem is NIH (Not Invented Here), the algorithms/interfaces used to identify the files can differ.

  12. #11
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Ontario, Canada
    Posts
    382
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rule Violation

    Howard:

    Advertising a private service or soliciting business is in violation of <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/rules.pl?Cat=>Rules</A> 10 and 12 for the Lounge.

    Please stop offering your private consulting services on these boards.

    Rule 10: Do not make Private requests
    Please keep your questions and answers on the open boards. We discourage sending or asking for replies via email or Private Message. This defeats the purpose of the Lounge which is designed to share information as widely as possible. If you are worried you will miss any replies, check the box to receive email notifification. You can also set this globally in the Email/Subscriptions section of your Profile.

    Rule 12: No Spam, Blatant Advertising or Soliciting
    This is rare here as well. Just don't post an advertisement or offer a service for compensation. You can place your urls etc. in your signature. Also, you can recommend sites that may help people (your own included) - but only if it answers or helps to answer a question that has been asked within the topic in which you are posting. Spam will be deleted.
    <big><big><font color=blue>Ian</font color=blue></big></big>
    Admin

  13. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    > have almost 7000 documents to do - and they are not in a single directory structure.

    I do this all the time - maybe I want to replace the header on a set of web pages, or want to convert 70,000 WP51 docs to Word, or maybe I want to detect which, of 20,000 docs, have the string "Christopher Greaves" within them.

    Grab/ask for a copy of my Files processor. It does all the dirty work of determining which FILES (more embracing than DOCuments) you want to process; you can nominate a directory tree, extent, file size ranges, date modified ranges etc etc; you can effect a random sample (for a trial run).

    Files processor will open each nominated file and pass control to a macro called "Process"; it will build a dummy Process macro in your Normal.dot, if you want it to.


    Your process macro then invokes whetever you want.



    If i want to generate an Index in each of 15,000 documents, my process macro looks like this:-

    <pre>Sub Process
    Application.Run "IndexActiveDocument"
    ActiveDocument.Save
    ActiveDocument.Close
    End Sub
    </pre>


  14. #13
    New Lounger
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Quote ? (MS Office 2000)

    In order to find the files on the hard drive, consider going to the msdn.microsoft.com and downloading the filects.exe file. When it expands, it provides you with a sample VB program that will locate files with a specific extension and will search directory and subdirectories for all files with a specific extension. If the documents that you were looking for where in client subdirectories below a directory marked client, when pointed to client, this program will search all the folders below client for word documents( files ending with the extension *.doc).
    Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •