Results 1 to 3 of 3

Thread: Is it possible to save current word document into database as BLOB by Macro or VBA?

  1. Sep 15th, 2005, 10:05 PM #1
    solar115
    solar115 is offline

    Thread Starter
    Hyperactive Member solar115's Avatar
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    268

    Is it possible to save current word document into database as BLOB by Macro or VBA?

    I need to manage my document by migrate into MySQL database as BLOB. Some of my document may be no need to migrate. So I will open and review all of them from MS-WORD then make a dicession that it need to be migrated to MySQL or NOT. I need it to easy as just click on one button in MS-WORD then prompt for some more information then save it to database.

    Is my idea possible to do Macro or VBA?

    FLOW OF WORK in my plan:
    1. Open Document in MS-WORD for review.
    2. If I need to keep this document, just click on some button to start a process.
    3. Prompt some dialog box for ask some more information I need to keep with this document. (ie comment, category)
    4. Then document be saved in database as blob with other information I input.
    5. Do step 1-4 again and again for other documents.
    ^solaris^
    Reply With Quote Reply With Quote
  2. Sep 16th, 2005, 04:03 AM #2
    Dnereb
    Dnereb is offline
    Fanatic Member Dnereb's Avatar
    Join Date
    Aug 2005
    Location
    Netherlands
    Posts
    863

    Re: Is it possible to save current word document into database as BLOB by Macro or VBA?

    Yes it is possible in VBA, but if you do not have any experience with VBA or ODBC it will be a Quest to achieve.
    why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
    for every question you ask provide an answer on another thread.
    Reply With Quote Reply With Quote
  3. Sep 16th, 2005, 05:22 AM #3
    solar115
    solar115 is offline

    Thread Starter
    Hyperactive Member solar115's Avatar
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    268

    Re: Is it possible to save current word document into database as BLOB by Macro or VB

    Thank You,
    I have only little experience on VBA and some more on VB. Whatever I will try and for more information I will back again.
    ^solaris^
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width