Problem having my data populate my word documents when pulled from my excel form
up vote
-1
down vote
favorite
Can anyone help in resolving this issue I am having with information being passed from excel to word. I took over this workbook which is used to create a documents in excel and then pass certain information to word documents. Before we upgraded to Office 365 this worked without an issue the excel docs populated without an issue as did the word docs.
When we started to re-use this workbook I had to modify it due to the file management application that housed the word docs was decommissioned and I now have them reside on the PC itself. I had an issue with them when they were housed on Teamsites and the better option was to have them pull from the computer. After some research I was able to get the Word docs to open in VBA when the specific ones were required.
Now the issue that I am having is that it will populate the first document with the information needed. However, if you to populate more than one form with the customer's information it doesn't populate in the word document. I placed a series of message boxes in front of fields being passed and they are populating with the needed data however that data is not getting transferred from excel to word after the first instance. I've verified each field in word that is to be populated is bookmarked and don't see that as the problem. Not cure it it is the open word call that is causing the data to be cleared or not since it does show in my message boxes.
Any help with this would be much appreciated. Thanks
excel vba ms-word
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
add a comment |
up vote
-1
down vote
favorite
Can anyone help in resolving this issue I am having with information being passed from excel to word. I took over this workbook which is used to create a documents in excel and then pass certain information to word documents. Before we upgraded to Office 365 this worked without an issue the excel docs populated without an issue as did the word docs.
When we started to re-use this workbook I had to modify it due to the file management application that housed the word docs was decommissioned and I now have them reside on the PC itself. I had an issue with them when they were housed on Teamsites and the better option was to have them pull from the computer. After some research I was able to get the Word docs to open in VBA when the specific ones were required.
Now the issue that I am having is that it will populate the first document with the information needed. However, if you to populate more than one form with the customer's information it doesn't populate in the word document. I placed a series of message boxes in front of fields being passed and they are populating with the needed data however that data is not getting transferred from excel to word after the first instance. I've verified each field in word that is to be populated is bookmarked and don't see that as the problem. Not cure it it is the open word call that is causing the data to be cleared or not since it does show in my message boxes.
Any help with this would be much appreciated. Thanks
excel vba ms-word
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in thehelpabout asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.
– Cindy Meister
Nov 19 at 22:44
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
Can anyone help in resolving this issue I am having with information being passed from excel to word. I took over this workbook which is used to create a documents in excel and then pass certain information to word documents. Before we upgraded to Office 365 this worked without an issue the excel docs populated without an issue as did the word docs.
When we started to re-use this workbook I had to modify it due to the file management application that housed the word docs was decommissioned and I now have them reside on the PC itself. I had an issue with them when they were housed on Teamsites and the better option was to have them pull from the computer. After some research I was able to get the Word docs to open in VBA when the specific ones were required.
Now the issue that I am having is that it will populate the first document with the information needed. However, if you to populate more than one form with the customer's information it doesn't populate in the word document. I placed a series of message boxes in front of fields being passed and they are populating with the needed data however that data is not getting transferred from excel to word after the first instance. I've verified each field in word that is to be populated is bookmarked and don't see that as the problem. Not cure it it is the open word call that is causing the data to be cleared or not since it does show in my message boxes.
Any help with this would be much appreciated. Thanks
excel vba ms-word
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
Can anyone help in resolving this issue I am having with information being passed from excel to word. I took over this workbook which is used to create a documents in excel and then pass certain information to word documents. Before we upgraded to Office 365 this worked without an issue the excel docs populated without an issue as did the word docs.
When we started to re-use this workbook I had to modify it due to the file management application that housed the word docs was decommissioned and I now have them reside on the PC itself. I had an issue with them when they were housed on Teamsites and the better option was to have them pull from the computer. After some research I was able to get the Word docs to open in VBA when the specific ones were required.
Now the issue that I am having is that it will populate the first document with the information needed. However, if you to populate more than one form with the customer's information it doesn't populate in the word document. I placed a series of message boxes in front of fields being passed and they are populating with the needed data however that data is not getting transferred from excel to word after the first instance. I've verified each field in word that is to be populated is bookmarked and don't see that as the problem. Not cure it it is the open word call that is causing the data to be cleared or not since it does show in my message boxes.
Any help with this would be much appreciated. Thanks
excel vba ms-word
excel vba ms-word
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
edited Nov 19 at 22:42
Cindy Meister
13.8k102034
13.8k102034
asked Nov 19 at 22:37
Anthony Fusco
1
asked Nov 19 at 22:37
Anthony Fusco
1
asked Nov 19 at 22:37
Anthony Fusco
1
1
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in thehelpabout asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.
– Cindy Meister
Nov 19 at 22:44
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27
add a comment |
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in thehelpabout asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.
– Cindy Meister
Nov 19 at 22:44
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in the
help about asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.– Cindy Meister
Nov 19 at 22:44
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in the
help about asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.– Cindy Meister
Nov 19 at 22:44
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53383651%2fproblem-having-my-data-populate-my-word-documents-when-pulled-from-my-excel-form%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53383651%2fproblem-having-my-data-populate-my-word-documents-when-pulled-from-my-excel-form%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It's not possible to even begin to guess what the problem might be based on the limited information in the question. I recommend you read in the
helpabout asking questions efffectively on Stack Overflow and work on providing a Minimal, Complete, and Verifiable example.– Cindy Meister
Nov 19 at 22:44
"Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers."
– Tim Williams
Nov 19 at 23:27