By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,644 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,644 IT Pros & Developers. It's quick & easy.

Form to populate Excel worksheet and Word document

P: 1
I have an Excel 2007 worksheet that I enter customer data into and from that a portion of the data is entered into a contract in Word 2007. Currently I have linked data from the Excel worksheet to the Word document but it only works on my computer unless I update the many links on each of the machines that it needs to be available on. Alternatively, I can set the root of the two files to C:\ but Id like the documents to be usable by anyone; some of which I know to be computer illiterate, and Id like it to be emailable if at all possible. I also have SharePoint and understand that I can place this all in a document library. I recently began researching VBA and XML but I havent had much time behind the keyboard on these. Id like to not only have a clean and professional looking form that can be filled out buy "anyone" but also have the option of having the two documents automatically emailed once generated. Am I biting off more than a novice can chew? Is there a simpler way to accomplish this with XML via Excel/Word 2007? If not, can this even be accomplished with VB Express 2005? Any help or guidance would be greatly appreciated!
Dec 6 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.