I need VBA code OLE, with Excel 2016 feeding data to a Word 2016 doc
- or -
Post a project like this- Posted:
- Proposals: 4
- Remote
- #1446868
- Expired
Description
Description of excel work: Hi; I found you through a Google search for Excel and Word programming. I need customized programming services; I am trying to link Excel ‘objects’ (can be a table, chart, graph, range, array, and/or cell value that can either be text or numbers) into a ‘container’ Word document for my real estate consulting business. I can walk you through this either over the intent (Skype) or over the phone if you have an interest in helping me on this.
I’ve attached two files – a Word and Excel – to further illustrate.
The goals are the following:
• To come up with a ‘master’ Excel and accompanying Word template, with the Excel populating text, table, and other “objects” into the Word template.
• This master template set must be flexible enough to add/delete/change/modify the values being imported into Word from Excel, at will and without sized, data, or linkage limitations.
• The importing/linking will only ever be one way – all values/objects will always be coming from Excel and going to Word; think of the Word document template as nothing more than a ‘container’ to hold the Excel data objects.
• The code must be written in such a way that if the Excel and Word files are moved and/or copied to other file locations, then ‘re-linking’ the source Excel file to the target Word file won’t have to be done every time, or with every file move.
• There is no limit to the amount of Excel data that can be linked to the Word document.
• Although it is possible, I do not wish to have any math functions performed in Word; only in Excel, and then linked over to the Word container document.
I am trusting that you have done this kind of work before. Perhaps you can just write the code that would allow for what’s described above, as on certain document templates there might be 20 or 50 links, and other could conceivably contains hundreds or more. And then you can just explain the process to me. If I give you massive links to perform, it will get cost-infeasible for me very quickly.
Feel free to reach out if you have any questions. If it helps, I can walk you through the attached Excel and Word to give you an example of what/how I’d like to link.
And, if you cannot help me, would you mid referring me to someone that can?
Thanks very much!
Extra notes:
Greg L.
0% (0)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Greg,
Please send me the files in order to make an accurate purpose.
Thank you,
Antonio -
(1) Please, attach the Excel and Word files as samplesofwhat you have in mind ...
(2) The automatic linkage of files when moved freely by OS file system is not feasible at my point-of-view. They (the files) must be located in a given directory for that purpose. If they are moved without na update at doc file then the links will be broken. Maybe a function to move the files from inside the doc file ? So, when moved, the doc file can know whereis the new location and update "itself" with the new location ... what do you think ?
Thanks.
Adriano Barbosa -
Greg
There is no file attached.
Regards -
Hi - the attachments seem to be missing in the project posting... can you forward those, please? Thanks
-
Hi Greg,
The files don't seem to have been attached. Is it possible to try uploading them again? This looks like the sort of project I would bid for but I need to see some details.
Kind regards,
Simon C.