Project Detail

VBA Macro Add-in for MS Word   Refundable $5 fee paid

VBA Macro Add-in for MS Word is project number 523628
posted at GetAFreelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status: Open

Selected Providers: -

Budget: $30-250

Created: 11/06/2009 at 6:03 EST

Bid Count: 9

Average Bid:
$ 228

01/02/2010 at 6:03 EST (42d 6h left)

Project Creator: dxdc View PM Post PM
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (6 reviews)

Bid On This Project
 

Description

I need a word macro / plugin designed for MS Word. It needs to work in Mac OS X and Windows, but if you can only do one, then it must be Mac.

Here are the details:

I have a word document with multiple OLE (Windows) or EGO (old-format for Mac) embedded pictures from a drawing program. These pictures are all labeled with numbers (the numbers are drawn inside the drawing program, but render as text if you make a PDF of the word document). Number formats could be 1,2,3 or 1a,1b, 1c, or roman numerals. More importantly, these numbers are used in the document text. For example, I would say "Look at picture 34 (see Page 12). It is an apple."

The problem is that sometimes I wish to add or delete a picture. For example, where picture #23 is, I want to add a new picture. New picture-->#23, old picture #23-->#24. This not only means I have to renumber all pictures, but also renumber all the times I mention it in the text. It is very time consuming on documents > 20 pgs.


Part 1: Database
-------------
A database needs to be created that is easily manageable, and also combinable with portions of databases from other word documents.

This database needs to contain:

1. Text description (5 fields)
2. Picture (copy/paste from drawing program)
3. Number (more on this later)

Part 2: Referencing
--------------
Inside the word document, there needs to be a way to view the database elements, and insert them as cross-references inside the text.

For example, let's say you have an entry in the database:

Description Picture Number
-------------------------------------------
Apple in Tree a picture of apple in a tree 34

Then you should be able to view the picture, apple in a tree, and #34, and then insert the number 34 OR the picture OR the text description as a cross-reference inside the document.

Part 3: Number manipulation
----------------------
There should be an easy way to insert and modify numbers. For example, increase all numbers by 1. Or insert a space between numbers 2 and 3. Then the user can update the document and all the cross-references will automatically update.


Part 4: Number manipulation inside pictures
----------------------------------
If numbers can be changed inside OLE or EGO drawing objects that would be most preferred. It is not required if this is very difficult though, since all pictures can be renumbered inside drawing program.


Thank you for your interest

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 
View PM Post PM

200

10 days

11-14-2009 15:03 EST

Dear Outsource, ************************** Welcome to Triffort Technologies ********************** We have done same kind of work and our technical team is expert to complete this project with “Zero Defect Solution Deliver” to client. Please check PM. Thanks & Regards Triffort Team

help

 
View PM Post PM

175

1 day

10-07-2009 20:21 EDT

(No Feedback Yet)

Could you give me the sample document together with the OLE object inside for my reference? This is do-able by using VBA/Macro instead of Add-In considering the VBA/Macro can be re-used under Mac version of Office/Word. Let me know the sample first.

help

 
View PM Post PM

175

7 days

10-08-2009 09:50 EDT

(No Feedback Yet)

i do this job

help

 
View PM Post PM

750

3 days

11-06-2009 21:40 EST

(No Feedback Yet)

I'd like to propose a new model on how to achieve what you seek. I propose using Excel as the 'database' (sic) and VBA to automate the process of flexibly creating/populating the Word document. In Excel you'll have four columns: Tag (see below), Title, Description, FileName. For your apple example, values might be "APP", "Applie In Tree" "This is an apple in a tree" "C:\Whatever\Apple.jpg". Within Word when you need to refer to a picture and its attribute you would enter a special code whose prefix is the Tag value and whose suffix is the attribute, enclosed in a set of special characters. To assert the value of the title of the apple picture, you'd enter "<>" within Word. There is a special tag, not defined in the database/worksheet for number. So to assert a reference to the number of the apple picture, you'd use "<>" in the Word text. The key here is to separate the data about the image from its use in a particular Word document. The data about the image is (comparatively) fixed; its number is flexible. To implement this, you would have a document-specific worksheet in Excel with two columns: TAG and NUMBER. The TAG number cross-reference the TAG value in the master worksheet (defined above). The "NUMBER" value is whatever number you want to give it in the current round of creating the Word document. Within Word (or Excel, your choice) the proverbial "magic button" would do search the Word document for entries like "<>" or "<>", look within Excel to decode those, and assert the desired string within Word. If you want to renumber the images at any time, you'd go to the document-specific page within Excel and add/delete/edit the rows there, re-press the "magic button" and you'd have the new order appear in the Word document. This is a variant of a feature I've had working for a number of years in a commercial application and in a in-house application for a client. There are some gotchas here like how to handle typos within the Word flags (e.g. "<>") or unterminated flags (e.g. "<<APP_TITLE") of course, but these are already accommodated in the core code. The end result for you is high stability in the core information about an image in the master worksheet and easy flexibility in adding, deleting or renumbering images for any given generation of any given Word document in the document-specific sheet. Support for multiple Word documents using a common image library is effectively built into the application. Note that the image itself is stored in a separate file. VBA only needs to know where to find the image on your disk. When you press the magic button VBA will do the copy and paste for you. Changing the image of the number within the graphic file will need to be done outside this solution. That's a tough one for any application as it would first have to find/erase the current number within the image then assert a new value. If your image files are done in layers, with the numeric value a layer unto itself, then we can talk about how that may be handled as well. Enough! I'm sure you'll have lower bids, but I doubt others can offer you a solution which has been out in the market for 5+ years used in companies like Ayco, Merrill, Wells Fargo etc. If you'd like to see a variant of this in action, I'd be glad to show it to you in a remote session. I look forward to making direct contact with you about this project. = M =

help

 
View PM Post PM

35

28 days

11-07-2009 00:25 EST

(No Feedback Yet)

I'm abel to do this job.

help

 
View PM Post PM

150

10 days

11-07-2009 02:09 EST

(No Feedback Yet)

I will try my best to ensure all of your needs within this perod of time.

help

 
View PM Post PM

170

7 days

11-07-2009 11:52 EST

(No Feedback Yet)

its very easy...i like to provide a good sevice... thanx

help

 
View PM Post PM

300

15 days

11-11-2009 18:49 EST

(No Feedback Yet)

There may be several ways to handle this issue. I don't want to steal Marchand's ideas, but his way of going about this is a good one. (Marchand, you probably shouldn't post your ideas in such detail! As I try to think of ways to create this macro, I can't help but remember what you said!) Using an Excel sheet as the database is indeed the best way to go. Is it really important that the number of each picture in the database be reflected in the Word doc? Or can they be "0001", "0002", "0003" in the database and "Figure 1, Figure 2, Figure 2a" in the Word document? (Oops, that's what Marchand calls TAG and NUMBER. Well, he's right.) To solve your renumbering problem, I think we can use some of the built-in functions of Word that automatically renumber figures and the references to those figures. I'd like to work on this with you. I don't have an existing application that I can adapt, but I still believe that I can give you the final product in two weeks. Thanks for your time!

help

 
View PM Post PM

100

3 days

11-14-2009 07:32 EST

(No Feedback Yet)

Hi, I recently faced a similar problem and I use a solution without a database. However, I can modify it easily and quickly to provide you the solution with a database. I have more than 8 years of experience doing similar kind of work and I would appreciate a chance to work on this project with you. Thanks!

help


    Bid on this Project